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.