Friday 23 September 2011

Use the Solver Add-in for Excel to Produce a Specific Formula Result

Title:
Use the Solver Add-in for Excel to Produce a Specific Formula Result


Video:


Description:This is Part 2 of my series of videos demonstrating how to use the SOLVER Add-in for Excel. Remember that SOLVER is not activated by default. I show you how to activate it in Part 1 of this series. Here, I want SOLVER to automatically change the Units Sold so that the resulting Gross Profit Sales are $25000. This is similar to the way that I used SOLVER in Part 1. What is different? I, first, used the SUMPRODUCT Function to determine what would be a "reasonable target" for SOLVER to produce. Even though SOLVER is a very powerful tool to use to produce Business Intelligence Reports, you must use your own intelligence - and understanding of your business - to make the proper decisions. I invite you to visit my online shopping website - shop.thecompanyrocks.com - to view all of my videos and to take advantage of the many resources that I offer you. Danny Rocks The Company Rocks

Published:
23/Sep/2011

No comments:

Post a Comment