Excel 2010 Bible

Part V: Analyzing Data with Excel

700

FIGURE 34.5

This range contains normalized data and is appropriate for a pivot table.

Figure 34.6 shows a pivot table created from the normalized data. As you can see, it’s virtually

identical to the non-normalized data shown in Figure 34.4.

On the CD
This workbook, named normalized data.xlsx, is available on the companion CD-ROM. n

FIGURE 34.6

A pivot table created from normalized data.