Microsoft Excel Tutorial: Scenarios

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

  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.excel-scenario-tutorial
  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.

Showing Scenarios

  1. From the data tab, in the data tools group click what-if analysis, select scenario manager.
  2. 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.
  3. 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.

Read our last 4 Microsoft Excel Tutorials:

Guide to Microsoft Excel Pivot Table Slicers

Joining Cells in MS Excel Tutorial

Creating Gantt Charts in Excel 2007

How to Freeze Panes in Microsoft Excel 

Tags

, , , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

Leave a Comment