A year of introducing people to Power Query

An image of a woman in a training room pointing at a screen.

It’s been a year since I started introducing people to Power Query through my standalone Introduction to Power Query course.

I attended the Intro to Power Query course and cannot recommend it highly enough. Game changer! 

Before this point, my business model had been solely focussed on providing bespoke Excel training to teams.

Sometimes this would include some Power Query content, and over time I had developed quite a bit of material for Power Query training. My Power Query training is always really popular with people who use Excel a lot. They just don’t often know it exists.

It occurred to me that my training model might not suit some people who would really benefit from PQ training. For example, if they are the sole finance person in their organisation. Or if they work as a consultant.

And so this time last year, I decided to trial a few sessions where I asked people to register an interest. I then organised these people into groups of 3-4, so that I could deliver a classroom-like training session.

I wasn’t sure what to expect, but there was quite a lot of initial take up. And I was delighted that people who did go on the course often recommended it to others. My feedback forms for the courses have been incredibly positive.

We spent an intense four hours learning all about PQ – with Jess providing sample data for us to use so that we could not just watch/listen – but really get ‘hands on’ with the tool – and learning much faster as a result.

Those who I’ve trained appreciate the hands-on nature of the course. And that the examples come from my practical experience. Delegates can follow along and there’s plenty of time to ask questions or go over things. We often have good conversations too, where delegates share ideas for future uses.

The course was brilliant – incredibly useful and perfectly paced. There were many penny drop moments where we realised something was going to save us so much time…..
Highly recommend to FDs/FCs, finance teams and anyone that plays around in excel.

I love introducing people to Power Query. It’s fantastic to see them realise how much time they can save by using it, and how easy it is to get fast results. I would love to do more of this in 2026.

You can read more here about why Power Query is so useful for Excel users and you can contact me if you’d like to arrange some Power Query training for you or your team.

Power Query uses – small charity edition

Screenshot of the Get Data Launch menu, provided for decorative purposes
Power Query (Get Data) Launch menu

People sometimes ask: “Can you give us an example of Power Query uses”?

(In fact, they often ask, “Can you give us an example of Power Query use cases” but I hate that phrase with a passion and refuse to use case it.)

So here are some very recent examples of Power query uses from a part-time FD role that I’m doing at the moment. It’s for a small but not tiny charity with lots of systems that don’t talk to each other.

Continue reading “Power Query uses – small charity edition”

Power Query without using code

You can get a very long way in Power Query without using code.

Power Query is a tremendously useful tool for cleaning, processing and shaping your data. You can use it to create repeatable processes and save hours of time.

It comes with a neat User Interface (UI), which gives you hundreds of buttons to click to transform your data. Need to remove junk header rows, extract account codes, calculate figures net of VAT? There are buttons for all of those things.

However, if you get stuck and search for help with Power Query, you’ll almost certainly find the explanation given in M code, which is the code behind Power Query. (Every time you click a button, you’re generating code.)

Image shows a screenshot from Power Query showing the Advanced Editor. This shows the code that makes up the query.
Advanced Editor in the View Ribbon in Power Query shows you the code you have generated
Continue reading “Power Query without using code”

“The key didn’t match any rows in the table” error in Power Query

“The key didn’t match any rows in the table” is one of the most common errors in Power Query.

The way it’s always explained is that it is caused when the original data changes format or name, or has been deleted.

However, there is a third, related option, which I’m writing about here because it stumped me for a while.

Continue reading ““The key didn’t match any rows in the table” error in Power Query”

New standalone power query course

I’m pleased to announce that in 2025 I’m now offering a standalone Power Query course that individuals can sign up to.

Up to this point, I’ve mostly created and delivered bespoke Excel training courses for teams. And sometimes I cover a brief introduction to Power Query within these courses.

This is because I know from experience that Power Query is an enormous time saver in a range of roles. If you find yourself doing repetitive processes in Excel (copying, pasting, updating formulas etc), you will benefit from some Power Query training.

However, I know that lots of people who would benefit the most from Power Query might not work in a team. Perhaps you are a consultant, or you’re the only finance or data person in an organisation.

You might even have tried to learn Power Query yourself but got stuck. Or perhaps you just prefer in person training.

Continue reading “New standalone power query course”