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

Excel 2003: Creating & Displaying Scenarios

Excel 2003: Creating & Displaying Scenarios

In Excel 2003, 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
     
  2.  
  3. Choose Tools: Scenarios… from the Menu bar
     

Figure 25. Scenario Manager Dialog Box

         3.      Click Add

Figure 26. Add Scenario Dialog Box

   4.      Type a name for your scenario

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

   6.      Click OK

 

Figure 27. Scenario Values Dialog Box

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

   8.      Click OK

   9.      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. Choose Tools: Scenarios… from the Menu bar
     
  2.  
  3. Click the name of the scenario that you want to display
     
  4.  
  5. Click Show