247Compliance appLinks, recordings and certificates
Open
Questions? Call +1-661-336-9555 Group training quotes Get the app
ON-DEMAND Software

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.

FormatRecorded sessionWatch any time
Length60 minutes
David Benaim Speaker David Benaim Excel trainer and consultant · XLconsulting · Microsoft MVP (Excel)
Talk to an expertAsk an expertQuestions about this topic

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

Finance professionalsAnalystsOffice workers

What you get

CertificateEmailed to each attendee after the session.
HandoutsSlides and checklists to reuse with your team.

About the speaker

David Benaim
David Benaim
Excel trainer and consultant · XLconsulting

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.

All webinars by David Benaim →
From$219On-demand · watch any time Enroll now