If you’re serious about a career in data, mastering Power Query is essential. Power Query is a tool built into Excel (and other Microsoft products) that allows you to clean and organize data from multiple sources.

I am often asked about the Excel skills required to get hired working in data.

Let’s get one thing out of the way first…

Before I get into the skills I want to anticipate obvious answers. Yes, you need to be curious and analytical, to learn the business problems before focusing on the tools.

But if you're my audience, you ALREADY know this. So what are the specific Excel skills required to get hired using Excel?

Did your blood pressure just rise reading that? We’ve all been there.

Have you ever gotten this error? I think it’s probably one of the worst Excel errors EVER.

I hate saving time.

Said no one ever.

The key is Excel automation. Today, there are so many ways to automate Excel.

But let’s start where most of us start…

With Excel Macros and VBA (Visual Basic for Applications).

I’ll show you how to use advanced Excel shortcuts to significantly improve your efficiency, especially when dealing with complex tasks or large datasets.