Excel 2007 Data Analysis Tools

Objective

Learn to use various add-ins and other Excel tools to analyze and manipulate data effectively.

Prerequisite Skills

Comfortable formatting worksheets and building functions and formulas in worksheets.
(Suggested courses: Excel 2007 Formatting Spreadsheets and Excel 2007 Functions & Formulas)
Comfortable working with pivot tables.
(Suggested course: Excel 2007 Analyzing & Summarizing Data with Pivot Tables)
Comfortable creating and running macros in Excel.
(Suggested course: Excel 2007 Automating Tasks with Macros)

Course Description

Are you experienced in Excel but want to learn additional, more advanced ways to view and analyze your worksheet data? Do you want to use tools such as the Scenario Manager, Goal Seek, Solver, and the Conditional Sum Wizard to work with data?

Attend this course if you want to:

Use the Scenario Manager to quickly substitute different groups of values in a worksheet.
Use "what-if" analysis tools (Goal Seek and Solver) to forecast formula results when the input values are unknown.
Create a data table to show how changing certain values affects the results of the formulas.
Consolidate similar data from multiple worksheets onto one worksheet.
Use the Conditional Sum Wizard to write formulas based on values that meet specific conditions.

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)