For example, in the workbook pictured below, I have created a simple Excel-based projection with six scenarios. To switch between the scenarios, I select a scenario (such as Steve’s Assumptions in the ...

What is Scenario Manager in Excel? The Scenario Manager feature in Microsoft Excel is designed to allow users to change or substitute input values for several cells at the same time. For example ...

Figure A We’ll use this simple mortgage calculator to demonstrate Excel’s Scenario Manager. Refer to Table A to build this sheet if you like, or download the example file.

Sure enough, Excel has a perfect tool for that job, and you probably won’t be surprised to learn it’s called Scenario. It lets you create an ensemble of basic circumstances and then, as you make ...