November 28, 2022


Webinar


2 Total CPE Credits

product-artwork-1762002

K2’S The Power Of Array Formulas In Excel

  • Instructor

    Thomas Stephens

Learning Objectives

  • Identify examples of “legacy” array formulas
  • List examples of when dynamic arrays can be useful
  • Create formulas using Excel’s SORT, FILTER, UNIQUE, and SEQUENCE functions
  • Cite examples of when using Dynamic Arrays is advisable

Major Topics

  • Understanding arrays of data and how they are useful
  • Distinguishing between “legacy” array formulas and array formulas in “dynamic array-aware” versions of Excel
  • Using Excel’s new array functions, including SORT, FILTER, SEQUENCE, and UNIQUE
  • Applied examples of array formulas

CPE Credits Available

2
Total CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

None

Advanced Preparation

None

Intended Audience

Accounting and financial professionals who want to learn how to take advantage of array formulas in Excel

Provider

ACPEN

This event has ended.