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