by John MacDougall | Dec 20, 2016 | Tips
Have you ever had to do something repetitive like make a change to a table in each of your workbooks sheets? Maybe you have a sales file with sales data for each month in a separate sheet and you need to add a column to the table in each of the sheets. You could...
by John MacDougall | Dec 19, 2016 | Tips
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...
by John MacDougall | Dec 18, 2016 | Tips
Have you ever been in a situation where you were comparing the data in different sheets in a workbook and continuously switching between them? It can be pretty tedious and time consuming. Excel has a great way to deal with this. To view multiple sheets...
by John MacDougall | Dec 17, 2016 | 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...
by John MacDougall | Dec 16, 2016 | Tips
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....