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 lost progress, close any open files and load 3_2_goal_seek.xlsx from the Workbooks folder.
Diese Übung ist Teil des Kurses
Datenanalyse in Excel
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
Übung starten