Step 1 of 10
Pivot table exercises: a hands-on Excel lesson
In this lesson you practise pivot tables in Excel on one small sales sheet: you drag fields into Rows, Columns, Values and Filters and answer real questions with the pivot, such as "which region sold the most in March?". Every exercise runs in a live pivot table inside the lesson, and each one ticks as soon as the pivot shows the answer.
Watch the sheet below. Its 36 orders each have a date, a region, a rep, a product, units and revenue. A pivot table groups them and adds them up.
Press Product and Month too: the same 36 rows, grouped another way, give a different summary. Nothing in the source changes.
In this lesson you'll:
- build a pivot table by dragging fields into Rows, Columns, Values and Filters
- switch between Sum, Count and Average, and show values as a share of the total
- filter with a slicer, group dates by month, sort, and keep only the top 3
- avoid the usual mistakes: Count instead of Sum, a pivot that wasn't refreshed, and new rows the source range misses
It takes about 60 minutes: nine short steps, eight pivot exercises you do in the lesson, a practice step and two quizzes.
Takeaway: a pivot table groups rows that share a value and adds up their numbers, without a single formula.