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.
Speaker Profile
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.
Upcoming Webinars
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…