100 Computer Tips in 100 Days
Tip #93 - Excel Scenario Manager
![]() |
We're opening a sweet treats shop and want to be able to create a variety of success scenarios. The values in D4 through D8 are our variables. |
A helpful tool in Excel that allows you to store a variety of scenario models is the Scenario Manager. You create and save different groups of values and then switch to any of these stored scenarios to view different results.
![]() |
Once your base values are entered into a worksheet you then create an alternate scenario by naming it... |
![]() |
...and then defining the values that should be entered for that scenario. |
![]() |
All of the scenarios you have defined will be available in the Scenario Manager. Clicking on a scenario in the list and clicking the Show button changes the information in the worksheet. |
- Open a worksheet and put in all of the information for one scenario (see the sample worksheet).
- From the Data tab choose What If Analysis and Scenario Manager.
- Name the scenario and click OK
- Enter the variables in the cells for that scenario and click OK.
- After you have created all the scenarios that you need, you can create a scenario summary report that incorporates information from those scenarios. A scenario report displays all the scenario information in one table on a new worksheet.
![]() |
Clicking on the Scenario Summary Report option in the Scenario Manager results in a report showing all of the scenarios on a new worksheet. |
This tip probably benefits from having a video to view. I
will be taping these after all of my tips have been posted. I’ll let you know
when the video is available.
No comments:
Post a Comment