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 |
Buy |
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