Part IV: Managing and Analyzing Data
PivotTables were introduced in Excel 97, and this feature improves with every new version
of Excel. Unfortunately, many users avoid this feature because they think it’s too compli-
cated. After reading this chapter, you’ll see that PivotTables are both powerful and easy to
master.
A PivotTable example
The best way to understand the concept of a PivotTable is to see one. Start with
Figure 29.1, which shows a portion of the data used in creating the PivotTable in this chap-
ter. This range happens to be in a table (created by using Insert ➪ Tables ➪ Table), but
that’s not a requirement for creating a PivotTable.
FIGURE 29.1
This table is used to create a PivotTable.
