| Course |
Excel
Advanced - Analyzing Data |
| Length |
Three
hours |
| Audience |
If
you do any forecasting, budgeting or data analysis, this class is
for you! Learn to create and work with Pivot Tables to look at your
data in a variety of ways. Maintain different “what if”
versions of your data with Scenarios. Discover the Goal Seek and
Solver features which allow you to test for a variety of results.
Learn to use Excel’s auditing tools. |
| Prerequisites |
Participants
should use Excel regularly on an intermediate level. |
| Topics
|
Module
1: Pivot Tables
- Creating
pivot tables
- Changing
pivot tables
- Refreshing
data
- Displaying
and hiding data
|
|
|
Module 2: Scenarios
- Creating
scenarios
- Editing and
deleting
- Displaying
scenarios
- Protecting
scenarios
|
|
|
Module 3: Using the Goal Seek Feature
- What is goal
seek?
- Using goal
seek to reach a desired result
|
|
|
Module 4: Using the Solver Feature
- What is
Solver?
- Using Solver
to determine resulting values with multiple variables and constraints
|
|
|
Module 5: Using the Auditing Tools
- The Auditing
toolbar
- Tracing precedent
and dependent cells
- Tracing errors
|
