Webinar Replays

Welcome!

Thank you for registering for the live training events.

Please find the replays below.

The sessions were:

• Session #1 – Excel Game Changes
• Session #2 – Will It Spill
• Session #3 – From Pivot To Power Pivot
• Session #4 – Insider Power Query Tips and Tricks

Enjoyed the sessions?

These sessions are a small sample of what you’ll find inside Excel Academy.

If you’d like to continue building your Excel, Power Query, Power Pivot and automation skills, Excel Academy provides structured training, live support, practical resources, and a community of like-minded professionals.

Join Excel Academy and keep learning with us.

Excel Game Changers

Over the last 10 years, there have been a lot of new features.

• Some never made it to production.
• Some nobody uses.
• Some are nice to have.
• Others completely changed the ways we work.

In this session, I’ll reveal the features I believe have had the biggest impact on productivity and explain why they’re worth your attention.

If you’ve ever wondered which Excel features are genuinely worth learning, this session is for you.

NOTE: The is no example file for this session.

Will It Spill?

Dynamic Arrays changed Excel forever.

What started with a few new functions has evolved into an entirely new way of building formulas.

In this deep dive session, you’ll learn how Dynamic Arrays work, when to use them, and how they can dramatically simplify your spreadsheets.

Whether you’ve only scratched the surface or use Dynamic Arrays daily, you’ll leave with new ideas and techniques.

From Pivot to Power Pivot

PivotTables have been helping Excel users analyze data for decades, but they are limited.

When your data grows larger or you need something more flexible, Power Pivot comes to the rescue and takes your analysis to another level.

If you’ve heard people talk about Power Pivot but never knew where to start, this session is for you.

Insider Power Query Tips & Tricks

Power Query has become one of the most important additions to Excel.

It’s the tool that allows you to automate repetitive data preparation tasks and build refreshable reporting processes.

In this practical session, I’ll share some of my favorite Power Query techniques, and lessons learned from ten years of helping Excel users improve their workflows.

Whether you’re a beginner or experienced Power Query user, you’ll pick up plenty of ideas to make your work easier.