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

Policies: Click here

Author: Patricia McCarthy

Category: Computer Software

Field of Study: Computer Software and Applications

Passing Score: 70%

Publication Date: 03/03/2021

Technical Details:

For More Detail: Click here

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

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: Click here

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

NASBA: Yes

QAS: Yes

CPA: Suitable for all CPAs

IRS: No IRS credit for Enrolled Agents.

Profession Identifiers : CPA