Modern Excel: The New Functions That'll Change How You Work
October 22, 2025
10:00 AM PDT | 01:00 PM EDT
90 Minutes
711239
Group Attendees: Any number of participants
Recorded Version: Unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
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 should you 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.
Areas Covered in the Session:
- 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
Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes
