Scenario Manager Option in Ms-Excel

In this video we can discuss about How to use Scenario Manager in Excel.

What-if analysis:-

What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. 

Scenario Manager:-

A scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.