Scenario Manager in Excel is used to compare data side by side and also swap multiple sets of data within a worksheet. In simple words when you have multiple variables and you want to see their effect on the final result, and also want to estimate between two or more desired budgets you can use Scenario Manager.

Why is the scenario manager useful?

Scenario Manager is a great tool to help you keep track of different scenarios you want to have with your data. Say, for example, you have your current income along with expenses in a spreadsheet. You want to figure out some ways to save more money, either by reducing expenses, increasing your income, or both.

What is the purpose of using scenarios in Excel?

A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results.