50+ new Excel features so far this decade
Learn which new Excel functions and tools from the 2020s should replace classic features like VLOOKUP and Pivot Tables, and how to keep up with monthly releases.
Overview
Excel adds new features every month, and many classic tools that experienced users rely on, such as VLOOKUP, Pivot Tables, SUMPRODUCT, LEFT/RIGHT and old-style comments, now have better replacements. This 60-minute webinar is a fast-paced tour of the most important new Excel features released in the 2020s.
You'll see dozens of new functions, including XLOOKUP, TEXTSPLIT, ARRAYTOTEXT and UNIQUE, formulas that work like Pivot Tables, and Python integration. Data entry gets searchable dropdowns, images and checkboxes in cells, and data types for geography and currencies.
The session also covers new formula auditing, navigation and clean-up tools, AI features including Copilot, and collaboration upgrades such as seeing cell by cell who edited what and when.
Why attend: Plenty of people consider themselves Excel experts because they know the classic features well, yet they miss newer tools that are faster and less error-prone. With releases arriving monthly, keeping up is hard. This session breaks the changes down for users of all levels. It is most useful for anyone who spends more than 30 minutes a day in Excel, especially in finance or analytics.
What’s covered
- New functions such as XLOOKUP, TEXTSPLIT, ARRAYTOTEXT and UNIQUE
- New analytics tools, including formulas that act like Pivot Tables and Python integration
- Data entry upgrades: searchable dropdowns, images in cells, checkboxes and built-in exchange rates
- Collaboration tools for simultaneous editing in Excel desktop, plus accessibility improvements
- AI features, including Copilot, auto-analysis and formula writing
- New tools for formula auditing, navigation, shortcuts and data clean-up
Who should attend
What you get
About the speaker
David Benaim is considered by Microsoft to be in the top 100 or so Excel users worldwide by holding the Microsoft MVP award, he has a YouTube channel with tech tutorials with over 18,000 subscribers under his name David benaim and does 50+ webinars/presentations per year on Excel/public speaking.
David keeps up to date with new Excel features so much that he contributes to every official Microsoft Excel monthly blog post and he also runs Xlconsulting where he assists with process automation and analytics via Excel.
Staci Warne · 60 min
Cathy Horwitz · 180 min
Craig Brody · 60 min
Ritu Arora · 60 min