Excel 2010 -2016 Solver for Optimum Business Solutions

Price: \$39.00

CPE Credits: 3.0

Category: ,

Course Number: EX10MCSOLV

Description:
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
• The SUMPRODUCT functionExamples 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.  Table of Contents

Delivery Method: Online QAS Self Study.

Level: Intermediate.

Version: Excel 2010. 2013 and 2016

Prerequisites: None

Author: Joseph P. Helstrom, CPA  and Patricia McCarthy

Publication: November 2014
Revision:  February 2017

Format: PDF and Exercise Files
Pages: 60

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants should be able to:
(1) Recognize Excel solver and its uses in solving business problems.
(2) Identify how to use constraints to optimize solutions.
(3) Define the SUMPRODUCT function and recognize the uses of the SUMPRODUCT function within solver.
(4) Identify how to use the binary constraint to make optimum choices among alternatives.
(5) Identify which solver parameter inputs to use in solving complex business problems
(6) Define linear programming as it is used by Excel solver

Description:
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
• The SUMPRODUCT functionExamples 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.  Table of Contents

Delivery Method: Online QAS Self Study.

Level: Intermediate.

Version: Excel 2010. 2013 and 2016

Prerequisites: None

Author: Joseph P. Helstrom, CPA  and Patricia McCarthy

Publication: November 2014
Revision:  February 2017

Format: PDF and Exercise Files
Pages: 60

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants should be able to:
(1) Recognize Excel solver and its uses in solving business problems.
(2) Identify how to use constraints to optimize solutions.
(3) Define the SUMPRODUCT function and recognize the uses of the SUMPRODUCT function within solver.
(4) Identify how to use the binary constraint to make optimum choices among alternatives.
(5) Identify which solver parameter inputs to use in solving complex business problems
(6) Define linear programming as it is used by Excel solver

• ” I was able to get a head start on my credit losses research through your CPE self study this past weekend.  Excellent quality format – so much better than some of the other resources I’ve been using lately.”  Dec 12, 2018

- Andrea Ll.

• “always love your site and prompt customer service !! ”  Dec. 2017

- Thank you :)

• Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

- Connie K.