In this tutorial, I introduce you to the powerful SOLVER Tool in Excel, Solver is an “Add-in” program in Excel. It is easy to “activate” as I demonstrate in this video.

The “Keys” to understanding how to effectively use SOLVER are:
1) Determine the “Target Cell” – which will return the result that you want SOLVER to produce. This cell MUST contain a FORMULA!

2) The “By Changing cells” that SOLVER will work with – These cells MUST feed into the TARGET CELL!

3) The CONSTRAINTS that you establish for SOLVER to observe as it finds a solution.

I think that you will enjoy my explanation of how to use this powerful and complex tool to generate the “real world” results that you are looking for in Excel.

Danny Rocks
The Company Rocks
www.thecompanyrocks.com

Nguồn:https://madisonrep.org/

28 Comments

Pierre Rizzo

February 24, 2020

Thanks a lot !!!

Reply

Muhammad Mahmood

February 24, 2020

I am a student of Excel. While trying this data set I noticed that the number of units to sell or at least the total number of units to sell are not considered as constraints. I tried with some imaginary alternative numbers and even used zero and found that many alternative number of units to sell can be used to reach 56% profit target. even in the example used in this video the total number of units to sell was changed from 144 to 145. If it is flexible than individual number of units to sell can also be flexible and that should give a range of confusing scenarios to choose from. Please let me know what you think.

Reply

Wilybard Ipangelwa

February 24, 2020

Thank you for the video, it is very helpful.
Does sir have videos on how to use the solver function to get intersection points on a graphs?

Reply

bhavya nawalakha.

February 24, 2020

Thank you, It was extremely helpful

Reply

Catherine Liu

February 24, 2020

This helps a lot! Thanks 🙂

Reply

MianAtee

February 24, 2020

Very nice briefing.

Reply

Mark Valenzuela

February 24, 2020

Hi, is there a way we can find the combination of the nearest sum if Target is not found? thank you

Reply

viianangel

February 24, 2020

Helped me a lot! Thank you!!

Reply

Cooper Urbany

February 24, 2020

I can now sleep at night knowing my ms 3053 section 006 professor does not think I am a worthless human being.

Reply

Temuulen Erdenebulgan

February 24, 2020

Explained very well!

Reply

nousheen rashid

February 24, 2020

Superb explaination .. very right pace… You are good at teaching.. thanks sir

Reply

elaineeyyy

February 24, 2020

hello there

Reply

Roman K

February 24, 2020

Danny, thank you for a clear tutorial. One question: are the values in I5:J14 hard numbers or formulas? I am getting "Solver could not find a feasible solution". If you could share the spreadsheet in the video, it would be very helpful. Thank you.

Reply

Lee Curcio

February 24, 2020

Hi. I have a question. I created a macro (VBA) that emulates the solver by clicking on a button. The problem is that sometime I have to click 3-4 times before getting the last results. Do you know how to avoid this and getting on solution with one click?

Reply

zionKai _

February 24, 2020

You are a great teacher! Thank you, it was easy to follow. Thank you again, this video has been a great help.

Reply

nipur chawla

February 24, 2020

Great video Danny. I was applying your tutorial on one the problems but I got stuck where i have to find the maximum product mix at 85% of current sales forecast & at 90% of cost of goods sold. what's the way to go for it? thanks for the help

Reply

Robin De cock

February 24, 2020

BAD

Reply

Julian Vanegas

February 24, 2020

mi

Reply

Stefano Eendragt

February 24, 2020

quick note next time consider starting with showing how to install the solver add-in
good video though

Reply

Anoopa Ann Thomas

February 24, 2020

can you please show how to solve very complex equations like equations with fractional powers in excel

Reply

Otto Omen

February 24, 2020

I wish you would have picked a different example.

Reply

Syed Usman

February 24, 2020

settling invoices by solver https://youtu.be/a7ZvXYOCDUc

Reply

Girish Soni

February 24, 2020

explained very well… thanks for that

Reply

Guilherme Neto

February 24, 2020

jump to 3:58

Reply

venkata siva naga babu

February 24, 2020

Thanks

Reply

Ocelot

February 24, 2020

Great, thank you!

Reply

Shannon R

February 24, 2020

Worked great for me! Thank you!

Reply

Yurong Liu

February 24, 2020

clearly explained. thanks

Reply

Leave a Reply