Microsoft Office Tutorials and References
In Depth Information
The very concept of a PivotTable report (often called simply a PivotTable) can be daunting
if you’ve never worked with one. But once you discover how quickly and effectively you can
use a PivotTable to summarize even the most enormous table, we predict you’ll be hooked.
Every PivotTable report starts with source data, which can be stored in a worksheet or
drawn from an external database. After you specify a location for the PivotTable (typically a
separate worksheet), you lay out the fields to create the report. Figure 12-2 shows a
PivotTable report that summarizes current inventory by using an Excel table that contains 2,476
rows and 11 columns.
Figure 12-2 The PivotTable report on the left neatly crunches tens of thousands of data points
into a simple summary.
PivotTable reports can be used to summarize numeric data by totals and averages or to
create reports based on dates. You can show or hide subtotals and details for a group, add
filters to extract details for a company or person, and change the format of the report to
make it more readable. We explain in detail the techniques for creating, formatting, and
working with a PivotTable report in “Using PivotTables” on page 406.