CHAPTER 1Introducing Pivot Tables

Using a pivot table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data. With it, you can turn your data inside out, upside down, sideways, and backwards to see how your business is doing. You can examine the data for similarities, differences, highs, and lows. What's going up, what's going down, and what's staying the same? Compare one region to another, view key results for several years of data, or zero in on one product's sales results. Make a few quick changes to the pivot table, and you can see your data from a completely different angle.

Pivot tables are even easier to use in Excel 2007 than they were in previous versions. With just a few clicks of the mouse ...

Get Beginning Pivot Tables in Excel 2007 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.