Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Cell Referencing

7 February 2018

Welcome to our Power Query blog. This week, I take a look at how to reference a cell in an Excel workbook from Power Query.


Power Query: Evaluating Stored Queries

31 January 2018

Previously I looked at a few ways to share queries between workbooks. This week, I take a look at a slightly different approach...


Power Query: Abridged Appending

24 January 2018

Welcome to our Power Query blog. This week, I take a look at a way to create and append new queries by starting with the Query Editor.


Power Query: It’s Good to Share (a Query)

17 January 2018

Welcome to our Power Query blog. This week, I take a look at exporting queries to other workbooks in Power Query or Get and Transform.Regular readers will know that this blog is now constructed in Excel 2016 and therefore uses ‘Get and Transform’. In most cases, it’s...


Power Query: Querying Query Options

10 January 2018

Welcome to our Power Query blog. This week, I look at the ‘Query Options’ screen and what it can do for me.


Power Query: Rapidly Renaming Columns

3 January 2018

Welcome to our Power Query blog. This week I look at renaming many columns in one step.


Power Query: Customising Custom Built Functions

27 December 2017

Welcome to our Power Query blog. This week I look at how to customise function descriptions by using M function meta-data.


Power Query: Powerless Pivot

20 December 2017

Power Query and Power Pivot work well together, however Power Query is not exclusive to Power Pivot though, as it may be used with ordinary PivotTables. There is a good reason for doing this too...


Power Query: Cleanse, Tone and Upload

13 December 2017

This week I look at combining several Power Query functions in order to standardise some incoming data...


Power Query: Pivot the Blanks

6 December 2017

The scenario is familiar, a huge Excel table comes in with lots of columns and rows, but in some cases a column or row is empty and it needs to be condensed...


Newsletter