Exceljet

Quick, clean, and to the point

Why Pivot Tables?

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!

This is the 1st video in this series on Pivot Tables. Here's the full list:

  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.

Your Website is excellent. It is helpful with substance and clarity and it has an attractive look. It gives me the feeling that the creators of this website live on the same Planet as I do. I don't always get the feeling when I use Microsoft help. -Andre
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course