Power Query: How to load only fresh rows and create an Excel history table

23/04/2018

I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 …

Next steps in Excel ETL – learning M

18/03/2018

Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create …

18/03/2018

I have previous blogged on how to unpivot data using Excel and Excel 365 (was Excel 2016) just keeps getting …

03/04/2017

Normal people, by which I mean those who don’t process data all day will often create data that is present …

03/04/2017

In 2013 I published a technique to create the union of two tables in Excel. This post is still very …

16/05/2016

Excel 2016 has a lot of new features to wow the power user including support for cascading IF statements and …

23/11/2015

I help run an underwater hockey club. To smooth administration I wanted to create an mobile application to record attendance …

08/01/2015

I am introducing some students to Excel and have produced this brief style guide to producing more readable code which …

25/09/2014

If you analyse data in Excel you know that Pivot Tables are magic and that they are generated from simple …