Scenario Manager is a What-If Analysis tool that allows you to create and compare different sets of input values (scenarios) in a worksheet.
It helps you analyze multiple possibilities without changing your original data permanently.
Why Use Scenario Manager?
- Compare best-case and worst-case scenarios
- Financial forecasting
- Budget planning
- Sales projections
- Risk analysis
Example Scenario
Suppose you have:
- B1 = Price
- B2 = Quantity
- B3 = Total Sales
- Formula in B3: =B1*B2
You want to test:
- Low Sales Scenario
- Expected Sales Scenario
- High Sales Scenario
Instead of changing values repeatedly, Scenario Manager saves them for you.
Steps to Use Scenario Manager
- Go to Data tab
- Click What-If Analysis
- Select Scenario Manager
- Click Add
- Enter:
- Scenario Name (e.g., Low Sales)
- Changing Cells (e.g., B1, B2)
- Click OK
- Enter new values
- Click OK
Repeat to create multiple scenarios.
Show a Scenario
- Open Scenario Manager
- Select a scenario
- Click Show
Excel applies the saved values instantly.
Create Scenario Summary Report
- Open Scenario Manager
- Click Summary
- Select Result Cell (e.g., B3)
- Click OK
Excel creates a new worksheet showing comparison of all scenarios.
Scenario Manager vs Data Table
| Scenario Manager | Data Table |
|---|---|
| Multiple variable sets | One or two variables |
| Compare named scenarios | Sensitivity analysis |
| Manual scenario switching | Automatic grid results |
Important Notes
- Works with up to 32 changing cells
- Changing cells must be on the same worksheet
- Result cells must contain formulas
- Ideal for planning and forecasting
Practical Uses
- Business forecasting
- Budget planning
- Investment analysis
- Cost comparison
- Project planning
Benefits of Scenario Manager
- Organized comparison
- No need to rewrite formulas
- Easy scenario switching
- Professional reporting
- Better decision-making
Conclusion
Scenario Manager is a powerful What-If Analysis tool that helps you compare different business situations efficiently. It allows structured planning and makes financial modeling easier and more professional in Excel.