Setting up Scenario Manager in Excel
- Go to Data Tab –> Data Tools –> What-If Analysis –> Scenario Manager.
- In the Scenario Manager dialogue box, click on Add.
- In the Add Scenario dialogue box, fill in the following details: ...
- Click OK.
How do I create a scenario in Excel?
To create a Scenario Summary:
- On the Ribbon's Data tab, click What-If Analysis.
- Click the drop down arrow, and click Scenario Manager.
- Click the Summary button.
- In the Scenario Summary dialog box, for Report type, select Scenario Summary.
- Press the Tab key, to move to the Result cells box.
- On the worksheet, click on cell B6.
What is the scenario manager tool in Excel?
The Scenario Manager lets you substitute input values for multiple cells (up to 32). In this way, you can view the results of different input values (or scenarios) at the same time.
