How to Use the Solver Tool in Excel



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

source

Leave a Reply

Your email address will not be published. Required fields are marked *