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.
Questo esercizio fa parte del corso
Analisi dei dati su Excel
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio