New Excel Functions: Excel 2019 and Microsoft 365

Course Information

(No Reviews Yet)
Title: New Excel Functions: Excel 2019 and Microsoft 365
Category: Computer Software
Field of Study: Computer Software and Applications
Course Code: S021-0526
CPE Credits: 1.0
Price: 12.95

Description

Description:

This course overviews some new features and functions that Microsoft offers in Excel 2019 and/or Microsoft 365. The course has an accompanying workbook. The course introduces the concept of dynamic arrays and related formulas such as SORT(), SORTBY() and Filter(). XLOOKUP() is an update and is intended to effectively replace VLOOKUP(). XLOOKUP() is a must know function and totally improves all the problems of VLOOKUP(). UNIQUE() allows you to identify unique values in a range. The course also covers CONCAT() and TEXTJOIN() which are new text functions that Excel has introduced. CONCAT() is intended to replace the older CONCATENATE(). The course ends with a discussion of some other new functions including IFS(), SWITCH() and MINIFS().

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 the definition of an array 2. Recognize how a dynamic array works 3. Recognize new Excel functions and how to use them

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