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.
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