Andrew Moss
Excel Aficionado
Latest
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,…
Running counts are useful for tracking how many times a value occurs consecutively. In this example, the football results in B2:B16 contain W for win, D for draw, and L…
Tech hygiene. Those are the words that accompany WHOOSH!, a brand of screen-cleaning products designed for a wide range of devices. Since the advent of touchscreen phones and tablets, smudginess…
More than ever in this heavily commercialised world, companies feel compelled to jump on special events with marketing gimmicks and flash-in-the-pan campaigns. Whether it’s limited-edition packaging, novelty products, or cheeky…
Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well,…
Most Read
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…
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…