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.

Excel has a built-in tool for achieving the solution you seek called Scenario Manager. You can access this tool from the Data tab by selecting What-If Analysis, Scenario Manager, as pictured below.

Monk-Brady Tutorial E. Guidance for Excel Cases and Monk-Brady Tutorial C. Building DSS in Excel Monk-Brady Case 6 Make sure you study the Useful EXCEL Learning Resources. Specifically, you will be ...

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

Learn how to use Excel’s What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes based on variable data inputs.