Building a spreadsheet that uses Goal Seek to get to the end result is relatively easy. Doing it well takes a bit more work.
In this beginner level tutorial we start with a typical spreadsheet that uses Goal Seek. It works but it’s difficult for a new user to follow and figure out what they need to do with it. We then modify this spreadsheet to:
- Include explicit and separate input cells for the Goal Seek parameters;
- Ensure our Goal Seek target value is always zero;
- Put in a check cell that tells us when we need to re-run the Goal Seek;
- Add a screen grab of the Goal Seek popup box so it’s complelely obvious to a new user how to re-run the Goal Seek;
The video uses MS Excel 2016 but the same steps are used for MS Excel 2010 and Excel 2013.
If you enjoyed this short tutorial then please add a comment, start a discussion, “Like”, “Favourite” or “Share” the tutorial and subscribe to my channel.
Thanks for watching!