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)

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. What are our headline numbers? (revenue, orders, units, average order)
  2. Is revenue growing month to month?
  3. What do we sell the most?
  4. Is that true in every region?
  5. How did the last quarter go?

Test yourself

Work out each answer with your dashboard and its slicers, then click to check it.

  1. 1How many orders were there in March 2025?Show answer

    74

  2. 2In Q4 2025, which channel brought the most revenue?Show answer

    Direct ($491,130)

  3. 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.

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