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.
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++ 💥
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.
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!!
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.
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 TH-cam 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
Please if you can upload another video that will help be able to know the dynamic optimal allocation of resources given the demand and supply equations, maximum quantity, it would be appreciated
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.
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
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!!
Solver uses the Broyden-Fletcher-Goldfarb-Shanno algorithm which is a non-linear optimization. Quattro Pro also uses the Broyden-Fletcher-Goldfarb-Shanno algorithm for its Optimizer tool. Solver looks a "black box" tool, but when you know what it is based on you can kind of understand what the solver does.
Thnx. For this tutorial…however I have a different need…I want solver outputs to be mentioned in separate cells so that comparison between current and proposed could be done…it’ll help achieve in Target vs. achievement scenario…can you help on this please…thank you…
Thanks so much for your great video on Solver. I have Microsoft Excel for Mac, version 16.72. When I want to separate two cells in "By changing variable cells" it does not work with the comma or whatever else. Have you got any idea about that? Many thanks in advance and keep your fantastic tutorial work going on, please!
An excellent explanation. Please can you use goal seek in bill of quantities in quantity surveying profession. For example, you produced a bill and later after you were given a cost limit, a figure. How can I use goal seek there.
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 ?
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.
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.
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!!!!❤❤❤
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!
Las Vegas, NV, USA: Excellent, clear, concise, quick, thorough. Thank you!!
Thanks for watching, Lisa!
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 :)
Short and very clear introduction. Thanks, just what I was after.
It is an advanced form of goal seek function. A nice way to explain it.
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++ 💥
Thank you Leila for allowing me to know more and more everyday about excel.
You're welcome Cain. Thank you for the support.
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.
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!!
Excellent. I am SUBSCRSIBED! Most clear, simple explanation of Solver I have seen.
Awesome, thank you!
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.
after learning from your Udemy course, I came here. Leila you explain so well ! You're a good teacher
I like the way you explain this. Your grammar, tone, the voice...excellent...
Great Show ! Leila, I am getting addicted to your videos. You are just excellent. Thank you !
The way you make it easy to understand is unbelievable. Best tutor on TH-cam.
Excellent explanation on using Excel Solver. You have a knack for making the complicated simple to understand. Thanks for the video.
Didn't knew solver existed in excel.
Thank you...
THANK YOU AS ALWAYS LEILA
This was absolutely new one for me....thank you...
Liked a lot the way you explain Leila. Thanks for the tips.
You explained it so simply for my dull brain thank you!
You are so welcome, Albert!
Fabulous! Thank you for this one. I am studying Financial Analysis, and this has really helped me.
Very simple way to learn complex problem, Excellent!
Can you please make a video in which If and vlookup functions used at a time .
Ur brief explanation gives me a detailed knowledge
Can solver help me get to the NEAREST desired sum if my exact desired sum is not achievable?
Thank you for the lesson!
Thanks! Very nice lesson. Gave you a thumbs up.
Learned this for my homework. Thank you!
Thank you very much, Leila! Much appreciated.
I understood solver courtsey this video. Thx Leila. Kindly keep making such videos.
Wow!! I just loved how you explained you know....
Simply Great!!!, Thanks
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 TH-cam 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
Glad it was helpful!
Please if you can upload another video that will help be able to know the dynamic optimal allocation of resources given the demand and supply equations, maximum quantity, it would be appreciated
You have really contributed to my skills! thumbs up
I'm glad to hear that Isaac. Thank for the thumbs up!
You are my go to TH-camr for Excel tips and tricks
Thanks Amy!
Very useful presentation for beginners , because many users do not know the use and even the existence of the solverThank you
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!
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 TH-cam if you want to check that out.
I really appreciate your videos and your instruction style.
Happy to hear that!
Thank you so much four you details explanation.
What a simple explanation to a complex function, great vdo ma'am
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.
Thanks for sharing with us Leila , you're amazing
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.
Thank you for a well explained video. Helped me a lot!
I'm happy to hear that, Jan!
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!!
আপনার প্রতিটি ভিডিও আমার কাছে অনেক গুরুত্বপূর্ণ। সত্যিই অসাধারণ আপনার কাজগুলো। ধন্যবাদ।
Really nice. Easy to understand and follow. Thank you.
My pleasure. Glad the tutorial is helpful.
Nice video and audio too... The right pace.
I'm glad to hear that.
Excellent explanation....
Thank you so much ❤
Another Excellent topic Ms. Leila. Thank you so much.
You're welcome Rosebud.
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 for providing a fabulous lesson.
My pleasure!
Simple and Great Explanation.
Leila your videos are insightful
for beginners
I'm glad to hear that.
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
Thank you so much❤️It's very helpful
Thanks it helped me while I was preparing assignment on just last day😅
Always Problem Solver Video. Thanks
great video! how do you get it to adjust the values to fractional numbers?
So nicely & easily explained!
very excellent lesson ..thanks .Madam .
I'm glad you like the tutorial.
Outstanding! Thank you for this video - sharing
Your explanation is crystal clear. 👏👏keep up the good work
You are a great instructor Laila.
Very useful! Thank you.
Solver uses the Broyden-Fletcher-Goldfarb-Shanno algorithm which is a non-linear optimization. Quattro Pro also uses the Broyden-Fletcher-Goldfarb-Shanno algorithm for its Optimizer tool. Solver looks a "black box" tool, but when you know what it is based on you can kind of understand what the solver does.
A very clear video explaining the concept use of solver. Thanks
Thank you Awesh. Glad you like it :)
Thanks!
Thank you very much! 🙏
Thanks a lot ..very useful for working professionals
You're very welcome.
Thanks Ma'am it was v.informative
Thnx. For this tutorial…however I have a different need…I want solver outputs to be mentioned in separate cells so that comparison between current and proposed could be done…it’ll help achieve in Target vs. achievement scenario…can you help on this please…thank you…
Thanks Leila!! the video was legit & informative 👍🏻
You are the best
Thank you 🙏
Amazing Explanation!
Nice tutorial Miss Leila.
Great work, your explanation was really great
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. 😃😃
Thanks for simplified explaination
Till today, thought solver was some decoration feature only in excel!!After 3 rd attempt finally understood.Thanks again
:) You're very welcome Vimal.
Thanks so much for your great video on Solver. I have Microsoft Excel for Mac, version 16.72. When I want to separate two cells in "By changing variable cells" it does not work with the comma or whatever else. Have you got any idea about that? Many thanks in advance and keep your fantastic tutorial work going on, please!
Many thanks
Easy to understand and follow. Good job
An excellent explanation.
Please can you use goal seek in bill of quantities in quantity surveying profession. For example, you produced a bill and later after you were given a cost limit, a figure. How can I use goal seek there.
Awesome you helped me a lot 🌺🙏🏻👏🏻👏🏻👏🏻
awesome teaching. Thank you
Thank you Leila... Also please help me in creating calendar option in xcel field (as a periodic cut off date) for periodic reportings..
Very useful article to solve day to day business problems
Thank you Nipun :)
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 ?