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…
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…
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…
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…
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…
Big data is a term used since the early 1990s to describe “huge, overwhelming, and uncontrollable amounts of information”. The rapid rise of the internet has meant the volume of data has increased exponentially over the past two decades. There…
