What-if analysis with Scenario Manager
Bananas also wants to explore increasing sales revenue by increasing prices, and they want to see how the projected sales would change in a specific scenario for each Subscription Type.
It can be tedious to manage and evaluate a bunch of different scenarios. Thats where the Scenario Manager shines, and its a great tool for organizing various scenarios, and even creating summaries of the results.
If you've lost progress, open up 3_2_goal_seek.xlsx from the Workbooks folder.
Deze oefening maakt deel uit van de cursus
Data Analysis in Excel
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen