View all of our Excel Video Tutorials on our New YouTube Channel HERE.
The goal seek tool in Microsoft Excel allows you to use excel to figure out what value you need for x in order to get the desired value for y. This works by having linked cells and can be done by changing only one cell at a time. This tool is especially good for financial and production analysis. I will explain how to use the tool and also a good example of where you might want to use it.
Topics Covered
 How to use Goal Seek in Excel  Goal Seek to Find Desired Net Income Value on an Income Statement  Automatically changing a cell to achieve a desired result
Difficulty: Intermediate
Video: Yes
Spreadsheet: No
|