Decision Making Functions with Excel

Price: $29.85

CPE Credits: 3.0

Category: ,

Course Number: CXLOG3MC

decision making functions in excel

Description:
This Excel course overviews several Logical functions and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs and IFERROR.  You will find these functions useful in your budgeting and analysis work. This EBook is based upon 2016 and includes exercise files. but  users of earlier Excel versions (2007-2013) should have no difficulties. Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This EBook is designed for professionals using Excel 2007 through and including Excel 2016.

Prerequisites: This course is considered a basic to intermediate level course. It is expected that participants know basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet. It is also assumed that participants understand how to create and use a basic function.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: November 2009
Revision: March 2017

Format: PDF and Exercise Files
Pages: 52

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:

  • Identify different decision making functions and their purpose and which to select
  • Recognize the components of the Logical functions
  • Understand and recognize the syntax of different decision making functions
  • Be able to differentiate and use nested and embedded functions within an IF statement

Description:
This Excel course overviews several Logical functions and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs and IFERROR.  You will find these functions useful in your budgeting and analysis work. This EBook is based upon 2016 and includes exercise files. but  users of earlier Excel versions (2007-2013) should have no difficulties. Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This EBook is designed for professionals using Excel 2007 through and including Excel 2016.

Prerequisites: This course is considered a basic to intermediate level course. It is expected that participants know basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet. It is also assumed that participants understand how to create and use a basic function.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: November 2009
Revision: March 2017

Format: PDF and Exercise Files
Pages: 52

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:

  • Identify different decision making functions and their purpose and which to select
  • Recognize the components of the Logical functions
  • Understand and recognize the syntax of different decision making functions
  • Be able to differentiate and use nested and embedded functions within an IF statement
  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

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

  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course