What is scenario manager in Excel?

To model problems that are more complicated than data tables can handle, involving as many as 32 variables, you can use the services of the Scenario Manager in Microsoft Office Excel 2003. A scenario is a named combination of values that is assigned to one or more variable cells in a what-if model. You can use the Scenario Manager to enter variable figures in your what-if model and watch the effect on dependent computed values.

Here are some of the things you can do with the Scenario Manager in Excel:

• Create multiple scenariOS for a single what-if model, each with its own sets of variables. You can create as many scenariOS as your model necessitates.
• Distribute a what-if model to members of your team so that they can add their own scenariOS. Then you can collect the versions and merge all the scenariOS onto a single worksheet.
• Using Scenario Summary, examine relationships between scenariOS created by multiple users.