This video is taken from my course Excel Modeller
Check out the Course
This video is taken from my course Excel Modeller
Check out the Course

Demo of Excel's Goal Seek Tool

 

Excel calculates the input to deliver a defined output! Super useful in commercial analysis and modelling!

 

Goal Seek is perfect for that Management question "What do we need X to be, in order to achieve Y?" or "What annual % price increase must we implement, to achieve sales of £100m in 5 years?"

Goal Seek is part of Excel's Data Analysis tools. We select an output, tell Excel what we want that output to be, then we select an associated input - Goal Seek will iterate through values for the input until it finds the perfect result...perhaps it's easier to just watch the video.

A good associated video to follow this up with is Data Tables Intro. Rather than Management knowing what they WANT sales to be in 5 years, they might ask what WILL they be IF an input is X, Y or Z...this is Sensitivity Analysis, will get you in their good books, and will probably earn you a promotion ;)