Download the course files
Every module's working file (start here) and solution file,
plus the capstone and the raw dataset. Each is a standard .xlsx you can open in
Excel 2016 or newer.
100% synthetic data. All names, customers, products, reps and amounts are
generated from a fixed seed — nothing here is real or confidential. Regenerate it yourself with
scripts/generate_dataset.py.
| Stage | Working file | Solution file |
|---|---|---|
| M1 — Receive & clean | module-1.xlsx | module-1.xlsx |
| M2 — Structure & enrich | module-2.xlsx | module-2.xlsx |
| M3 — Explore & summarize | module-3.xlsx | module-3.xlsx |
| M4 — Pivot & rank | module-4.xlsx | module-4.xlsx |
| M5 — Present & capstone | module-5.xlsx | module-5.xlsx |
| 🎯 Capstone — fresh file | capstone.xlsx | capstone.xlsx |
For trainers
Delivering this course? The Trainer's Guide is a facilitator handbook — timed run-sheet, per-module talking points & pitfalls, the dataset reference, the full capstone answer key, and every Microsoft documentation link in one place.
- excel-for-sales-trainer-guide.pdf — facilitator handbook (PDF, 11 pages)
Raw dataset (synthetic)
- sales_data.csv — the order-line export (2,000 rows)
- reps.csv — Sales Rep reference (manager, annual quota)
- brands.csv — Brand reference (category, brand manager)