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.

    Part I: Excel Basics