Break Free from Old Excel: How Dynamic Arrays Transform Formula Creation

Mike Thomas

Date:
Oct. 7, 2025
Duration:
60 Minutes
Time:
1 PM EST | 10 AM PST | Tuesday
Speaker:
Mike Thomas

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded


Refund Policy

Overview:

If you're still building formulas the old way - one cell at a time, you’re missing out on one of Excel’s most powerful modern features: dynamic arrays. These game-changing formulas allow you to write one formula and instantly fill a whole range, saving time and reducing errors.

In this session, you’ll learn what dynamic arrays are, how they differ from traditional formulas, and why they’re a smarter, cleaner way to work with data. You’ll see how functions like FILTER, UNIQUE, SORT, XLOOKUP, and SEQUENCE can simplify everything from data extraction to custom lists and lookup tasks, without resorting to clunky workarounds.

This is your chance to finally “think in arrays” and unlock a more intuitive, efficient way to build formulas in Excel. NOTE: Dynamic arrays are only available in Excel 365, 2021 and 2024


Why you should Attend:

Still dragging formulas across columns? Still using clunky workarounds? Dynamic arrays eliminate the complexity and tedium of old-school formula-building. If you're looking for a cleaner, faster, more flexible way to build reports, perform lookups, and manipulate data, this session will help you break out of the traditional formula mindset and take advantage of Excel’s modern capabilities.


Agenda:

• What dynamic arrays are and how they work
• Key differences between dynamic arrays and legacy formulas
• How to write and troubleshoot dynamic array formulas
• Using FILTER, UNIQUE, and SORT to simplify data handling
• Replacing VLOOKUP with XLOOKUP for smarter lookups
• Creating custom sequences with SEQUENCE
• Real-world examples where dynamic arrays make life easier
• Limitations and things to watch out for when using dynamic arrays

Who Will Benefit:

IMPORTANT: Requires Microsoft 365, 2021 or 2024 as dynamic arrays are not available in earlier versions.

This session is ideal for intermediate Excel users who are comfortable with formulas but haven’t yet embraced the new dynamic array approach. It’s especially relevant for analysts, admin staff, finance professionals, and anyone who works with lists, lookups, or reporting in Excel.

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded


Refund Policy

Instructor:

Mike Thomas

Speaker

Mike Thomas is a leading UK-based IT Trainer and Content Creator renowned for his expertise in Microsoft Office, particularly Excel and Power BI. Throughout his distinguished 35-year career, Mike has delivered thousands of courses and produced an extensive library of written and video tutorials, available on his blog and YouTube channel. As a Microsoft MVP and Fellow of The Learning and Performance Institute, Mike has collaborated with numerous global and UK-based companies, providing tailored training and developing innovative Microsoft Office solutions that streamline business processes. His passion for teaching, knowledge-sharing and technology makes him a sought-after speaker and trainer, continually inspiring others to harness the full potential of Microsoft Office tools.