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.

Susan Harkins continues her review of Excel's analysis tools with Scenario Manager.

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

How is the Scenario manager different from the Goal Seek feature? Scenario Manager is also a part of the What-if Analysis feature in Excel.

Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...