Excel Advanced

Hi Stefania

To create a scenario, go to Tools - Scenarios.

Click Add to create a scenario.

Under Scenario Name, give the scenario a name.

In Changing Cells, select the cells that contain the values you are going to want to change in the different scenarios you are going to create. These cells must contain numbers/values, not formulas.

Click OK.

At the next screen, either leave the values in the changing cells as they are (if you have already entered the values you want to use) or enter values you want to put into the changing cells.

Click OK when you've finished putting in the Scenario Values.

Then repeat the above, entering different scenario names and values as many times as required.

There is an example you can follow on the page below if you like:
http://www.contextures.com/xlScenario01.html

Kind regards
Amanda