![](https://andrewmoss.me/wp-content/uploads/2024/06/andrew-moss-06.png)
Andrew Moss
Excel Aficionado
Hurray! The new Premier League season got underway on Friday. In the sole evening match, Manchester United beat Fulham thanks to summer signing Joshua Zirkzee’s 87th-minute winner. Three points, a…
Apparently, I’ve been pronouncing the ‘365’ in Microsoft 365 incorrectly.Ever since the advent of its predecessor, Office 365, I’ve always said ‘three six five’ without thinking.And yet, hearing one Excelfluencer…
Alarm clocks — who uses one anymore? I’m talking about the dedicated kind — not the virtual one on your smartphone. Last night, I built a quick alarm clock in…
Here’s something I thought was rather clever from Innocent Drinks. It fooled me when I first saw ‘Image not found’, as I thought it was a genuine error. Then I…
I have some celebratory news blended in with a rant… Today, I phoned up the Student Loans Company and paid off my entire student loan debt — the remaining balance…
Back in December 2021, How Fast is Fast Data Load in Power Query? demonstrated how long it took to load varying-sized datasets into the Data Model with and without Power…
Here’s a chart Excel needs: a cartogram. It’s a type of map that represents geographic regions with shapes sized according to a specific data variable rather than their land area,…
In Excel for Mac, when you select a range of values and then press Backspace, they are all cleared. The same behaviour occurs in Excel for Web. However, in Excel…
Structured references are often preferred to cell references because they add a dose of readability and memorability. Let’s be honest, you’d rather see tblEmployees[Name] than A2:A11, wouldn’t you? A few…
Last Thursday (30/05/2024), Jeremy Vine was joined by two guests on his BBC Radio 2 afternoon show. They were Giles Male, co-founder of Full Stack Modeller, and Harry Matthews, Group…
Get Data and Get data are two prominent UI buttons found on Excel’s Data tab and Power BI’s Home tab, respectively. Both have the same icon, and both serve the…
Ever heard of ‘marching ants’?Although it’s not the most commonly used term in the Excel lexicon, it is more prevalent in graphic design.In software like Photoshop, marching ants refers to…