Happy New Year!
It’s the first of January 2022, so let me start by wishing you all a Happy New Year! Given how the past 1¾ years have panned out due to the COVID-19 pandemic, here’s hoping 2022 sees the gradual return of…
Why I Turn Off Outlook’s Focused Inbox
Focused Inbox is an Outlook feature that splits your inbox into two tabs — Focused and Other. The former houses your most important emails, whilst the latter holds the rest. I should caveat the above though by saying that’s what’s…
How to Create an Animated Christmas Tree in Excel 🎄
Christmas Day is here, so what better way to celebrate the big day than creating something Chrimbo-themed (in Excel, of course). I am going to show you how to create a pixel art Christmas tree with flashing lights that switch…
How Do Excel File Types Perform?
It’s probably not something you give much thought about, but awareness of the different Excel file types is important, so you can avoid limitations and data loss. Before Excel 2007, the default file format was XLS (.xls); this was then…
How Fast is Fast Data Load in Power Query?
In my previous article, Analysing 10 Million Rows in Excel, I showed you how to load a dataset into Power Query consisting of 10 million rows. In truth, it can handle a lot more than that, but I just wanted…
Forcing a New Excel Instance
When a resource-intensive task is processing, such as a complex formula, macro or query, it can cause Excel to become unresponsive. This is particularly annoying if you have multiple workbooks open, as you are forced to wait because you cannot…
