Microsoft Office Tutorials and References
In Depth Information
Producing a Report with a Pivot Table
This pivot table is sorted on two columns. The main sort is by Region, and states within each
region are sorted alphabetically. To sort, just select a cell that contains a data point to be
included in the sort. Right-click and select from the shortcut menu.
Sorting by Region required some additional effort because Roman numerals are not in
alphabetical order. Therefore, I had to create a custom list. To create a custom sort list, access the Excel
Options dialog box, click the Advanced tab, and scroll down and click Edit Custom Lists. In the
Custom Lists dialog box, select New List, type your list entries, and click Add. Figure 18-45 shows
the custom list I created for the region names.
Figure 18-45: This custom list ensures that the Region names are sorted correctly.
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 18-46 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
information about a single music file: The genre, the artist name, the album, the file name, the file
size, and the duration.
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).
This workbook, named music list .xlsx , is available on the companion CD-ROM.
Search JabSto ::

Custom Search