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 and save that condition under a unique name. By invoking a number of scenarios, you can easily demonstrate to customers and managers the impact of different events or possibilities.
Like this content? Why not share it?
There Are No Comments
Click to Add the First »
Click to Add the First »