Scenario Manager :
A Scenario can have multiple variables, but it can only accommodate up to 32 values.
Steps :
- First create above Table
- Select the input cells (B2,B3,B4) in the above data
- Click on Data Tab
- Then Click on What if analysis
- Select Scenario Manager
- Click on Add Button and type Scenario Name "Marketing" (Ctrl + Click cells to select non-adjacent changing cells).
- Click on OK Button
- Click on Close Button
- Enter the New Value in Excel Table
- Select the input cells (B2,B3,B4) in the above data
- Click on Data Tab
- Then Click on What if analysis
- Select Scenario Manager
- Click on Add Button and type Scenario Name "Finance"(Ctrl + Click cells to select non-adjacent changing cells).
- Click on OK Button
- Click on show "Marketing" or "Finance".
- Click on Close Button
Follow @Sarvavasi.com