Pivot tables are used to summarize large amounts of data in different ways
They can sum or count data with sub-totals for various categories
Once set up, the pivot tables can be manipulated to analyze the data in different ways
Easy to use and does not involve any complex formulas or functions
Qs: Do you use pivot tables? What do you typically use them for?
1 – They can summarize large amounts of data
2 – Allow you to manipulate the data in many ways – add counts, totals, sub totals
3 – You can continue to manipulate the data as you go
4 – Easy to use, no complex formulas or functions
Quite simple to do