Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

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.