Andrew Moss
Excel Aficionado
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…
The current Excel logo was introduced in 2019, making it already half a decade old! On the Windows desktop version, you’ll see it in several places, most notably as the…
Let’s talk emojis. Just like we’re all familiar with colour televisions, we’re also familiar with these colourful glyphs. Their primary purpose is to allow us to convey emotional nuances that…
How many worksheets can a workbook support in Excel? According to the ‘Excel specifications and limits’ webpage, the total number of sheets permissible is ‘limited by available memory’. What does…
Oh, dear. We’ve been here before, haven’t we? 😫 F1 is a sport that requires a colossal amount of attention to detail. Ultimately, a team’s aim is to construct the…
Excel’s decimal buttons are a thing of mystery. Sat snugly in the centre of the Home tab, they provide a quick and convenient way to adjust the number of decimal…
At the backend of last year, I was honoured to be asked by Microsoft MVP John Michaloudis to participate in his podcast, The Best Microsoft Excel Tips & Tricks in…