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 …
Category Archives: Excel
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 …
Humour: Excel and big data
As consultants our job is to help the user and unlike the poor second line support person we usually have …
How to create a union of n tables in Excel
In response to my post showing how to union two tables in Excel a reader writes, I have seen your …
Create the Union of two tables in Excel
— 2017-04-03 I have new post for Excel 2016 (2013) — It is very common in Excel to need to …
