Course outline / PivotTables
Lesson 53 of 75 · Intermediate · 3 exercises
PivotTable basics
Summarise a long list in seconds by choosing rows and values.
What you'll practise
- Total sales by store PivotTable
- Total sales by category PivotTable
- Average sale by store PivotTable
Total sales by store
A PivotTable summarises a long table for you, grouping matching rows and totalling them, with no formulas needed.
Put Store in Rows and Sales in Values, summarised by Sum, then click Build PivotTable.
Total sales by category
The real power of a pivot is how quickly you can rearrange it to answer a new question.
Show total Sales by Category instead of by Store.
Average sale by store
Values don't have to be totals. A pivot can also count, average, or find the highest or lowest value.
Show the average Sales for each Store.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.
← Choosing the right chartPivotTables: counts and extremes →