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 SHOULD YOU 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.
AREA 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
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
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.
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.
- 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
- 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
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.
