October 24, 2013

Excel Tricks: Calculate Input Values With Goal Seek

Written by

Goal Seek is a fantastic tool that lets you easily calculate input values based on a desired result. Goal Seek is extremely useful for real estate, insurance or even your sales team. Do you have a desired sales goal but need to determine the necessary figures to make it a reality? Goal Seek can help.

See it in action in the video below!

Here’s a quick recap:

1. Go to the Data Tab and select “What-If Analysis”

2. Select “Goal Seek” – select the necessary “Set Cell” and enter the desired outcome

3. In the “By Changing Cell” box, select the cell you wish to determine and hit OK.

Subscribe to our YouTube channel for other great tricks and product reviews!