If you’ve ever used a worksheet to answer the question “What if?”, you’ve already performed what-if analysis. For example, what would happen if your advertising budget increased by 40 percent? How about 50 percent?.
A scenario is a set of input values that you can substitute in a worksheet to perform what-if analysis. For example, you could create scenarios to show various interest rates, loan amounts, and terms for a mortgage. Excel’s scenario manager lets you create and store different scenarios in the same worksheet.
A scenario summary report is a single compiled report that summarizes the results from several scenarios. It’s easier to read than switching between different scenarios. Once you’ve created at least two scenarios, you can create a summary report.
Click the Data tab.
Click the What-If Analysis button.
Select Scenario Manager.
The Scenario Manager dialog box appears, displaying all the scenarios you’ve created.
The Scenario Summary dialog box appears. Ensure the Scenario summary option is selected.
A summary report for each scenario is generated on a separate sheet so you can compare each one side by side.