Manual scenario creation
Scenario analysis helps develop strategies and set targets. For example, in the previous chapter, we calculated the Current Upsell $
, which gave us a total amount that could be earned if Bananas got every active non-paying user to upgrade their account.
While that number was insightful, it's still quite unrealistic - how would Bananas get 100% of customers to upgrade? We can play around with the numbers with scenario analysis to see how much we think this is a more realistic sales opportunity.
If you've lost progress, open up 2_4_countifs_sumifs.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
