Why Pivot Tables?

This question comes up a lot when people are just getting started with pivot tables. You can try to explain how pivot tables are cool, how they make it easy to analyze data, how they're really good at summarizing in different ways, how they're interactive, blah, blah, blah...

And, at this point, most people's eyes glaze over because it's really hard to see why you should care about pivot tables until you actually use one. Maybe that's you ? :)

One of the best ways to see why pivot tables are worth your time is to compare building a pivot table report to the process of building the same report manually. That's exactly what we do in today's video.

Are Pivot Tables really easier to use? Watch the video and see for yourself!

Below are links to more videos about Pivot Tables:

  1. Why Pivot Tables? - Because they are way faster than even a pro user <- this video
  2. What are Pivot Tables good for - 3 pivot examples
  3. 10 pivot table problems and easy fixes

Inspiration for this video came from the excellent book, Pivot Table Data Crunching, by Bill Jelen and Mike Alexander.

All data worksheets included in our online video training.