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


Leave a Reply

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

XBOX 360 Hardware Failure

How to Fix USB Error Code 52 Windows cannot verify the digital signature