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)

Order DateRegionChannelProductUnitsRevenue
2025-01-01EMEAOnlinePremium Support4$2,760
2025-01-01US - WestPartnerStandard Support2$580
2025-01-01APACOnlineExcel Essentials Workshop6$3,900

The 5 questions from the video

  1. Which region sold the most?
  2. Which month was best, and which was quietest?
  3. Which region-and-category pair brings in the biggest share of revenue?
  4. How many orders were there, and how big is the average order?
  5. What are the top 5 products in one region?

Test yourself

Work out each answer in your pivot table, then click to check it.

  1. 1Which month had the lowest revenue?Show answer

    August

  2. 2What % of revenue came from the Online channel?Show answer

    41.5%

  3. 3How many orders came from US - Southeast?Show answer

    154

The answers use the Data sheet only, before you add the NewRows orders.

Practise with your answers checked

Watch the video on YouTube

Sign in or create an account

No password. Your solved challenges then follow you to any device.

Signing in sets one cookie that keeps you signed in. Privacy