February 10, 2023


Webinar


2 CPE

K2’S The Power Of Array Formulas In Excel

February 10, 2023
Webinar
2 CPE

K2’S The Power Of Array Formulas In Excel

  • View Bio

    Instructor

    Tommy
    Stephens

    View Bio

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