CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

New Excel Functions

  • CFE
  • CPA (US)
New Excel Functions

1 Credit

$10

Subject Area

Computer Software and Applications

Upcoming Webinars

Yellow Book Boot Camp - NFP and Governmental Accounting & Auditing Update

(17)

Oct 22, 2021 | 09:00 AM EDT View Details

Partnership Preparation, Basis Calculations & Distributions–Form 1065 Schedule K & K-1 Analysis

(92)

Oct 22, 2021 | 09:00 AM EDT View Details

Federal Tax Update – Individual & Business Current Developments

(10)

Oct 22, 2021 | 09:00 AM EDT View Details

Raising More Money from Your Local Business Community

Oct 22, 2021 | 09:00 AM EDT View Details

IRS Representation Series - Conflicts of Interest

(1)

Oct 22, 2021 | 09:00 AM EDT View Details

Addressing Single Audit Quality in a COVID-19 era

(4)

Oct 22, 2021 | 09:30 AM EDT View Details

Social Media that Kills: Fundraising Pitfalls for NFP Organizations

(48)

Oct 22, 2021 | 09:30 AM EDT View Details

Zero Based Budgeting

Oct 22, 2021 | 10:00 AM EDT View Details

Comprehensive Tax Strategies & Insights On Real Estate

(26)

Oct 22, 2021 | 10:00 AM EDT View Details

Internal Controls for Businesses

(41)

Oct 22, 2021 | 10:00 AM EDT View Details

Best Tax Return Workshop On S Corporation (1120S) - Latest

(33)

Oct 22, 2021 | 10:00 AM EDT View Details

Retirement Plan Governance Best Practices: Essential Documents

(118)

Oct 22, 2021 | 10:00 AM EDT View Details

Excel Accountant: Interactive Spreadsheets

(6)

Oct 22, 2021 | 10:00 AM EDT View Details

Legal and Financial Tax Planning Strategies

(227)

Oct 22, 2021 | 10:00 AM EDT View Details

LeaseCrunch: Lease Accounting Software Rollout Tips

(139)

Oct 22, 2021 | 11:00 AM EDT View Details

Course Description

In the second half of 2020, Microsoft released a significant upgrade to the most used spreadsheet programme 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.

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

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Bookkeepers & Accountants & Tax Preparers
  • Certified Public Accountant
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • Young CPA

Testimonial

3.3

(7)
14%
43%
14%
14%
14%

TW

I found this webinar to be of great value. Thank you.