How to use Excel Solver & Goal Seek

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…
• 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