Excel Solver - Example and Step-By-Step Explanation

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/solver-file

[@bukky9241]

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

[@davidv.7575]

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

[@LandscapeInMotion]

You are brilliant! Your thirst for teaching is infectious.

[@CivilApps]

Thanks!

[@LeilaGharani]

Thank you very much! 🙏

[@alyuvar]

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

[@pablodumas9446]

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

[@LeilaGharani]

Great to hear!

[@raghuv7114]

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

[@LeilaGharani]

Many thanks for the kind feedback.

[@govindswarooptube]

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

[@torkunc]

can't imagine how you saved my life today. thnx a lot for great vids...

[@LeilaGharani]

You're very welcome. I'm glad the video is helpful.

[@nipunkavinda8254]

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.

[@rchavezc67]

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

[@LeilaGharani]

Thank you Roberto! I'm glad you enjoy the videos :)

[@johng5295]

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++ 💥

[@alvinlorejas2687]

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!!

[@kartikthakur5561]

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

[@tsheringtobgay6870]

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

[@thomasdooleypranoto4471]

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

[@lisaamante5384]

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

[@LeilaGharani]

Thanks for watching, Lisa!

[@denconstutube]

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.

[@stevebrown164]

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

[@Accountingplus]

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

[@GiteshBajaj]

Didn't knew solver existed in excel. Thank you...

[@jean-francoisregnard4889]

Great Show ! Leila, I am getting addicted to your videos. You are just excellent. Thank you !

[@farwatskitchen13]

I am so in love with your way of teaching!😍❤️❤️❤️Thank you so much for making my study easy and interesting!!!!❤❤❤

[@herdube1]

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

[@LeilaGharani]

You're welcome Cain. Thank you for the support.

[@khanmengui3709]

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 KZbin 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

[@LeilaGharani]

Glad it was helpful!

[@khanmengui3709]

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

[@lwinnekins4303]

Excellent explanation on using Excel Solver. You have a knack for making the complicated simple to understand. Thanks for the video.

[@johnadair6242]

Fabulous! Thank you for this one. I am studying Financial Analysis, and this has really helped me.

[@CatherineWark]

Very nice to follow and learn from. I needed a refresher on this and it was fabulous

[@alifarhat300]

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.

[@minisquirty]

Thanks

[@LeilaGharani]

Thank you!

[@marlonpatino7677]

Liked a lot the way you explain Leila. Thanks for the tips.

[@AleeHayder12]

Can you please make a video in which If and vlookup functions used at a time .

[@vivekmusafir4492]

This was absolutely new one for me....thank you...

[@viqarhusain3294]

Very simple way to learn complex problem, Excellent!

[@keithd1576]

Excellent. I am SUBSCRSIBED! Most clear, simple explanation of Solver I have seen.

[@LeilaGharani]

Awesome, thank you!

[@Maya-sv1pz]

You are my go to KZbinr for Excel tips and tricks

[@LeilaGharani]

Thanks Amy!

[@freelancetaxsolution5384]

আপনার প্রতিটি ভিডিও আমার কাছে অনেক গুরুত্বপূর্ণ। সত্যিই অসাধারণ আপনার কাজগুলো। ধন্যবাদ।

[@syedmuhammadrafay228]

Thanks, amazing video. May Almighty reward you.

[@olivia_koo__]

You and excelisfun are my go-to excel guru for inspiration and tips! Thanks for all the sharing!

[@LeilaGharani]

Thank you! Mike from ExcelisFun is GREAT! I love his videos.

[@sakshimishra4171]

Ur brief explanation gives me a detailed knowledge

[@irajabaly]

Very useful presentation for beginners , because many users do not know the use and even the existence of the solverThank you

[@Mr1996rivera]

You explained it so simply for my dull brain thank you!

[@LeilaGharani]

You are so welcome, Albert!

[@ArshadAli07.kapilvastu]

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

[@LeilaGharani]

I have a VBA playlist on KZbin if you want to check that out.

[@mohammedlabeeb]

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.

[@LeilaGharani]

Wow, thank you!

[@ppat1551]

Nice video and audio too... The right pace.

[@LeilaGharani]

I'm glad to hear that.

[@katestan7002]

Thank you for the lesson!

[@ram-it.damn-it]

I understood solver courtsey this video. Thx Leila. Kindly keep making such videos.

[@salimal-tarsha5564]

Thanks for sharing with us Leila , you're amazing

[@studyphile6328]

What a simple explanation to a complex function, great vdo ma'am

[@wayneedmondson1065]

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!!

[@DGerharts]

THANK YOU AS ALWAYS LEILA

[@TheHeldover]

Can solver help me get to the NEAREST desired sum if my exact desired sum is not achievable?

[@pecks33331]

I really appreciate your videos and your instruction style.

[@LeilaGharani]

Happy to hear that!

[@isaacmuhanga]

You have really contributed to my skills! thumbs up

[@LeilaGharani]

I'm glad to hear that Isaac. Thank for the thumbs up!

[@bigshot_07]

6:53 output should be 1,998.48

[@castrolkainda10]

Wow!! I just loved how you explained you know....

[@alexrosen8762]

You are just fantastic. Did not know that solver was such a powerful tool!

[@LeilaGharani]

Glad you like it Alex. Thank you. I also didn't know for the longest time :)

[@yuliuswerry]

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

[@sidharthbyju9727]

Simple and Great Explanation.

[@jiangweixiao3469]

Learned this for my homework. Thank you!

[@AbdulHameed-ir1un]

Thanks! Very nice lesson. Gave you a thumbs up.

[@realhamza85]

You are a great instructor Laila.

[@Softwaretrain]

I knew this feature but your explanation and your usefull example clear it more for me. Thanks alot Leila.

[@LeilaGharani]

You're very welcome! Glad you like it.

[@hritikkable]

Thanks Leila!! the video was legit & informative 👍🏻

[@rew2far1]

Leila your videos are insightful for beginners

[@LeilaGharani]

I'm glad to hear that.

[@kararshah6056]

Great work, your explanation was really great

[@gauravgupta9825]

So nicely & easily explained!

[@ZlatkaGocheva]

Thank you very much, Leila! Much appreciated.

[@DrSNirmalaDirectorPGDeptofComm]

Really nice. Easy to understand and follow. Thank you.

[@LeilaGharani]

My pleasure. Glad the tutorial is helpful.

[@jpreddy3127]

Your explanation is crystal clear. 👏👏keep up the good work

[@jadoabad]

Another Excellent topic Ms. Leila. Thank you so much.

[@LeilaGharani]

You're welcome Rosebud.

[@trevorm1970]

great video! how do you get it to adjust the values to fractional numbers?

[@JanKremser]

Thank you for a well explained video. Helped me a lot!

[@LeilaGharani]

I'm happy to hear that, Jan!

[@nlcreations0]

Thanks it helped me while I was preparing assignment on just last day😅

[@apn6824]

Excellent explanation....

[@gunaybabacanova]

Thank you so much ❤

[@vivekmusafir4492]

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…

[@TheChainsbroken]

Nice tutorial Miss Leila.

[@michaelconnors7668]

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.

[@luqmananuar6705]

That is very good Leila. Excellent.

[@LeilaGharani]

Thank you Luqman. Glad you like it!

[@layla0723]

Thank you so much four you details explanation.

[@sanjaykumar6004]

Simply Great!!!, Thanks

[@Jojo-bz9kf]

Very useful! Thank you.

[@maneeshbenjwal849]

Luv the way you solve the problems

[@LeilaGharani]

Thank you. Very happy to hear that Maneesh :)

[@eokaandres8395]

Amazing Explanation!

[@mdumairali4373]

thank you for providing a fabulous lesson.

[@LeilaGharani]

My pleasure!

[@chelebarry]

Great video please share more examples...

[@aeybeec]

Always Problem Solver Video. Thanks

[@banwarifageriaexcelclasses1447]

very excellent lesson ..thanks .Madam .

[@LeilaGharani]

I'm glad you like the tutorial.

[@VS-rh8rq]

Till today, thought solver was some decoration feature only in excel!!After 3 rd attempt finally understood.Thanks again

[@LeilaGharani]

:) You're very welcome Vimal.

[@zinahhammadi8989]

Awesome you helped me a lot 🌺🙏🏻👏🏻👏🏻👏🏻

[@samuelatokwamebaah7371]

You are the best Thank you 🙏

[@mzemhret]

Easy to understand and follow. Good job

[@ushaagarwal4058]

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. 😃😃

[@explorerhari]

Great Content Future KZbin 🌟

[@kashifiman7631]

Amazing video. Learning a lot from your videos.

[@LeilaGharani]

Thank you Kashif. I'm glad to hear that :)

[@yaseenahmad9237]

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.

[@mahmoudmohsen8105]

very cool , does any one know an example of using solver for budgeting for multiple product sales?

[@riadhalrabeh3783]

Brilliant thank you and all the best.