How To Get A List Of Unique Items From Your Data

How To Get A List Of Unique Items From Your Data

I come across this situation a lot, I have a big set of data and I want to quickly see what are the unique values in a certain column. Here are three quick and easy ways to get a list of unique values in your data. Each takes about 30 seconds or less to perform, so...
How To Reference A Named Range In Power Query

How To Reference A Named Range In Power Query

In a previous post we explored how to import all the files in a folder using power query. But what happens when we get a new batch of data files and we need to import them for analysis? In this post we are going to find out how to reference the folder path using a...
How To Make Your Data Visually Appealing

How To Make Your Data Visually Appealing

So you’ve just finished compiling the sales figures for the big boss man and you’re ready to send it off to him, but wait there’s something missing! It’s so plain and boring. It needs some style and some visualization of what the data means....