Excel Unplugged

Tag Archives: MS Excel

Turning Product Descriptions into list of attributes with Power Query

One task data analysts often have to deal with is matching data from one table to data in another table. Let’s look at how we get our tables matched up in a ...

Importing CSV Files with Changing Start Row

In this post, we’re going to talk about importing CSV files with power query! This is a guest post written by John MacDougall, an Excel MVP from Canada. John ...

New Data Types in Excel – Game Changer

New Data Types in Excel will undoubtedly be THE talking point of the near future Excel evolution. That being said, they are also the reality in Office 365 Fast ...

Unlock Excel Conference – Australia

The Unlock Excel Conference  took place in April in three cities across Australia. I joined Excel MVP’s Liam Bastick (SumProduct LLC), Jon Peltier (Peltier ...