Manage multiple possibilities with Excel scenarios

An Excel spreadsheet is a wonderful tool for “what if” analysis because you can change results throughout the workbook by editing a single cell. A disadvantage to this process, however, is that it isn’t always easy or convenient to restore the original values, especially when you’re changing multiple cells.

Fortunately, Excel offers the Scenario Manager, which allows you to substitute values in a number of cells … [ Read more ]