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.
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!!
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 RUclips 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
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.
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!!
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.
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.
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.
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!
Thanks!
Thank you very much! 🙏
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.
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.
There is no compromise in learning when you teach us in best ways as usual and always.
Many thanks for the kind feedback.
The way you make it easy to understand is unbelievable. Best tutor on RUclips.
after learning from your Udemy course, I came here. Leila you explain so well ! You're a good teacher
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 :)
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!!
Didn't knew solver existed in excel.
Thank you...
Las Vegas, NV, USA: Excellent, clear, concise, quick, thorough. Thank you!!
Thanks for watching, Lisa!
always the best teacher with great examples to make you understand. Anything excel, this is the absolute best channel. Thank you always, Leila :)
I like the way you explain this. Your grammar, tone, the voice...excellent...
Thank you Leila for allowing me to know more and more everyday about excel.
You're welcome Cain. Thank you for the support.
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 RUclips 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
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++ 💥
Very nice to follow and learn from. I needed a refresher on this and it was fabulous
আপনার প্রতিটি ভিডিও আমার কাছে অনেক গুরুত্বপূর্ণ। সত্যিই অসাধারণ আপনার কাজগুলো। ধন্যবাদ।
Short and very clear introduction. Thanks, just what I was after.
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.
I am so in love with your way of teaching!😍❤️❤️❤️Thank you so much for making my study easy and interesting!!!!❤❤❤
Excellent. I am SUBSCRSIBED! Most clear, simple explanation of Solver I have seen.
Awesome, thank you!
Fabulous! Thank you for this one. I am studying Financial Analysis, and this has really helped me.
Thanks, amazing video. May Almighty reward you.
Great Show ! Leila, I am getting addicted to your videos. You are just excellent. Thank you !
Excellent explanation on using Excel Solver. You have a knack for making the complicated simple to understand. Thanks for the video.
You are my go to RUclipsr for Excel tips and tricks
Thanks Amy!
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!
You explained it so simply for my dull brain thank you!
You are so welcome, Albert!
Very useful presentation for beginners , because many users do not know the use and even the existence of the solverThank you
Liked a lot the way you explain Leila. Thanks for the tips.
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 RUclips if you want to check that out.
Very simple way to learn complex problem, Excellent!
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!!
Thanks it helped me while I was preparing assignment on just last day😅
This was absolutely new one for me....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.
I understood solver courtsey this video. Thx Leila. Kindly keep making such videos.
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.
Ur brief explanation gives me a detailed knowledge
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 for sharing with us Leila , you're amazing
You have really contributed to my skills! thumbs up
I'm glad to hear that Isaac. Thank for the 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.
6:53 output should be 1,998.48
Thanks! Very nice lesson. Gave you a thumbs up.
Nice video and audio too... The right pace.
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
Thanks
Thank you!
Except for Solver, rest two What-if analysis tools are practically useless. Great video by the way!
Learned this for my homework. Thank you!
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 a well explained video. Helped me a lot!
I'm happy to hear that, Jan!
Always Problem Solver Video. Thanks
I really appreciate your videos and your instruction style.
Happy to hear that!
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. 😃😃
What a simple explanation to a complex function, great vdo ma'am
THANK YOU AS ALWAYS LEILA
Simple and Great Explanation.
Awesome you helped me a lot 🌺🙏🏻👏🏻👏🏻👏🏻
Wow!! I just loved how you explained you know....
Can you please make a video in which If and vlookup functions used at a time .
Leila your videos are insightful
for beginners
I'm glad to hear that.
Thank you for the lesson!
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.
You are a great instructor Laila.
Really nice. Easy to understand and follow. Thank you.
My pleasure. Glad the tutorial is helpful.
Another Excellent topic Ms. Leila. Thank you so much.
You're welcome Rosebud.
Thanks Ma'am . Very helpful as a tax advisor
Happy to help!
Thank you so much four you details explanation.
Thank you very much, Leila! Much appreciated.
Your explanation is crystal clear. 👏👏keep up the good work
Thank you so much ❤
That is very good Leila. Excellent.
Thank you Luqman. Glad you like it!
Great work, your explanation was really great
Better than my Professor
Thanks Leila!! the video was legit & informative 👍🏻
So nicely & easily explained!
Very useful! Thank you.
Its so well explained that the solver seems solvable - Thank you Leila
Excellent explanation....
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!
very excellent lesson ..thanks .Madam .
I'm glad you like the tutorial.
Can solver help me get to the NEAREST desired sum if my exact desired sum is not achievable?
thank you for providing a fabulous lesson.
My pleasure!
Amazing Explanation!
Great work ! Very good explanation ! I can understand quickly and easily
Glad to hear that Suteep.
Nice tutorial Miss Leila.
Luv the way you solve the problems
Thank you. Very happy to hear that Maneesh :)
A very clear video explaining the concept use of solver. Thanks
Thank you Awesh. Glad you like it :)
Amazing video. Learning a lot from your videos.
Thank you Kashif. I'm glad to hear that :)
That's was very helpful. Thanks a lot! :)
You're very welcome.
wow very well explained ... got it :)
Damn ! Pretty good explanation ❤️❤️❤️
Glad you like it :)
@@LeilaGharani dear , Im stuck at a point ...I need to solve it through solver . Please help in that