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.

I'm an intermediate-level Excel user - I only know as much as I need to get the job done. As I imagine is the case for most people, I learned Excel by asking myself questions like, "I wonder if there's a way to do [X]?" and then Googling the answer. Your site has already taught me so much in the short time I discovered it and, as a Learning & Development professional, I admire your approach. Great work, and thanks for supporting all us Excel geeks! -Will
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