Decision Making Functions in Excel

Course Information

(No Reviews Yet)

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

Description

Description:

This course overviews several Excel 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 course 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.

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:

1. Identify different decision making functions and their purpose and which to select 2. Recognize the components of the Logic functions 3. Recognize the syntax of different decision making functions 4. Differentiate and use nested and embedded functions within an IF statement

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