Course: Organize, Summarize & Analyze Data with Pivot Tables

Author: Patricia McCarthy, MBA,MOS 

Course Description:
This course will help you get out from all of that data and show you how to quickly organize and summarize your data so that you can analyze it. The course covers everything that you want to know about pivot tables.
It starts with having you create a pivot table and then modify and format it. It discusses how to drill down as well as how to create multiple reports from one pivot table. It also discusses how to create and add other formulas and items to an existing pivot table. Finally, it shows you how to update your pivot table with new data without recreating it everytime.

NASBA Category: Computer Science/Specialized Knowledge

Level: Intermediate Excel Users

Prerequisites: Excel 2007/Excel 2010 
This course is designed for users of Excel 2010.
People with Excel 2007 can do the course except for a feature or two.
There are adequate snapshots so that users will understand how to use
these features even if they do not currently have 2010.

This is not intended for 2003 or earlier versions of Excel. 

Learning Objectives:

• Learn how to create a pivot table from Excel data
• Learn how to modify and format a pivot table
• Learn how to use pivot table calculations   
• Learn how to created calculations using pivot table data
• Learn how to group data in a pivot table
• Learn how to change or update the underlying data in a pivot table

.