Excel Solver - Example and Step-By-Step Explanation
Vložit
- čas přidán 30. 07. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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.
⬇️ Download the workbook here: pages.xelplus.com/solver-file
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.
Goal Seek Video: • Excel Goal Seek Explai...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
Grab the file I used in the video from here 👉 pages.xelplus.com/solver-file
My exam is on tuesday, you saved me. In 10 minutes you explained it better than my teacher in various lessons.
Leila's calm voice is everything. Gosh. Thank you so much for demystifying seemingly complicated topics.
You are brilliant! Your thirst for teaching is infectious.
What a powerful tool nobody told this to me yet. Thanks Leila.
It is an advanced form of goal seek function. A nice way to explain it.
Excellent video. This is a great tool for solving and optimizing annual department and company budget generation. Thank you and a clear explanation on how to use Solver.
Leila, thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
Fabulous! Thank you for this one. I am studying Financial Analysis, and this has really helped me.
can't imagine how you saved my life today.
thnx a lot for great vids...
You're very welcome. I'm glad the video is helpful.
Short and very clear introduction. Thanks, just what I was after.
There is no compromise in learning when you teach us in best ways as usual and always.
Many thanks for the kind feedback.
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.
I am so in love with your way of teaching!😍❤️❤️❤️Thank you so much for making my study easy and interesting!!!!❤❤❤
The way you make it easy to understand is unbelievable. Best tutor on CZcams.
Excellent explanation on using Excel Solver. You have a knack for making the complicated simple to understand. Thanks for the video.
after learning from your Udemy course, I came here. Leila you explain so well ! You're a good teacher
Great Show ! Leila, I am getting addicted to your videos. You are just excellent. Thank you !
Hi Leila. I'm looking to learn more about Solver and found this video. Thanks for getting me started. As you mentioned, like others, I use Goal Seek often. Adding Solver to my arsenal will help with more complex situations. Thanks for sharing :)) Thumbs up!!
Learned this for my homework. Thank you!
Some Leila´s videos are absolutely fantastic but the others ... are even better. Thank you Leila, you re fantastic virtual teacher
Thank you Roberto! I'm glad you enjoy the videos :)
Amazing explanation. Can the solver be automated in a way to make it recalculate the value when any of the inputs is changed without using any button or any interference by the user? Regards.
Your videos are very helpful, thank you!
Las Vegas, NV, USA: Excellent, clear, concise, quick, thorough. Thank you!!
Thanks for watching, Lisa!
Liked a lot the way you explain Leila. Thanks for the tips.
This was absolutely new one for me....thank you...
Didn't knew solver existed in excel.
Thank you...
I understood solver courtsey this video. Thx Leila. Kindly keep making such videos.
Easy to understand and follow. Good job
Thank you for the lesson!
OMG. Your videos are amazing. You make hard topics so nicely Scaffolded, and you spiraled prior lessons into the video. Thanks for the great work.
I love how you define everything without complicating anything.
Wow, thank you!
I knew this feature but your explanation and your usefull example clear it more for me.
Thanks alot Leila.
You're very welcome! Glad you like it.
Thank you Leila for allowing me to know more and more everyday about excel.
You're welcome Cain. Thank you for the support.
Outstanding! Thank you for this video - sharing
Amazing Explanation!
Your explanation is crystal clear. 👏👏keep up the good work
What a simple explanation to a complex function, great vdo ma'am
I like the way you explain this. Your grammar, tone, the voice...excellent...
Very simple way to learn complex problem, Excellent!
Goal seek was enough to solve my problem, and you showed me in less than 2 minutes; concise and helpful as always, Leila!
Great to hear!
Thank you very much, Leila! Much appreciated.
So nicely & easily explained!
Very useful presentation for beginners , because many users do not know the use and even the existence of the solverThank you
THANK YOU AS ALWAYS LEILA
Really nice and easy to follow. Thanks
Simply Great!!!, Thanks
Thanks mam! In my school, I was not able to understand this which lead to deduction in my pre-boards but this helped me alot even without audio. 😃😃
Amazing tutorial!
Thanks Leila!! the video was legit & informative 👍🏻
Thanks for sharing with us Leila , you're amazing
Thank you very much Leila Gharani, this video solved my problem which I had been working on manually and took extra time. new sub here
finally I know what it does. thank you!
Thank you, the videos are really amazing
Thanks! Very nice lesson. Gave you a thumbs up.
Wow!! I just loved how you explained you know....
Ur brief explanation gives me a detailed knowledge
This is very useful. Thank you.
awesome teaching. Thank you
Thanks for the video did have a helpful insight
You and excelisfun are my go-to excel guru for inspiration and tips! Thanks for all the sharing!
Thank you! Mike from ExcelisFun is GREAT! I love his videos.
Great work, your explanation was really great
আপনার প্রতিটি ভিডিও আমার কাছে অনেক গুরুত্বপূর্ণ। সত্যিই অসাধারণ আপনার কাজগুলো। ধন্যবাদ।
Hi, can you suggest how to determine the a,b & c parameters in the exponential equation y = a + b (1-e -c (t) ) in excel?Thanks
Great work ! Very good explanation ! I can understand quickly and easily
Glad to hear that Suteep.
Thank you so much❤️It's very helpful
Hi Leila,
Following you since long & I genuinely appreciate your work!
I have a query in the solver, that would be great if you help me with this - As this is restricted only to 200 variables, I want to know how can I use this for more than 200 variables.
What I've is a column having amounts (+ve & -ve figures both) of which some are offsetting to zero & the remaining constitutes the total of all. Now what I've to do is to separate all those netting to zero & keep only those that are actually constituting total.
Kindly let me know what can be worked out in this scenerio ?
Thank you so much four you details explanation.
Simple and Great Explanation.
Hi Leila, thank you for a wonderful & useful blog. I would just like to find out if I can use Goal Seeker or Solver using a percentage as the base? In essence I know my cost & what percentage margin I would like to achieve so would like to know what the selling price should be. Regards, Sujeel.
Many thanks for the great explanation! Always used goal seek so far but this is a much better alternative.
You're welcome :)
I am looking forward to your take on VBA!
You are just fantastic. Did not know that solver was such a powerful tool!
Glad you like it Alex. Thank you. I also didn't know for the longest time :)
Thank you Leila.
Thanks for simplified explaination
Much love, Leila!
Brilliant thank you and all the best.
wow very well explained ... got it :)
I really appreciate your videos and your instruction style.
Happy to hear that!
Thank you Leila... Also please help me in creating calendar option in xcel field (as a periodic cut off date) for periodic reportings..
Thank you for information and some new ways to use it.
You're welcome Fahad.
Very useful! Thank you.
Another Excellent topic Ms. Leila. Thank you so much.
You're welcome Rosebud.
Nice tutorial Miss Leila.
Really nice. Easy to understand and follow. Thank you.
My pleasure. Glad the tutorial is helpful.
You have really contributed to my skills! thumbs up
I'm glad to hear that Isaac. Thank for the thumbs up!
Thank You!
Hi great video. How do you make solver update automatically when you change a value that is used in the equation, not an input value that you are asking to calculate but a constant that you set manually.
You are the best
Thank you 🙏
Excellent explanation....
A very clear video explaining the concept use of solver. Thanks
Thank you Awesh. Glad you like it :)
Thanks very nicely explained
Always Problem Solver Video. Thanks
Thank you for a well explained video. Helped me a lot!
I'm happy to hear that, Jan!
What is a similar function in excel to solver ? I am trying to have changing variables equal to each other to meet a set value.
Great Video. Keep it up
Fantastic tool it is. Never heard about it before. You are excellent. I have a small request, please make a detailed video on macros. I really want to learn it and I can't find a better teacher than you for it
I have a VBA playlist on CZcams if you want to check that out.
Thank you so much🙂
Thank you! Great video. I understand.
You're welcome! Thank you for you comment :)
Many thanks
You explained it so simply for my dull brain thank you!
You are so welcome, Albert!
Thanks Ma'am it was v.informative