IUPUI

This workshop lasts 90 minutes, and is part of the certificate series Excel 2010 Advanced End-User

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 one- and two-input data tables and Goal Seek. Participants will use the Scenario Manager, which makes automating what-if models easy by storing and comparing named scenarios. Summary reports will be generated to see the effects of these various combinations of input values.

What You'll learn

Available Downloads

• create a simple array

• create one- and two-input tables

• use the Goal Seek tool

• create, modify, and recall scenarios using the Scenario Manager

• generate summary reports using the Scenario Manager

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• create and manage named ranges

• create formulas and functions

• work with table features

If you don't have those skills, consider first taking the workshop:

• Excel 2010: Data Management