Chapter 12. Pivot Tables: Hardcore grouping
Pivot tables are among Excel’s most powerful features.
But what are they? And why should we care? For Excel newbies, pivot tables can also be among Excel’s most intimidating features. But their purpose is quite simple: to group data quickly so that you can analyze it. And as you’re about to see, grouping and summarizing data using pivot tables is much faster than creating the same groupings using formulas alone. By the time you finish this chapter, you’ll be slicing and dicing your data in Excel faster than you’d ever thought possible.
Head First Automotive Weekly needs an analysis for their annual car review issue
Head First Automotive Weekly has signed you on to help them create some table visualizations out of their annual car test data.
The magazine’s readers are serious data junkies; they just love looking at stats on all the cars available. On the one hand, it’s great that you have such passionate readers, but on the other hand, it’s kind of a drag that you have to slice and dice the car data in so many ways in order to satisfy them.
Get Head First Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
