This week I look at bringing in two tables of data and summarising some of that data. At the same time..

It’s time to move on...

Welcome to our Power Query blog. This week I look at the options available to organise queries within a workbook.

Welcome to our Power Query blog. This week let's look at how to convert names into an alternative format.

Sometimes, the tasks I have to do are less than thrilling...

I like finding ways to save time. That’s why I get someone else to write this. So when I come across a method to create data quickly, then that makes me very happy. This particular method of creating data is ideal for those scenarios where I don’t want Excel users to change any values...

The new feature ‘Column from Examples’ essentially pulls together a number of Power Query functions into one place, so it’s very user friendly.

Whilst much of the data I deal with comes from workbooks and databases, it can be useful to pull in data from other sources. There are a number of sites traditionally associated with business, but social media sites like Facebook are becoming more accepted business channels due to their high usage and range of users...

Last week, I looked at how to access and test the built-in Power Query functions. There are occasions, however, when I am repeatedly using the same logic, and I want to store it in a custom function of my own. Let’s take a look....

My blog comes of age this week as it hits the big 4-0! I am feeling quite empowered, so that gives me an idea! In M-Powered, I described how to get to a description of the functions that can be used in M code to manipulate data by accessing the Microsoft help pages. There is however another way to get to the functions. Let me show you....