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.
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