Pick the cell you want to change in the Changing Cells box and click OK.Click Add, and enter a descriptive name for the Scenario Name.Pick the cell(s) you want to change in the Changing Cells box and click OK.Click Add, enter Base Case for the Scenario Name.Open the Scenario Manager by going to Data -> What-If Analysis -> Scenario Manager.NOTE: It is highly recommended to create a Base Case scenario that you can roll back to!.These tools work very well when you either want to try seeing how things would look with different variables in place, or when you need to work out what variables will drive the outcome you’re looking for. Performing what-if analysis in Excel using the Scenario Manager and Goal-Seek.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |