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:

• Beginners Excel Training
• Advanced Excel Training
• VBA for Excel Training

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

1. From the data tab, in the data tools group click what-if analysis.
2. Select scenario manager and click on ADD to add a scenario.
3. In the SCENARIO NAME box, enter a name for the scenario.
4. 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.
5. To change the current input values, click into the relevant box and enter the new values.
6. Click on OK when you have finished.
7. If you want to add additional scenarios click on ADD. Read the rest of “Microsoft Excel Tutorial: Scenarios”