Decision Making Functions with Excel

Price: $29.85

CPE Credits: 3.0

Category: ,

Course Number: CXLOG3MC

decision making functions in excel

Description:
This course overviews several Excel Logical functions, such as IF, IFs, AND, OR an and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs. IFERROR and IFNA are also covered.  You will find these functions useful in your budgeting and analysis work. This eBook includes exercise files.

Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This EBook is designed for professionals using Excel 2013 through and including Excel 2019. If you have an earlier version, there may be a few functions covered that you will not be able to try.

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: June 2019

Format: PDF and Exercise Files
Pages: 56

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 so the correct one can be selected.
  • Recognize the components of the Logic Functions.
  • Understand and recognize the syntax of different decision-making functions.
  • Be able to differentiate and use nested and embedded IF functions.

Description:
This course overviews several Excel Logical functions, such as IF, IFs, AND, OR an and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs. IFERROR and IFNA are also covered.  You will find these functions useful in your budgeting and analysis work. This eBook includes exercise files.

Table of Contents

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This EBook is designed for professionals using Excel 2013 through and including Excel 2019. If you have an earlier version, there may be a few functions covered that you will not be able to try.

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: June 2019

Format: PDF and Exercise Files
Pages: 56

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 so the correct one can be selected.
  • Recognize the components of the Logic Functions.
  • Understand and recognize the syntax of different decision-making functions.
  • Be able to differentiate and use nested and embedded IF functions.
  • I loved the course as it had current cases which I am familiar with. Best ethics course I have taken in recent memory. Thanks!”

    - Kathy

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

    - Thank you :)

  • 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