Course:  Excel Solver for Optimum Business Solutions

Author:Joseph Helstrom, CPA 

Course ID: EXMCSOLV/EX10MCSOLV

CPE Hours: 4 

 Format: PDF and Excel exercise files

Click here for the Excel 2007 version
Price: $33.00

Click here for the Excel 2010 Version
Price: $33.00

Delivery: Internet/Interactive

Solver is part of Excel's What-if analysis tools. Solver is a very powerful feature which allows you to find optimum values when working with multivariables.

This course provides instruction on the uses of Excel Solver to solve complex business problems.  Through the use of examples, an overall understanding of the following will be achieved:

• Optimization of a target cell
• The use of constraints
• The use of binary constraints to make choices
• Ideas for spreadsheet design
• The SUMPRODUCT function
  
  Examples include production environments, advertising, capital budgeting, lockbox selection and employee scheduling.

This course provides step by step instruction and Excel practice exercises as well as answer files.

==================================

Learning Objective:

• An overall understanding of Excel solver and its uses in solving business problems.
• An understanding of the spreadsheet design of an Excel Solver model through the use of examples.
• How to use constraints to optimize solutions.
• An understanding of the SUMPRODUCT function.
• The uses of the binary constraint to make optimum choices among alternatives.

NASBA Category:
Computer Science/Specialized Knowledge

Updated/Revised: November 2011