Войти
  • 257088Просмотров
  • 4 года назадОпубликованоKevin Stratvert

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: !AmxrofZZlZ-whK4XsoXu2yIHzc6bhg?e=czyAOX - 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