For our example, we will analyze several financial scenarios. In the Excel document, I have defined the key input variables that will drive the scenario analysis: revenue growth, cost of goods sold, ...

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 ...

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.

How to use Scenario Manager in Excel You’ll find that the Scenario Manager is easier to use, but you must ensure the relevant data has already been added to the spreadsheet before moving forward.

To investigate the Excel Scenario feature, let’s continue with the LM317 example that I presented in my earlier blog, Use Excel Goal Seek to Solve Design Equations on Excel in design. Recall that for ...

About Scenario-focused samples that help you get started with building Excel add-ins.