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:

⌚ 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

🚩 Connect with me on social:

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ 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

[rdsoto]

This is an amazing training session.
Step-by-step, well designed, well delivered.
Incredible way to spend 23:33 minutes of your time to really learn something useful.
Thank YOU Kevin Stratvert

[philmingo]

thanks!!
i actually was solving situations like these ... the manual way! Watch me impress my boss tomorrow. :)

[tinaodam]

As usual Kevin, in the most simplest process you have delivered on Goal Seek and Solver. Brilliant!! And you made it very practical with the Cookie company example.!! Incredibly amazing!!

[starfish]

you are simply brilliant, the humor is on point. Thank you

[mitz]

Kevin, the man we didn't want, but needed

[williamarthur]

You weren't kidding about evolutionary taking a while, great introduction as always.

[sarahtasneem]

Very meticulous way of explaining my friend, Keep it up.i come back to your videos all the time whenever I have problems on EXcel.Thanks for helping me out!

[andy.puempel]

I like the simple approach you use Kevin. Excellent explanation of the different solver options.

[jacobreuter]

Bro I am failing a college class because of Solver confusing me. you finally made it click in this video, I legit understand it now. Thank you so much

[fareehahashmi]

Thank you ! It made learning goal seek and solver way too simplified and fun.

[oliviaakinyi]

Kevin thank you so much, have learned alot from your tutorial, so am able to teacher my students computer packages confidently. Good work Kevin

[thetourminator]

18:40 " I don't wanna back any negative quantity cookies....unless I'm starting up a weight loss program...." OMG LOL I'm dead.

[JustBlankNoInfo]

Love that intro though! That transition from the intro to you telling *"Hello Everyone, Kevin Here"*. That's just AMAZING after all!

[jimshy]

Awesome Video. Going to play with your sample file to see how to include Day Old Cookies (i.e. current "acceptable" inventory) to see how I can maintain a full Product selection for your company - including the Fortune Cookie customer desires. Suspect that if money is the only goal - will need to reduce the variety of Cookies offered.
I REALLY APPRECIATE your Video's. Not only the content but your voice and diction. I'm hearing impaired and your one of the very few presenters that I NEVER have any trouble understanding the audio or the content your presenting. The sample files and the hyperlinks to sections of the video are OUTSTANDING.
THANKS a Million (Cookies). ;-]

[NedumEze]

Thanks Kevin, that was sweet.
May I suggest you do a sensitivity analysis of a project. Take investment, project implementation, cash flows, discounts, profits, & determine: Rates of return, payouts, etc

[adarshm]

Veey Nice .You explained it in a very simple manner..Thank You Very much

[eneto]

A pretty clear explanation. Tks a lot!

[michalrumanek]

Haven't heard about these functions until now! Great!

[sudeepsd]

Once again Great Explanation from Kevin.

[texasseastar]

Say what??? I had no idea that Goal Seek or Solver even existed in Excel. Yet another Kevin video I need to bookmark for reference. Thanks Kevin!