Productivity Pack · Junior to Mid
Excel for Analysts Pack
Formulas, pivot tables, Power Query, data cleaning and the analyst-level Excel interview.
Excel as an analyst uses it: lookup/INDEX-MATCH, pivot, Power Query, and the practical tests employers run.
- Questions
- 360
- Topics
- 20
- Pages
- 250pages
- 360 questions, every one with a model answer
- Formula & function cheat sheet
- Pivot + Power Query walkthroughs
- Data-cleaning recipes
- Practice workbook questions
Get the Excel for Analysts Pack — $7
One-off. Delivered as a PDF by email the moment payment clears.
Prices shown are a USD base. Your local-market price is calculated at checkout in your own currency, plus any local sales tax.
What is inside
20 chapters, in the order the interviews tend to ask them:
- The grid, ranges and what a row insert really changes
- Relative, absolute and mixed references under copy and fill
- Named ranges and Excel tables, and why they beat cell addresses
- Functions, operators and the calculation chain
- XLOOKUP, INDEX with MATCH, and the lookup versus join decision
- SUMIFS, COUNTIFS and the criteria that quietly miss rows
- Text functions, and why TRIM and CLEAN are not enough
- Date and time functions and the serial number trap
- Number formatting versus the underlying value
- Pivot tables, and why a pivot total is not a summary you can audit
- Power Query and the query as code
- Power Pivot, the data model and relationships
- DAX measures versus calculated columns and the difference in evaluation
- Data cleaning, messy headers and mixed types
- Data validation and protecting a model from silent breakage
- Pivot alternatives: SUMIFS, COUNTIFS and the trade-off
- Charts and conditional formatting as signals, not decoration
- Iterative calculation, circular references and the settings that enable it
- Automating with VBA and knowing when not to
- Sharing, versioning and making an analysis reproducible
How the answers are built
Each chapter opens with the checklist the question is really testing. A few from this pack:
- A reference is a position rather than a label, so anything that moves data underneath it is a change the reference will follow or refuse to follow.
- A relative reference is stored as an offset from the formula cell, so the same formula pasted twice is two different questions.
- A name gives a range an identity, so a reviewer can check the meaning of a formula instead of counting across to a column.
- Excel applies multiplication and division before addition and subtraction, and parentheses are the only way to override that.
- Exact match is the only match type you should accept by default, because an approximate match on unsorted data returns the wrong row with no error.
- A criteria string such as a greater-than expression is parsed by Excel, so a trailing space or a text formatted number matches nothing.
Questions this pack covers
- Someone hands you a formula reading `Sales!B7` and asks you to explain it. What is that actually referring to?
- How does inserting a row change a formula that sits beside it?
- What actually changes when a relative reference is copied one column to the right?
- When does a lookup formula need an absolute reference on its table array?
- What does a defined name give you that a cell address cannot?
- A name in a workbook you inherited seems to mean something different in different sheets. What has probably gone wrong?
- You are reading `=A1+B1*C1` and want to be certain about the order. What does Excel actually do?
- What is the real limit on how deeply you can nest functions in a formula?
Each one is answered in full in the pack, with the reasoning written out rather than a bullet list.
About this pack
- How many questions?
- 360, spread across 20 topics, written out in full across 250 pages.
- Do the answers just list keywords?
- No. Each answer is written as prose, because that is what you have to reproduce when someone asks you the question.
- How do I get it?
- Pay once and the PDF arrives by email immediately, with a signed download link.
- Can I get it refunded?
- Yes, if it is not what you expected. See the refund policy.
