This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using data tables, Goal Seek, and Solver. Participants will use the Scenario Manager feature, which makes automating what-if models easy by storing and comparing named data scenarios. Summary reports will be generated to see the effects of these various combinations of values.

(Description continued below)

Participants will:

• create a simple array
• create one- and two-input tables
• use the Goal Seek and Solver tools
• create, modify, and recall scenarios using the Scenario Manager

The following workshops are suggested prerequisites to this workshop:

• Excel: Data Management

Participants should already be able to:

• create and manage named ranges
• create formulas and functions
• work with table features