Summarizing and Slicing Data
An introduction to the use of pivot tables in Excel
Module Interact Lessons:
- Add/remove fields
- Drill Down
- Another slicing example
Click to launch lesson; mouse-over to see description of lessons, above.
How to move fields in and out of a pivot table; how this helps with getting to know the data.
Manipulating a medium-large dataset.
No narration. Just watch closely. Uses math-English college sections dataset.
Drill into data detail
Getting started with analyzing a large data set.
There are 4 lessons in this module.
Working with a prepared pivot table. Filtering, slicing, and drilling down, and up.
Copyright 2010-2020 Rick Fillman
All Rights Reserved.