Decision Making Functions with Excel (DFMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Overview
Credits
3
Qualifies For
CPE



Price:  $ 29.99

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.

Additional information

year

2022

version

01

Credits

3

Company Code

Self Study

Format

On Demand

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (3)

Field of Study Department

Computer Software & Applications

Course Version

2022-01

CPE Approved

1

Pre-requistes:

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 particip

Knowledge Level:

Overview

Major Topics:

  • Overview of Excel Logical functions

Learning Objectives:

  • 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

Designed For:

All CPAs

Customer Reviews

Based on 3 reviews
100%
(3)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
P
Pamela N. (Wilmington, US)
Useful course

This course was very helpful and I have already found myself using what I learned to prepare, sort, and filter tables in Excel.

J
Jennifer S. (Foster, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

L
Lauren V.D. (Montgomery Village, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)