Excel 2007 Analyzing & Summarizing Data with Pivot Tables

Objective

Learn to analyze and summarize worksheet data using pivot tables and pivot charts.

Prerequisite Skills

Comfortable with Excel and its formatting capabilities.
(Suggested courses: Excel 2007 Getting Started and Excel 2007 Formatting Spreadsheets)
Comfortable with basic functions & formulas.
(Suggested course: Excel 2007 Functions & Formulas)
Comfortable working with Excel worksheets and workbooks.
(Suggested course: Excel 2007 Working with Workbooks)

Course Description

Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.

Attend this course if you want to:

Learn why and when you might want to use a pivot table or pivot chart.
Set up your data properly before creating the pivot table or chart.
Create a pivot table.
Modify and format a pivot table.
Filter and sort data in a pivot table.
Refresh a pivot table to reflect changes in the source data.
Copy a pivot table to another location.
Group pivot table items.
Drill down to view details.
Create calculated fields and items.
Customize pivot table options.
Create and modify a pivot chart.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)