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
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
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:
There are no upcoming dates for this event.