Scenario Manager is a tool available in Excel that allows users to create, analyze, and compare data results in different business scenarios. It is a what-if analysis tool that works on different scenarios, using a group of ranges that impact an individual output. With Scenario Manager, users can create and save different groups of values as scenarios and then switch between these.

A scenario is a set of input values that can be substituted in a worksheet to perform what-if analysis. For example, users can create scenarios to show various interest rates, loan amounts, and terms for a mortgage. Excels Scenario Manager lets users create and store different scenarios in the same worksheet.

To use Scenario Manager in Excel, users can follow these steps:

1. Select the cells that contain values that could change.
2. Click the Data tab on the ribbon.
3. Click the What-If Analysis button.
4. Select Scenario Manager. The Scenario Manager dialog box appears with the message “No Scenarios defined. Choose Add to add scenarios.
5. Click the Add button to add a new scenario.
6. Type a name for the new scenario. If you already have cells selected, the Changing cells field will already be populated with your selection. If you didn’t select cells up front, you’ll have to specify the cells here.
7. Click OK.

Once users have created at least two scenarios, they can create a summary report that summarizes the results from several scenarios.