The IUPUI Events system is being retired on December 1, 2015 and will be moving to the new One.IU Calendar system.
Please contact for more information on how to be migrated.

Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab

About This Event


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

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:

Bookmark and Share

Event Schedule

There are no upcoming dates for this event.