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 interattivo pratico
Trasforma la teoria in pratica con uno dei nostri esercizi interattivi
Inizia esercizio