Excel Solver - Example and Step-By-Step Explanation

In this tutorial, we guide you through the steps to utilize Solver for solving intricate problems that Goal Seek can't handle. Perfect for those who want to go beyond single-variable changes.

Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables. It can solve for more complex “what-if-analysis” which Goal Seek can’t. Goal seek is restricted to changing one variable, whereas with solver you can have many variables.

✨ Key Highlights:
▪️ Solver vs. Goal Seek: Learn the limitations of Goal Seek and how Solver offers more flexibility by allowing changes in multiple variables and adding constraints.
▪️ Activating Solver: Step-by-step instructions on how to activate Solver in Excel if it's not already visible on your Data tab.
▪️ Practical Examples: Follow along with two real-world examples, demonstrating how Solver can handle complex problems with multiple variables and constraints.
▪️ Solver Settings Explained: Understand different Solver settings like GRG Non-Linear and Evolutionary, and when to use them.
▪️ Easy-to-Follow Guide: Even if you're new to Solver, our simple and clear explanations make it easy to start using this powerful tool for your Excel projects.

00:00 Define and Solve a Problem by Using Excel Solver
00:15 Solve Problems in Excel with 2 or More Variables
06:56 Solve What-If Problems with Constraints

In this video, I show you two examples:
1 - How to set income to a specific value by changing prices which adding constraints for the price and also full rounded number for units sold.
2. Distribute the remaining budget dollars among your different projects based on certain cost constraints.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[davidv.]

My exam is on tuesday, you saved me. In 10 minutes you explained it better than my teacher in various lessons.

[bukky]

Leila's calm voice is everything. Gosh. Thank you so much for demystifying seemingly complicated topics.

[LandscapeInMotion]

You are brilliant! Your thirst for teaching is infectious.

[nipunkavinda]

The person who invented this solver addon to MS Excel is a Genius minded guy in Microsoft as per my personal thoughts. Some companies purchase MS Excel only to use this addon for complex business matters. Leila, thanks for the delivery of ur knowledge on behalf of solver addon to ease use.

[alyuvar]

What a powerful tool nobody told this to me yet. Thanks Leila.

[raghuv]

There is no compromise in learning when you teach us in best ways as usual and always.

[pablodumas]

Goal seek was enough to solve my problem, and you showed me in less than 2 minutes; concise and helpful as always, Leila!

[torkunc]

can't imagine how you saved my life today.

thnx a lot for great vids...

[govindswarooptube]

The way you make it easy to understand is unbelievable. Best tutor on Youtube.

[GiteshBajaj]

Didn't knew solver existed in excel.

Thank you...

[lisaamante]

Las Vegas, NV, USA: Excellent, clear, concise, quick, thorough. Thank you!!

[herdube]

Thank you Leila for allowing me to know more and more everyday about excel.

[kartikthakur]

after learning from your Udemy course, I came here. Leila you explain so well ! You're a good teacher

[alvinlorejas]

Wow! I love excel and had been using it for 10 years now and I only know that there is a functionality like this! Impressive! As usual, very impressed with your video! thank you very much! You made it easier to understand!! <3

[Accountingplus]

It is an advanced form of goal seek function. A nice way to explain it.

[rchavezc]

Some Leila´s videos are absolutely fantastic but the others ... are even better. Thank you Leila, you re fantastic virtual teacher

[thomasdooleypranoto]

I like the way you explain this. Your grammar, tone, the voice...excellent...

[tsheringtobgay]

always the best teacher with great examples to make you understand. Anything excel, this is the absolute best channel. Thank you always, Leila :)

[stevebrown]

Short and very clear introduction. Thanks, just what I was after.

[khanmengui]

I love this video so much. This my first time of hearing about excel solver from my PHD Professor and with even his lectures, I didn't understand at all . So I had to go to YouTube to search for videos that can help me have a crew as to what excel solver was. Behold, I came across your wonderful video which helped me a lot. At least I can understand now, though not perfectly but I hope I will understand perfectly soon. Thanks a lot for the video