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.
Latihan ini adalah bagian dari kursus
Data Analysis in Excel
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga