Excel Solver & Goal Seek Tutorial

Описание: 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-whK4Xs...
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:    • ❎ How to use Excel  

🚩 Connect with me on social:
LinkedIn:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  

🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...

🎬 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