Financial Modeling for Beginners: Mastering the Basics - Excel Goal Seek Made Easy: A Step-by-Step Guide

This tutorial shows an example of how to use the Goal Seek function in Excel to solve for what inputs we need in order to achieve certain outputs. First we review an Excel model that we then analyze using Goal Seek analysis. 👉 Become an Excel Power User in 2.5 Hours: https://www.ericandrewsstartups.com/excel-power-user-course 👉 Master Excel Keyboard Shortcuts & Mouse-Free Navigation: https://www.ericandrewsstartups.com/excel-keyboard-shortcuts-course Communities: 💼 Linkedin: https://www.linkedin.com/in/eric-andrews-1624b656/ 💻 Newsletter: https://mailchi.mp/1cf66809482f/mcoa7eoc9w ____________________________________________ In this tutorial, we learn how use goal seek in Excel to figure out how to achieve a 20% profit margin by changing price, units sold, and a bunch of other assumptions. Many times when we have a data model (financial or otherwise) we are are trying to figure out how to achieve a certain outcome, or how to solve for certain numbers. When analyzing situations like this, we often need to use "guess and check" to try to figure out how to get the outputs that we want. Fortunately for us, we don't have to do this manually. There are a few functions on the "Data" tab (of Excel) under the "What-If-Analysis" button. All of these functions help us try to figure out which inputs we need to get certain outputs. In this video we use Goal Seek Analysis to solve for how to achieve a 20% profit margin. We change many different assumptions - price, units sold, etc - using the Goal Seek function to try to solve this complicated scenario. I hope you enjoy this tutorial and please let me know if you would like more videos on sensitivity analysis. ► Subscribe for more Finance & Excel videos: https://bit.ly/EricAndrewsSubscribe