![]() ![]() Scenario Manager is a dialog box that allows you to save the values as a scenario and name the scenario.For example, you can create several different budget scenarios that compare various possible income levels and expenses, and then create a report that lets you compare the scenarios side-by-side. You can also create a scenario summary report, which combines all the scenarios on one worksheet.A scenario can have multiple variables, but it can accommodate only up to 32 values.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.Below are the following key features, such as: ![]() Goal seek differs from Data Tables and Scenarios in that it takes a result and projects backward to determine possible input values that produce that result.Ī scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. Excel has the following What-if analysis tools that can be used based on the data analysis needs:ĭata Tables and Scenarios take sets of input values and project forward to determine possible results. To enable the what-if analysis tool go to the Data menu tab and click on the What-If Analysis option under the Forecast section. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |