Excel 2010 Bible

Part V: Analyzing Data with Excel

742

Producing a Report with a Pivot Table

By using a pivot table, you can convert a huge table of data into an attractive printed report. Figure

35.32 shows a small portion of a pivot table that I created from a table that has more than 40,000

rows of data. This data happens to be my digital music collection, and each row contains informa-

tion about a single music file: the genre, the artist name, the album, the filename, the file size, and

the duration.

FIGURE 35.32

A 132-page pivot table report.

The pivot table report created from this data is 132 pages long, and it took about five minutes to

set up (and a little longer to fine-tune it).