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…
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…
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…
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…
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…
Staring at a worksheet with a plethora of errors is not sightly, but it can be your saving grace for diagnosing formula problems. Over a dozen error types exist, and chances are you will have seen most of them at…
Spreadsheet Day was celebrated this month—an occasion to mark 42 years of the tool that has enhanced the business world and our personal lives so dearly. Their use has spanned across many industries and professions, including financial, scientific, medical, and…
End of content
End of content