Overview
-
Learn about Dynamic Arrays
2 mins
-
Use of Unique function
10 mins
-
How to apply Filter function on the sheet
28 mins
-
Learn about XLOOKUP, IFS and SWITCH
39 mins
-
Using the New functions in Reports
48 mins
Course Description
In the second half of 2020, Microsoft released a significant upgrade to the most used spreadsheet program in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this CPE webinar for CPAs, we discuss the power of dynamic arrays and introduce the new functions.
This online webinar covers the below-mentioned functions:
- RANDARRAY- creating a table of random numbers or random dates
- UNIQUE – identifying the distinct items in a list
- SEQUENCE – listing numbers with a set interval
- SORT and SORTBY – new ways of dynamically sorting data
- FILTER – building the ability to filter data into formulae
- XLOOKUP – replacing VLOOKUP with greater flexibility
- IFS and SWITCH making it easier to construct IF statements
- The new CONCAT, and TEXTJOIN text functions
If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this webinar extremely useful.
Click to access more webinars on Excel CPE Courses | SHRM - HRCI Courses
Learning Objectives
- To familiarize with the new dynamic arrays feature in Microsoft Excel means
- To discuss how the new RANDARRAY function works
- To discuss how the new UNIQUE function works
- To discuss how the new SEQUENCE function works
- To discuss how the new SORT and SORTBY functions work
- To discuss how the new FILTER function works
- To discuss how the new XLOOKUP function can replace VLOOKUP
- To discuss how the new SWITCH function works
- To discuss how the new TEXTJOIN function can replace CONCATENATE and CONCAT
Recommended For
- This online CPE webinar is recommended for CPAS and other professionals who would like to upgrade their excel knowledge and skills
Who Should Attend?
- Accountant
- Accounting Firm
- Accounting Managers
- Accounting Practice Owners
- Certified Public Accountant (CPA)
- Cloud Accountants
- CPA - Large Firm
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial Accountant
- Entrepreneurial CPA
- Forensic Accountant
- Young CPA