Tag: power query training

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.)

Continue reading “Power Query without using code”

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”