Using Goal Seek
Sometimes, we know the end goal but are unsure how to get there. We know the last month's Sales Amount
was about $80,000. Let's say Bananas's sales team aims to earn $100,000 in monthly sales revenue. Which growth rate do they need to achieve? We could calculate this ourselves or use Goal Seek!
If you've lost progress, open up 3_1_scenario_analysis.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
