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.

Thank you for the Excel tips and shortcuts! They really helped to educate me on the power of Excel and improve my skills in using Excel!! - Angelina
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