Chapter 6

The Pivotal Pivot Table

In This Chapter

arrow Introducing pivot tables

arrow Building your first pivot table

arrow Customizing your pivot tables

arrow Using pivot-driven reports

arrow Creating top and bottom reports

I know what you’re thinking: “Am I supposed to be jumping right in with pivot tables?” My answer is an emphatic yes!

In Chapter 2, I introduce the concept of reporting models that separate the data, analysis, and presentation layers. As you discover in this chapter, pivot tables lend themselves nicely to this concept. With pivot tables, you can build reporting models that not only are easy to set up, but can also be refreshed with the simple press of a button. Then you can spend less time maintaining your dashboards and reports and more time doing other useful things. No utility in the whole of Excel allows you to achieve this efficient data model better than a pivot table.

Pivot tables have a reputation for being complicated, but if you’re new to pivot tables, relax a bit. After reading ...

Get Excel Dashboards and Reports for Dummies, 3rd Edition 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.