Andrew Moss
Excel Aficionado
Latest
Walk into an Apple Store and you’ll notice something subtle about the MacBooks on display. They’re all positioned at exactly 76°. At first glance, it seems like an oddly specific…
Today, I asked Copilot to go and sit on the naughty step. I’ll tell you why… Recently, it’s become a regular thing for me to do what I call a…
20/12/2025: “I think a sub-45 [10K] is within reach in 2026.” So it proved, as I beat my 45:38 from then with a 44:45 today — a 53-second improvement. I…
Custom formatting is a great way to control how values are displayed, but formats are designed to sit on a single line, which isn’t always ideal. Take a football match…
Excel’s calculation engine just got upgraded. And it’s the biggest change since dynamic arrays came about at the back end of the last decade. Formulas can now respond to the…
Some people are very prescriptive about how things should be done. They’ll tell you there’s a ‘proper way’ — a set process you’re supposed to follow. But the reality is,…
Most Read
Here’s a collection of work I’ve created for the Global Excel Summit. To jump to an item from the Table of Contents, expand its drop-downs first.
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…
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…
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…
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…