Advanced Microsoft® Office Documents 2007 Edition Inside Out

Chapter 16. Powerful Reporting, Easier Than You Think: A PivotTable Primer

Why Use a PivotTable?

Creating a PivotTable

Managing PivotTables

Formatting PivotTables

Using PivotCharts

Quick Reference—Create and Format a PivotTable

PivotTable and PivotChart reports have a bad reputation, but don’t believe everything you hear. Though you can get more complex if you want to, PivotTables don’t have to be any more challenging to create and use than a typical bar or column chart. However, simple as your PivotTable may be, it’s likely to be a powerful analytical tool that can do more for you than you probably expect.

This chapter on PivotTable and PivotChart reports is quite a bit different from most chapters to this point. That is, it covers basics—because basic ...