Hour 18. Working with Pivot Tables

The topics in this hour are as follows:

  • What you should know about pivot tables

  • How to build a pivot table

  • How to modify a pivot table

  • How to work with PivotTable reports

  • How to build a PivotChart

In this hour, you get to know a very powerful data analysis tool in Excel—the PivotTable. You can use a pivot table to summarize large amounts of information in a friendly, informative, interactive worksheet table. Also, you can create a PivotChart from pivot table information.

At the conclusion of this hour, you'll be creating simple pivot tables and charts to analyze vast amounts of data in your daily work.

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.