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
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