Stage 2 · Lesson 5 of 6
Pivot tables for exploring
A summarises a table for you. You drag fields (columns) into rows, columns, values and filters. You get answers like revenue by category and month, order counts by region, or average basket by channel.
It is the fastest way to explore a new dataset. It also teaches group-by thinking: split rows into groups, then summarise each group. You will use that idea in , and .
Learn to switch the summary from sum to count or average, and to show values as a percentage of the row or column total. Learn to group dates by month, and to refresh after the data changes. Always build pivots from a so new rows are included.
Common trapsumming a column that is already a percentage or an average, which produces a total that means nothing.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with
- GuideFreeExcel help and learning
Microsoft · Beginner
Official, accurate guides to XLOOKUP, SUMIFS, PivotTables and cleaning functions, with examples you can paste