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.