- Download.xlsx · 29 KB
All chapters
Every chapter’s sheets in one file, plus the full Northfield Customers and Reps lists.
- Download.xlsx · 8 KB
1The Fifteen-Minute Foundation
Maya’s first five orders with raw date numbers, plus the practice orders and the Customers and Reps lists.
- Download.xlsx · 7 KB
2Your First Win: Cleaning a Messy Export
The messy customer export, the numbers-stored-as-text slice, and the practice export to clean.
- Download.xlsx · 6 KB
3Formulas Without Fear
Dev’s expense sheet (Budget vs. Actual) and six practice orders for Amount and percent-of-total.
- Download.xlsx · 6 KB
4Counting and Adding With Conditions
The ten-order Orders sample (columns A–I) and the Invoices sheet for the overdue example.
- Download.xlsx · 5 KB
5Tables, Sorting and Filtering
Ten September orders to turn into a Table, sort, filter and total.
- Download.xlsx · 7 KB
6Looking Things Up: XLOOKUP and VLOOKUP
Customers and Orders sheets for XLOOKUP and VLOOKUP, including the deliberate trailing space in NS-1554.
- Download.xlsx · 6 KB
7PivotTables: The Weekly Summary in Five Minutes
Twelve Q1 orders as the tblOrders Table, ready for PivotTables.
- Download.xlsx · 6 KB
8Charts and the One-Page Report
September sales by region, monthly sales April–September, and the practice order counts.
- Download.xlsx · 6 KB
9Making Sheets Others Can't Break
The vacation tracker for dropdowns, date validation, overlap highlighting and protection.
- Download.xlsx · 6 KB
10Working in Shared Files Without Breaking Anything
Six orders for the sort-one-column disaster, comments and Sheet Views.
- Download.xlsx · 6 KB
11Passing a Pre-Hire Excel Test
The timed practice test: Orders and Customers, messy names and spaces included.
- Download.xlsx · 5 KB
12After the Two Weeks: Keep Getting Better
Five orders to try the FILTER function on.
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.