Andrew Moss
Excel Aficionado
Latest
I wonder where Excel will be in 4.1 years, let alone 41. The last couple of years have been dominated by Copilot updates, so it’s easy to see the direction…
You’ve all heard of the 9 till 5. You might have heard of the 5 till 9. But what about the 9 till 9? I’m talking about 9pm till 9am…
Today, I went to the Apple Store in Covent Garden to get my iPhone 15 Pro Max battery replaced. I refuse to pay an arm and a leg for a…
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…
On Sunday, I visited a Premier League training ground for the first time. I’ve been to plenty of football stadiums over the years, but this was something different. The visit…
When people think of Microsoft’s Office Assistants, one character usually springs to mind: Clippit — more commonly known as ‘Clippy’. The anthropomorphic paperclip became one of the most recognisable characters…
Most Read
Here’s a collection of work I’ve created for the Global Excel Summit from 2022 to 2026. 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…
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,…
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…
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…
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…