Title | : | Excel Solver & Goal Seek Tutorial |
Duration | : | 23:34 |
Viewed | : | 146,980 |
Published | : | 09-03-2021 |
Source | : | Youtube |
In this step-by-step tutorial, learn how to use Goal Seek & Solver in Microsoft Excel. With Goal Seek, you can find the result you want by adjusting an input value. Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell subject to constraints, or limits, on the values of other formula cells on a worksheet. 👋 Additional resources: - Sample files to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whK4XsoXu2yIHzc6bhg?e=czyAOX - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 1:49 Goal Seek 8:26 Turn on Solver 9:56 Solver Simple Example 12:11 Solver Advanced Example 22:49 Wrap up 📃 Watch related playlists and videos - Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert
What-If Analysis (Goal Seek, Scenario Manager, ... 55:16 - 92,509 |
Excel Solver & Goal Seek: MUST-KNOW for Busines... 12:43 - 58,606 |
Excel Formulas and Functions | Full Course 52:40 - 1,129,697 |
MS Excel Solver Examples 39:30 - 78,328 |
What-If Analysis (Goal Seek, Scenario Manager a... 13:38 - 350,086 |
Excel Solver - Example and Step-By-Step Explana... 09:57 - 956,362 |
How to Create Pivot Table in Excel 20:49 - 952,866 |
Solve Anything FAST with Excel's What-if Analysis 09:57 - 108,494 |