Following on from my post yesterday, I wanted to give a small update. I’m now halfway through the Excel certification that contributions to the BI Reporting badge and I am learning some useful new features. As I mentioned before, I’ve been using PowerPivot for around 4 months, and while I’m aware there is still much to Read More
Excel Skills
Getting Certified in BI Reporting
From looking into the learning around Power BI, it seems like the difficult part is combining data and adding calculated measures. For the last 9 months, I’ve been using Power Query and for the last 4 months I’ve been using Power Pivot. Both of these are the backend in Power BI that drive all the data Read More
Gitgud At Excel, Fast
Anyone who has read my blog for any length of time should know that I am a whiz at Excel. I have graduated from the Excel guy to analyst now, but for a good few years I was the Excel guy and becoming an analyst has only expanded my Excel skills further. So one thing that Read More
How To Beat An Excel Expert At Excel
So I’ve been using Excel for many years and gotten really good at it. So good in fact that when I challenged myself to complete all the exams for a three month Excel course over a weekend, I did it. Now I’m not trying to brag (much), I’m mainly trying to get the point across that Read More
Quick Update On Fuzzy Matching In Excel
A little while ago I wrote about the benefits of fuzzy matching and the add-on for Excel that Microsoft provides. Well since then Microsoft have been super helpful and put the fuzzy matching function from Power BI into Excel’s Power Query too! Happy fuzzing!
Stop Overusing Power Query!
This is mainly a post to remind myself to stop relying so heavily on using Power Query to do everything. I am almost certain that if I learned how to use Power Pivot, it would do all of the things I keep doing in Power Query much faster. Today I used Power Query to create multiple Read More
A Day Of Fuzzies
I spent almost the whole day today using the Excel Fuzzy Lookup add-in. I’m not going to describe how to use it or how it works, because there are guides out there. Instead, I’ll describe my experience. So first thing, I should have cleaned my data up more before using it. I got a lot of Read More
Let’s Get Fuzzy-cal
Dismayed is how I felt a few hours ago, when I looked at the 9000 rows of data that I would possibly have to match up manually. Each row contains words that I need to match, but not in always the same format, and certainly not identical to what I needed to match it to! I’d Read More
Linear Algebra And Excel Spreadsheets
Although I am just beginning with Linear Algebra, one thing occurred to me about matrices and vectors. I worried that in my ignorance, I was simply misunderstanding, but maybe not. I stumbled across the following quote and my little thought made sense: Linear algebra gives you mini-spreadsheets for your math equations https://betterexplained.com/articles/linear-algebra-guide/ Now THAT is something Read More
Some Quick Tips For Success With Power Query
PowerQuery is an amazing addition to Excel. It can transform entire columns of data in a couple of clicks. It can unpivot monthly trackers, instantly normalising the data. You can use it to stitch multiple csv/txt files together just by pointing it at a folder. And it can read, import and transform any sheets or tables Read More