Hands-On Excel Practice files
Excel Dashboard Practice File
The same sales data from "Build an Interactive Excel Dashboard in 10 Minutes". It starts exactly where the pivot table video ended. Download it, build the dashboard with the video, and answer the five questions yourself.
What's inside
- Sheet1the pivot table from the pivot video (you'll rename it Calc)
- Datathe Sales table, 1,040 orders (2025 plus 40 January 2026 orders)
- NewRows38 February 2026 orders, for the Refresh All step
Download sales_2025_dashboard.xlsx (free, no sign-up)
Got the file. Want the next one?
We'll email you when the next video's practice file is up.
Optional. No spam, unsubscribe in one click. Privacy
| Order Date | Region | Channel | Product | Units | Revenue |
|---|---|---|---|---|---|
| 2025-01-01 | EMEA | Online | Premium Support | 4 | $2,760 |
| 2025-01-01 | US - West | Partner | Standard Support | 2 | $580 |
| 2025-01-01 | APAC | Online | Excel Essentials Workshop | 6 | $3,900 |
The 5 questions from the video
- What are our headline numbers? (revenue, orders, units, average order)
- Is revenue growing month to month?
- What do we sell the most?
- Is that true in every region?
- How did the last quarter go?
Test yourself
Work out each answer with your dashboard and its slicers, then click to check it.
1How many orders were there in March 2025?Show answer
74
2In Q4 2025, which channel brought the most revenue?Show answer
Direct ($491,130)
3In EMEA during Q4 2025, which category led?Show answer
Training ($70,730)
The answers use the Data sheet only, before you add the NewRows orders.
Bonus task
Add a Revenue by Channel chart and connect it to both slicers.