Sign in to confirm you’re not a bot
This helps protect our community. Learn more

How to Use the Solver Tool in Excel

Danny Rocks
59.8K subscribers
1.1M views 13 years ago
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 ...more
...more
How to Use the Solver Tool in Excel
2.3KLikes
1,193,704Views
2011Sep 21
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

Follow along using the transcript.

Danny Rocks

59.8K subscribers