Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
Pivot tables
Totals by group, in a few taps
Try this lesson free →Key points
RowsWhat each line of the summary is: one per store, product or day.
ValuesThe number you're summarising, like Revenue.
Sum, Count, AverageHow to summarise it.
Pivot tables answer "total X by Y" questions without a single formula.
Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →