Excel 2010 -2016 Solver for Optimum Business Solutions

Price: $39.00

CPE Credits: 3.0

Category: ,

Course Number: EX10MCSOLV

solver - excel cpe

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
  • Ideas for spreadsheet design
  • 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

Advanced Preparation: None

Author: Joseph P. Helstrom, CPA  and Patricia McCarthy

Publication: November 2014
Revision:  February 2017

Format: PDF and Exercise Files
Pages: 60

Passing Grade: 70%

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

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

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
  • Ideas for spreadsheet design
  • 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

Advanced Preparation: None

Author: Joseph P. Helstrom, CPA  and Patricia McCarthy

Publication: November 2014
Revision:  February 2017

Format: PDF and Exercise Files
Pages: 60

Passing Grade: 70%

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

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

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

 

  • Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

    - Draper

  • “..may I say it is rarer that I ever have gotten a personal reply from a CPE Site! Glad I have found your site.”

    - Tom

  • “Excellent Regulatory Review Course. The self-study format (E-Book) provided an excellent overview of the regulatory requirements for California CPAs. I will be using the E-Book as  a reference material. Thank you for providing a very comprehensive yet affordable option for this required CPE.”

    - Constance