How to use the Excel Pivot Table Practice
- 1. Read the taskEach task asks a business question about 48 sample orders.
- 2. Build the pivotChoose rows, columns, values, the summary, a filter, show values as and sorting.
- 3. Check itThe table updates live; press Check to see if it answers the question.
The practice data
The data has 48 orders from April to September with Month, Region, Product, Salesperson, Units and Revenue, the shape of a typical sales extract. The builder works like Excel's PivotTable Fields panel. Pick a field for Rows and optionally Columns, a Values field, and how to summarise it (Sum, Count, Average, Max or Min). You can add a Filter, show values as a % of grand total, and sort rows largest first. Grand totals are added as in Excel.
Worked example
Task 1 asks for total revenue by region. Put Region in Rows and Revenue in Values, summarised by Sum. The pivot shows East 3,65,500, North 7,38,250, South 8,41,250 and West 5,61,350, with a grand total of 25,06,350. Task 6 is the same pivot shown as % of grand total: South comes out at 33.56%. Task 7 asks for revenue by salesperson, largest first: Ravi is on top with 7,24,250.
Checking and next steps
- Your pivot is compared with the expected table, not your exact settings, so any arrangement that produces the right numbers passes.
- All 8 expected tables were checked against pandas pivot tables.
- At the end you can download the data as CSV and rebuild the same pivots in Excel (Insert → PivotTable) or Google Sheets.
Frequently asked questions
Is this the same as a real Excel PivotTable?
It covers the core ideas: rows, columns, values, summaries, filters, % of total and sorting. Excel has more, like slicers, calculated fields and grouping dates.
Count of which field?
For counting orders, any field works with Count, as in Excel.
Is the Excel pivot table practice free?
Yes. You can open the Excel pivot table practice and use it without signing up. When you see your score for the first time, we ask once for your name and WhatsApp number; after that it, and every other Uncodemy tool, opens straight away.