Andrew Moss
Excel Aficionado
If you’re a technophobe, you probably want to avoid coding at all costs. Thankfully, Microsoft Power Automate empowers you to create powerful workflows without a jot of code. No-code (and…
A table is defined as “a set of facts or figures systematically displayed, especially in columns.” They structure data in a way that ensures fast and efficient readability. In Excel,…
Introduction I am going to show you the different ways you can build a football league table in Excel. Some of the methods are old school, but others utilise Excel’s…
Star rating systems are commonly used to rank things like films, TV shows, hotels, and shopping products. Typically, they are done on a scale of 1–5 (or 0–5), although you…
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…
Maybe you’re a football fan — maybe you’re not. Besides, the new Premier League season started last weekend. Amidst the empty stadiums and general doom and gloom, you’d be forgiven for not…
Microsoft’s ribbon interface has been with us since the launch of Office 2007. Although met with mixed reaction, over time many acknowledged it was a viable replacement for the ageing…
Want to get ahead of the curve in your favourite Office app? Join the Office Insider Program to test and explore new features in Office apps before they are released…
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…
A few months ago I encountered a scenario I hadn’t faced before. I was dealing with a large number of financial transactions from multiple bank accounts that were being housed…
Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup. I’ve built the virtual equivalent in Excel. Of course, it…
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…