Andrew Moss
Excel Aficionado
Latest
When you open a file in Excel with US dates (month/day/year), things can quietly go wrong. The US is the only major country in the world that uses this format…
Earlier today, I caught up with the latest episode of Unpivot. Host Wyn Hopkins introduced a new feature called ‘Worth a follow’, and I was delighted to be Mark Proctor‘s…
Since IMPORTTEXT and IMPORTCSV were announced earlier this month, I’ve seen a few people asking the same question: What’s the point of these functions when we already have Power Query?…
Some spelling errors are easy to forgive. A missing apostrophe, a rushed typo, a stray capital letter — we’ve all been there. But contextual spelling errors are different. They’re harder…
Saw this Evri bag today and instantly spotted an apostrophe inconsistency — shortly followed by a comma splice. There are three instances of the contraction “I’m” that all use a…
✅ Final 10K test run of 2025. 45:38 is nine seconds better than what I did in September, although I’ve had my fair share of coughs and colds since then,…
Most Read
This page contains 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.
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…
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,…
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…