• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Working with Scenarios

You could develop different scenarios by using different worksheets in a workbook, with each sheet containing the different assumptions. However, this approach can waste a lot of time. For example, imagine that you have 10 different scenarios, each one in a different sheet, and you need to change your model by adding a new condition to each scenario. You would then have to make the identical change to each of the 10 worksheets. Aside from the waste of time involved in approaching the problem this way, you also improve the chance of making a mistake.

Instead, it is far easier to use Excel 97's built-in Scenario Manager to track, display, and manage your different scenarios. In the following sections you learn how to take advantage of this important planning tool.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint