Instructor
Mike Thomas
Category
MS Excel
Date
Dec. 4, 2025
Time
1 PM EST | 10 AM PST | Thursday | 90 Minutes
Review
Modern Excel: The New Functions That’ll Change How You Work
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.<br><br> 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.<br><br> 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.• 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)
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!
Related Webinars With This Topic
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