
Maximising your Excel Productivity
Unlock time-saving techniques and powerful features that will transform the way you use Excel.
This 1-day masterclass reveals hidden shortcuts and modern tools that experts rely on to work faster, smarter, and with greater confidence. From Dynamic Arrays to Power Query and Pivot Tables, you’ll leave with practical skills that will significantly boost your productivity.
What you'll learn?
- Discover the latest Excel features that experts use to maximise efficiency
- Harness the power of Dynamic Arrays to simplify and supercharge formulas
- Understand why XLOOKUP has replaced VLOOKUP and how to use it effectively
- Master Power Query to automate and streamline repetitive tasks
- Refresh your Pivot Table knowledge and explore the advanced capabilities of Power Pivot
- Apply hidden shortcuts and time-saving techniques to optimise your workflow
This class will be delivered by Wyn Hopkins in central London on 21 May 2025.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
What's included
Who is it for
This masterclass is ideal for professionals who already have a working knowledge of Excel and want to leap ahead in productivity by adopting newer features and smarter workflows. Typical attendees include:
- Business and data analysts working with reports and dashboards
- Finance and accounting professionals (FP&A, auditors, controllers)
- Project managers and operations specialists tracking KPIs
- Experienced Excel users ready to replace old habits with faster, smarter tools
Download Course Brochure
About trainer

Wyn Hopkins
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
What people think of
Wyn Hopkins

Once you see the magic, you cannot unsee it.
JUST DO IT! Any finance person who works with data must take this course.

This course is really helpful!
I would highly recommend it!
Course contents
Wyn Hopkins
Training requirements
Users should already be comfortable with day-to-day Excel use.
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
