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 ethics course was the most interesting and clear course I have taken. I usually dread the years it is required but this year was a pleasant surprise.

    - Terry

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.

  • ” This was my first experience with CPASelfStudy.com and I was very impressed. I will definitely consider taking CPE through CPASelfStudy.com in the future.”   12/2017

    - Christopher Q.