Instructor
Mike Thomas
Category
MS Excel
Date
Sept. 10, 2026
Time
1 PM EST | 10 AM PST | Thursday | 90 Minutes
Review
Excel 365 Functions: Beyond VLOOKUP and SUMIF
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.
SHRM Certified
HRtrainup is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.00] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org.
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
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