Power Query: How to load only fresh rows and create an Excel history table
I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 …
Category Archives: Excel
Next steps in Excel ETL – learning M
Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create …
Excel ETL – import multiple CSV files
I have previous blogged on how to unpivot data using Excel and Excel 365 (was Excel 2016) just keeps getting …
Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present …
Create the Union of two tables in Excel revisited
In 2013 I published a technique to create the union of two tables in Excel. This post is still very …
New features in Excel 2016
Excel 2016 has a lot of new features to wow the power user including support for cascading IF statements and …
Microsoft Office 365 Excel is a mobile app platform
I help run an underwater hockey club. To smooth administration I wanted to create an mobile application to record attendance …
Excel CSV is not UTF-8, fix it with Notepad++
Excel CSV is ANSI encoded (the CSV specification does not define an encoding). Many web applications are UTF-8 encoded. If …
Excel coding style guide
I am introducing some students to Excel and have produced this brief style guide to producing more readable code which …
How to create a list from an crosstab table in Excel
If you analyse data in Excel you know that Pivot Tables are magic and that they are generated from simple …
