Excel today is not the Excel of yesterday and Dynamic Array Functions are one of the relatively new must-know game-changing features. 

Dynamic Array Functions will not only simplify the way that you build formulas, but they will also simplify the way you build and work with Excel files. With Dynamic Arrays, you can extract unique values, sort and filter data, lookup multiple values, and build dynamic lists that instantly update when new data is added to the source.

Webinar Objectives

• Understand what Dynamic Array Functions are
• Understand how to use Dynamic Array Functions and why they are useful

Webinar Highlights

• Understand the definition of an Array
• Learn how to create Dynamic Array Functions
• Learn how to use the UNIQUE Function
• Learn how to use the FILTER Function
• Learn how to use the SEQUENCE Function
• Learn how to use the SORT and SORTBY Functions
• Learn how to use the XLOOKUP Function

Who Should Attend

It is aimed at users who want to learn about the Dynamic Array Functions in Excel. Dynamic Array Functions are only available to Microsoft 365 subscribers (and Excel 2021 users).