Pro Level Excel Productivity

Excel has evolved significantly and so have the expectations placed on the professionals who use it.

This 1-day Masterclass cuts through the noise to focus on the capabilities that define competent, contemporary Excel use: the tools and techniques that are now standard practice in high-performing teams.

Whether you're catching up on features you've not had time to explore or looking to close the gaps in your current skill set, this course equips you with a solid, practical foundation for the way Excel is used today.

‍

What you'll learn?

• Understand how Dynamic Arrays have fundamentally changed the way formulas work and why this matters for every spreadsheet you build
• Replace outdated functions like VLOOKUP with modern alternatives such as XLOOKUP, and understand the reasoning behind the shift
• Use Power Query to consolidate, clean, and transform data reliably, reducing manual effort and the risk of errors
• Get up to speed with Pivot Tables and explore Power Pivot for handling more complex, data-intensive analysis
• Build confidence working with the Excel features now expected in professional and commercial environments

‍

This class will be delivered by Wyn Hopkins in central London on 21 May 2026.

This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.