CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS

All New and Current customers who purchase the Premium, Plus, or Core (Total Value Package) 2021 Federal Tax Update or the 2021 Federal and California Update will get the Tax Advisory Complement Bundle for free.

NOTE:

  • New Federal Tax Update customers will get an immediate email with a coupon code for the free course once their Tax Update purchase is complete.
  • Current Customers that purchased the Premium, Plus, or Core (Total Value Package) 2021 Federal Tax Update will get an email with a coupon code to get the Tax Advisory Complement Bundle for free.

Dynamic Array Formulas and Other New Functions

Icon_Self-Study
Self-Study
Icon_Level
Overview
Credits
CPE Credits
1 Credits: Computer Software & Applications

Course Description

This course overviews some new features and functions that Microsoft offers in Excel 2019 and/or Microsoft 365. The eBook has an accompanying workbook that you can work through along with an answer sheet. 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().

Please make sure that you have the proper Excel version or some or all of these functions will not be available to you. If you are not sure, go to Excel and try typing in an equal sign and then one of the new functions listed here. If the function does not start to display then you probably do not have access to it. Even if you do not have access to the new functions the course is worthwhile as you can use it to determine if you should upgrade to a newer Excel version.

Learning Objectives

Upon successful completion of this course, participants will be able to:

• Define an array
• Recognize how a dynamic array works
• Recognize new Excel functions and how to use them

Course Specifics

Course ID
2214705
Original Release Date
May 14, 2021
Prerequisites

You need Excel 2019 and/or Office365 to use these functions. Click on Account in Excel and it will show you what version you have. Please read last paragraph of course description.

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Patricia McCarthy Headshot
Patricia McCarthy, MBA

Patricia McCarthy, MBA, is a partner at CFO Resources LLC, a company focused on training and courseware for CPAs. Her focus is on Microsoft products, particularly Excel, and how to use these programs effectively in business. She’s also certified as an MOS expert in Excel. Patricia has been in software training for over 20 years, and her client list includes the Indiana CPA Society, which awarded her its Outstanding Discussion Leader award. She has been a contributor to the Journal of Accountancy and has published articles in several CPA society magazines, including societies in Indiana, Missouri, Texas, and Arizona. Patricia is a …

Patricia McCarthy, MBA Read More »

Dynamic Array Formulas and Other New Functions

Expert Instructors
Format
CPE CREDITS
1 Credits: Computer Software & Applications

$29.00$49.00

Clear
Icon_Self-Study
Self-Study
Icon_Level
Overview
Credits
CPE Credits
1 Credits: Computer Software & Applications

Course Description

This course overviews some new features and functions that Microsoft offers in Excel 2019 and/or Microsoft 365. The eBook has an accompanying workbook that you can work through along with an answer sheet. 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().

Please make sure that you have the proper Excel version or some or all of these functions will not be available to you. If you are not sure, go to Excel and try typing in an equal sign and then one of the new functions listed here. If the function does not start to display then you probably do not have access to it. Even if you do not have access to the new functions the course is worthwhile as you can use it to determine if you should upgrade to a newer Excel version.

Learning Objectives

Upon successful completion of this course, participants will be able to:

• Define an array
• Recognize how a dynamic array works
• Recognize new Excel functions and how to use them

Course Specifics

Course ID
2214705
Original Release Date
May 14, 2021
Prerequisites

You need Excel 2019 and/or Office365 to use these functions. Click on Account in Excel and it will show you what version you have. Please read last paragraph of course description.

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Patricia McCarthy Headshot
Patricia McCarthy, MBA

Patricia McCarthy, MBA, is a partner at CFO Resources LLC, a company focused on training and courseware for CPAs. Her focus is on Microsoft products, particularly Excel, and how to use these programs effectively in business. She’s also certified as an MOS expert in Excel. Patricia has been in software training for over 20 years, and her client list includes the Indiana CPA Society, which awarded her its Outstanding Discussion Leader award. She has been a contributor to the Journal of Accountancy and has published articles in several CPA society magazines, including societies in Indiana, Missouri, Texas, and Arizona. Patricia is a …

Patricia McCarthy, MBA Read More »

Dynamic Array Formulas and Other New Functions

Expert Instructors
Format
CPE CREDITS
1 Credits: Computer Software & Applications

$29.00$49.00

Clear