About this lesson
PivotTables open up your world to quickly summarize data and build solutions that others can explore.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.What is a PivotTable - and Why Do You Care?.xlsx
29 MB What is a PivotTable - and Why Do You Care? - Completed.xlsx
What is a PivotTable - and Why Do You Care?
Details about what a PivotTable is and what you can do with it.
Where/when to use the technique
When you want to open up your world to quickly summarize data and build solutions that others can explore.
Ease of creation and use
- Only a few clicks to create
- Drag and drop fields makes it easy to set up/modify views
- Promotes user interactivity
The Rubik’s cube of data
- Allows quick “pivoting” or re-arrangement of fields to show data in different ways
- Allows full user interactivity with the data
- Generates summaries of numbers without writing any formulas
- Refined algorithms make calculation speed virtually instant
- Above holds true whether used to summarize 30 or 3,000,000 records
- Allows using data sets with more than 1M rows or 16K columns (more rows/columns than exist in the Excel grid)
- Solutions can be developed once and refreshed many times with just a right click
Lesson notes are only available for subscribers.