1. Home
  2. Microsoft Products
  3. Microsoft Office Excel 2003 in 24 hours

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
    		Part II: Dress Up Your Work
    		Part III: Interactive Data Makes Your Worksheet Come Alive
    		Part IV: Advanced Excel Techniques
    		Hour 14. Working Smarter
    		Hour 15. Using Functions
    		Hour 16. Auditing and Validating Your Work
    		Hour 17. Analyzing Your Data
    		Hour 18. Working with Pivot Tables
    		What Is a Pivot Table?
    		Learning the PivotTable Lingo
    		Building a Pivot Table
    		Modifying a Pivot Table
    		Working with Pivot Table Reports
    		Building a PivotChart
    		Creating a Chart from PivotTable Report Data
    		Summary
    		Q&A
    		Hour 19. Integrating Excel with Other Office Applications
    		Hour 20. Automating Tasks with Macros and Smart Tags
    		Part V: Creating and Using Databases in Excel
    		Part VI: At the Office and on the Internet/Intranet