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.

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.