- Download.xlsx · 53 KB
All chapters
Every chapter’s sheets in one file, plus the full Northfield Customers and Products lists.
- Download.xlsx · 5 KB
0Introduction: The Requests Your Formulas Can’t Answer Yet
The six December orders for the five-question warm-up.
- Download.xlsx · 7 KB
1Read Any Formula: Evaluate, F9 and a Readable Formula Bar
Walt’s discount formula, already in column J, on six December orders, plus the practice orders.
- Download.xlsx · 10 KB
2Your First Win: Discount and Commission Tiers With One Lookup
Orders, the Discounts and CommissionRates tier tables, December commission sales, the practice orders and the full Customers list.
- Download.xlsx · 8 KB
3Lookups on Two Columns and in Two Directions
Six December orders, Omar’s Freight grid, the MonthlySales grid and the Products list.
- Download.xlsx · 9 KB
4Lists That Update Themselves: FILTER, SORT and UNIQUE
Nadia’s Invoices sample with the report date, the December orders as the Table tblOrders, and the practice export.
- Download.xlsx · 7 KB
5Splitting and Building Text: Codes, Names and Labels
The messy supplier export, the Contacts list, an Orders sample for the order-number example, and the practice SKUs.
- Download.xlsx · 9 KB
6Dates, Deadlines and Working Days
Orders for due dates and ship-by dates, the Holidays list as the Table tblHolidays, and Omar’s practice shipments.
- Download.xlsx · 9 KB
7Beyond IF: Ageing Buckets, Wildcards and SUMPRODUCT
The AgeingBuckets table, Nadia’s Invoices with the report date, the SKU orders and customer names for wildcards, and the practice invoices.
- Download.xlsx · 8 KB
8Errors That Warn You Instead of Hiding
Nadia’s December paste with its three problems (G5 is the text 12), plus the full Customers and Products lists.
- Download.xlsx · 8 KB
8Errors That Warn You: practice task
The practice batch on its own Orders sheet, with the Customers and Products lists.
- Download.xlsx · 7 KB
9Rounding Money So the Totals Agree
The credit-note lines, December commission with rates and bonuses, Omar’s ream orders and the practice credit lines.
- Download.xlsx · 8 KB
10Rewrite the Formula Nobody Understands
Walt’s commission formula, already in Commission!D2:D5, with CommissionRates and Targets, plus the practice Orders and ShipFees.
- Download.xlsx · 12 KB
11Capstone: The Monthly Summary That Builds Itself
The December orders as tblOrders, Nadia’s Invoices, CommissionRates, the twelve orders to paste, the November practice orders and the full Customers list.
- Download.xlsx · 8 KB
12Formula Practice Test
Fresh data for the 15-task test: Orders, Invoices with the report date, Discounts, AgeingBuckets and Holidays. No answers.
The files open in Excel, Excel for the web (free with a Microsoft account) and most other spreadsheet apps. If you prefer, type the tables in by hand from the book—the result is the same.