This week’s Microsoft Excel tutorial is from one of our excellent Excel trainers, Jane. In this tutorial Jane shows us how to set up and show scenarios using Excel’s What-If tools.
For more in-depth training in Excel come to Brighton for an Excel Workshop. We have courses for all levels including:
If you want a course tailored to your needs then please call us on 01273 622272 as we also offer private and in-company training to suit you.
“The What-If Analysis tools in Excel enable the changing of values in cells to see how those changes affect the outcome of formulae. The Scenario Manager allows different scenarios to be created, for example to view results using different suppliers or for best and worst case sales results.
Tip: The Scenario Report will use cell references, so naming the cells that will be used first, will make you scenarios much easier to read.
Setting Up A Scenario
- From the data tab, in the data tools group click what-if analysis.
- Select scenario manager and click on ADD to add a scenario.
- In the SCENARIO NAME box, enter a name for the scenario.
- In the CHANGING CELLS box enter the cell address for the area you want to change or highlight it on the worksheet, then click OK.
- To change the current input values, click into the relevant box and enter the new values.
- Click on OK when you have finished.
- If you want to add additional scenarios click on ADD.
- From the data tab, in the data tools group click what-if analysis, select scenario manager.
- Select the scenario you want to use and click on the SHOW button and the cell values stored within the scenario will now appear on the worksheet.
- Click on CLOSE.
We have plenty more tutorials so have a look through the Excel resources or search for something specific. If there is a tutorial you would like to see or a niggling question about Excel then please leave a comment below and we will try to help you out.