Modern Excel: The New Functions That’ll Change How You Work

Mike Thomas

Date:
Dec. 4, 2025
Duration:
90 Minutes
Time:
1 PM EST | 10 AM PST | Thursday
Speaker:
Mike Thomas

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded

Overview:

Excel has changed. Have you? Over the past few years, Microsoft has added a wave of powerful new functions that simplify tasks, streamline formulas, and make your spreadsheets more dynamic than ever. If you're still relying solely on old favourites like VLOOKUP, IF, and COUNTIF, you're missing out on what's now possible.

In this session, you'll get hands-on with the latest Excel functions that are exclusive to Microsoft 365, Excel 2021, and Excel 2024. From cleaner ways to filter, sort, and extract data, to new functions that let you manipulate text, stack arrays, and even define your own custom functions, these tools are built to save time and reduce formula complexity.

If you’re ready to work faster, smarter, and with more flexibility, this session is your shortcut to the new era of Excel.


Why you should Attend:

Excel has quietly evolved but many users are still stuck in the past. If you're spending too long on tasks that could be done in seconds, or struggling to keep your formulas tidy and adaptable, it's time to catch up. This session helps you bridge the gap, learn what’s new, and start using the latest tools to transform how you work with data.


Agenda:

• UNIQUE, FILTER, SORT, SORTBY: Clean, extract, and rearrange data with ease
• SEQUENCE: Generate dynamic lists without manual input
• CHOOSECOLS & CHOOSEROWS: Select data precisely from arrays
• TEXTSPLIT, TEXTBEFORE, TEXTAFTER: Easily manipulate and extract text
• VSTACK and HSTACK: Combine ranges without formulas or copy-paste
• LET: Simplify complex formulas and improve performance
• LAMBDA: Create your own custom Excel functions (No VBA required)

Who Will Benefit:

This session is for intermediate Excel users who are confident with core functions like SUM, XLOOKUP, and COUNTIF, and want to stay current with the latest Excel capabilities. It’s ideal for professionals who use Excel regularly for reporting, analysis, or admin tasks and want to simplify their formulas and workflows.

Important: These functions are only available in Excel for Microsoft 365, Excel 2021, or Excel 2024. Please check you have an appropriate version before attending

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded


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.