Computing Services



Excel Pivot Tables



Course Outline:


How Pivot Tables Reveal Data "Secrets"

- How To Create Pivot Tables From Source Data Lists

- Updating Pivot Table Data To View Current Analysis

- Changing How The Pivot Table Calculates

- Customizing The Relationship of The Pivot Table Data

- Filtering Pivot Table Data

- Grouping Pivot Table Data to View Higher Level Analysis

- Exposing New Data Analysis From The Pivot Table

- Charting Pivot Table Data

- Formatting Pivot Tables For Presentation


Handouts:

UC_Excel_2007_Module_5_-_Pivot_Tables.pdf (47 pages)

Practice Files:

UC_Excel_2007_-_PivotTables.xlsx


last update October 27, 2008 -ei for kv