Excel 2003 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 2003 Getting Started and Excel 2003 Formatting Spreadsheets)

• Comfortable with basic functions & formulas.
  (Suggested course: Excel 2003 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested course: Excel 2003 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.

• Create a pivot table.

• Modify the pivot table.

• Filter data in a pivot table.

• Format data in a pivot table.

• Group pivot table items.

• Drill down to view details.

• Create calculated fields and items.

• Customize pivot table options.

• Create and modify a pivot chart.

• Save and work with a pivot table in HTML format.

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)