Hands-On Excel Practice files
Pivot Tables Practice File
The same 1,000 rows of sales from the video "Excel Pivot Tables in 6 Minutes". Download it, build the pivot table with the video, and answer the five questions yourself.
What's inside
- Data1,000 orders from 2025 (order date, region, channel, category, product, units, price, revenue)
- NewRows40 January 2026 orders, for the Refresh All step
Download sales_2025_practice.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
- Which region sold the most?
- Which month was best, and which was quietest?
- Which region-and-category pair brings in the biggest share of revenue?
- How many orders were there, and how big is the average order?
- What are the top 5 products in one region?
Test yourself
Work out each answer in your pivot table, then click to check it.
1Which month had the lowest revenue?Show answer
August
2What % of revenue came from the Online channel?Show answer
41.5%
3How many orders came from US - Southeast?Show answer
154
The answers use the Data sheet only, before you add the NewRows orders.