50+ new Excel features so far this decade

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.

• Keep up with Excel's regular release of new features
• Use Excel's latest capabilities across different types of work
• Explain why some classic features should give way to newer ones
• Replace VLOOKUP and INDEX MATCH with XLOOKUP
• Choose current tools that give more streamlined solutions with fewer errors
• Increase automation with up-to-date features

• 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

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.

This is best applicable to anyone using Excel for more than 30 minutes per day at work. Although any office worker could benefit, those who work in finance or analytics would probably benefit the most.

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.