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:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.