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.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
