How to Use Solver in Excel

Solver in Excel can be used to to solve an equation or a business problem when there are many variables as well constraints.
For example, want to find out the maximum profit, when you have the constraint of raw material and assembly line.
In this video, I take a simple example to showcase the power of Solver.
Read Full Tutorial and Download Example File: trumpexcel.com/solver-in-excel/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzbin.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@johng5295]

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

[@GeorgeAJululian]

many thanks very helpful

[@jimconley8026]

This was easily the best explanation of solver I have seen.

[@tpnravichandra4255]

Simple & Good explanation,Thank you..🙏

[@spuneet156]

I was learning this in my cubicle today, and it was new for me but amazing

[@NaveenKumar-tp9pj]

Simply Awesome

[@drallisimo34]

cool tutorial!!!

[@MBD2903]

Superb 👍👍

[@coolestrami]

If you have 5 cells each one of them value of 2 ... how u get all potential cells that sum of them equal to 8 ??? Using solver please advise

[@pashtun-travels-uk]

i did exactly the same but the error says "objective cell contents must be a formula", which is also the same as in video. why am i getting the same error again and again? anyone can help???

[@govindpaliwal1904]

Hi, 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 ?

[@kailashmehta7568]

How to use solver if I have to minimise more than one value with separate variable in one time . For example , minimize A with variable a , b and c . also minimize B with variable x , y and z and so on . Like wise optimise not variable separately in one time

[@fredericklandro1650]

This vid gets a like for being "Trump" excel.

[@outside7]

make excel great again

[@mooosj]

Great video! Not a good time to have "trump" on your channel's name tho :P