Instructor
Mike Thomas
Category
Employee
Date
Oct. 7, 2025
Time
1 PM EST | 10 AM PST | Tuesday | 60 Minutes
Review
Break Free from Old Excel: How Dynamic Arrays Transform Formula Creation
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.<br><br> 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.<br><br> 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.• 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
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.
Write a Review
Customer Reviews
No reviews yet. Be the first to review!
Pricing Details
Membership Details
Become a member of our platform and you'll get a discounted ticket. All pricing has a membership rate attached to it. Check the prices.
Membership Plan