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.
The Company Rocks