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: [ Ссылка ]
- Learn the fundamentals of Excel in just 2 hours: [ Ссылка ]
⌚ 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: [ Ссылка ]
🚩 Connect with me on social:
- LinkedIn: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
🔔 Subscribe to my YouTube channel
[ Ссылка ]
🎬 Want to watch again? Navigate back to my YouTube channel quickly
[ Ссылка ]
🛍 Support me with your Amazon purchases: [ Ссылка ]
⚖ 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
Excel Solver & Goal Seek Tutorial
Теги
kevin stratvertstratvertgoal seeksolverexcelmicrosoft excelsolver excelexcel solvergoal seek excelexcel goal seekgoalseeksolveexamplehow tosolver in excelgoal seek in excelkevinmicrosoftmicrosoft 365officeexcel 202120212019advancedtutorialsolver tutorialgoal seek tutorialhow to usehow to use solverhow to use goal seekexcel tutorial solverexcel tutorial goal seekin excelmsms excelhow to dohelpguidestepsstep