Excel - Dynamic Array Functions - A Game Changer in Formula Creation

Mike Thomas

Mike Thomas

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In a career spanning 30+ years, Mike has delivered thousands of courses and produced hundreds of written and video-based Excel tutorials.He...
Read More
Pre-recorded
60 Mins
Mike Thomas

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

To access this webinar, kindly reach out to our customer support team at support@complianceducator.com.

We also Recommend

Navigating Team Conflict: Strategies for Building Stronger Teams
Navigating Team Conflict: Strategies for Building Stronger Teams
Bob Churilla | 90 Mins
Live | Tech Soft Skills
Investigating and Resolving Sexual Harassment Claims
Investigating and Resolving Sexual Harassment Claims
Bob Churilla | 60 Mins
Pre-Recorded | Tech Soft Skills
Toxic Employees & Difficult Conversation - How To Tackle Them Both?
Toxic Employees & Difficult Conversation - How To Tackle Them Both?
CompliancEducator: Joel Garfinkle | 120 Mins
Pre-Recorded | Tech Soft Skills

View More

Let us inform you about everything important directly.