Scenario Manager in EXCEL can be the tool of choice when you have MULTIPLE variables, and you want to see the effect on the final result when these variables change.

If you only have one or two variables changing, you can create a one variable or two-variable data table. But if you have 3 or more than 3 variable that can change, then scenario manager is the way to go.

For example:

 if you're a regional sales manager and have four areas under you, you can use scenario manager to create DIFFERENT SCENARIOS (such as):

• NONE of the area shows any growth in sales.
• Area A grows 10% but the other 3 don't grow.
• Area A and B grow by 10%, but other two don't grow.

Scenario Manager in Excel can be the tool of choice when you have multiple variables, and you want to see the effect on the final result when these variables change.

If you only have one or two variables changing, you can create a one variable or two-variable data table. But if you have 3 or more than 3 variable that can change, then scenario manager is the way to go.

For example:

 if you're a regional sales manager and have four areas under you, you can use scenario manager to create different scenarios (such as):