Quick analysis tool in excel for mac

broken image

broken image

broken image

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.