1-866-245-5224 sales@keystonelearning.com

Excel 2007: Creating & Displaying Scenarios

Excel 2007: Creating & Displaying Scenarios

In Excel 2007, Scenarios are lumped in with the what-if analysis tools. That makes sense, right? After all, the purpose of a scenario is for you to be able to store several sets of data possibilities in one cell. This way, you can look at different what-if possibilities.

Now, because you’ll actually be changing the worksheet data when you apply a saved scenario, it’s a really good idea for your first scenario to be one that contains your original data. This way, you can always get back to where you started. It’s kind of like leaving a trail of bread crumbs so you can find your way back home.

 Creating a Scenario

  1. Select the cells that will be changing in your scenario
  3.  Click the What-If Analysis command in the Data Tools group on the Data tab
  5. Choose Scenario Manager…

Figure 37. Scenario Manager Dialog Box

    4.       Click Add


Figure 38. Add Scenario Dialog Box

    5.       Type a name for your scenario

    6.       Verify the cell range listed under Changing cells is correct

    7.       Click OK


Figure 39. Scenario Values Dialog Box


    8.       Type the values you want to remember for the selected cells

    9.       Click OK

    10.   Repeat the above steps to create additional scenarios

Displaying a Scenario

Once you create a scenario, you’ll want to display it on your worksheet to be able to perform a true what-if analysis.

  1. Click the What-If Analysis command in the Data Tools group on the Data tab
  3. Choose Scenario Manager…
  5. Click the name of the scenario that you want to display
  7. Click Show