Decision Making Functions in Excel

Course Information

Title:	Decision Making Functions in Excel
Category:	Computer Software
Field of Study:	Computer Software and Applications
Course Code:	M135
CPE Credits:	3.0
Price:	27.95

Description

Description:

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

Delivery Method: Online Interactive Self Study

Level: Overview

Prerequisites: None

Advanced Preparation: None

Course Details

Category: Computer Software

Field of Study: Computer Software and Applications

Passing Score: 70%

Technical Details:

For More Detail:

If you are unable to view PDF then right click the mouse and click save link as

Objectives

Objectives:

Identify different decision-making functions and their purpose so the correct one can be selected.
Recognize the components of the Logic Functions .
Recognize and apply the syntax of different decision-making functions
Be able to differentiate and use nested and embedded IF functions.

For More Objectives:

If you are unable to view PDF then right click the mouse and click save link as

Profession

NASBA: Yes

QAS: Yes

CPA: Suitable for all CPAs

IRS: No IRS credit for Enrolled Agents.

Profession Identifiers: CPA