Creating “Scenarios”

With the “Scenario Manager” in “Excel”, we have the opportunity to create several “What if … ” scenarios without having to constantly changing the data

 

For example:

In a hair salon, they sell several services: haircut, coloring and drying.
There are days when everything goes normal. There are also days when reservations are called for, an example may be during very good weather. And there are days when everyone wants to go to a hairdresser, for example before a major holiday.

To avoid ever having to change the cells in our What-If scenario, we developed a number of “Scenario” sets.

The “Scenario Manager” option is found under “What if analysis” in the “Data” tab of the “Ribbon”.
Click the downward pointing arrow next to “What if analysis”, and choose “Scenario Manager”.

In the dialog that appears, choose “Add”. In the top box, you first give the “Scenario” a name. I will name it “Normal”.
In the second box, “Changing cells”, specify the cells that need to be adjusted depending on the chosen “Scenario”. Click with your mouse pointer over the cells and hold the Ctrl key on your keyboard pressed when there are no adjacent cells. In the third box you can optionally enter a “Comment”.

Click OK when all boxes are filled

In the “Scenario” window you give different values for the “Changing cells”.

Click the “Add” button.
We still need to enter two “Scenarios”, remember.

A scenario for when the sun shines and a scenario if a holiday is coming.

So you repeat these steps for each “Scenario”.
When you ready, press OK

 

In the “Scenario Manager” dialog box that appears, you see our three-set “Scenarios”.
Click on “Close”.

 

Applying “Scenarios”

Once we have created different “Scenarios”, we can apply it whenever we want to.

Just click the downward pointing arrow next to “What if analysis”, and choose “Scenario Manager”.

In the “Scenario Manager” window, select a “Scenario” and click the “Show” button.

You can now see the different “Scenarios” by selecting them in the list and click on the “Show” button.
The values in the cells pertaining to the values of the “Scenario” are automatically adjusted.

 

Changing “Scenarios”

To modify a “Scenario” open the “Scenario Manager” dialog box, select the “Scenario” and click the “Edit” button.

 

In the dialog “Edit Scenario”, you can change all your settings.
Click OK and OK again when you are satisfied.
Then click “Close” button to close the dialog box.

 

Deleting a “Scenario”

To delete a “Scenario”, open the “Scenario Manager” dialog box, select the “Scenario” and click the “Delete” button.

Attention! “Excel” will not give you any warning, so the “Scenario” will be removed immediately.

 

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats