I built an alarm clock in Excel
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 Excel. This was an offshoot of something else I’ve been…
The Billion Rows Excel Challenge
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 Query’s Fast Data Load enabled. What’s changed since then? Well,…
I’ve just discovered a new chart, and it’s well-suited to politics
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, which can affect the interpretation of a result. If you’ve…
Clear values in a range — why the keyboard shortcut inconsistency?
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 for Windows, it’s a different story. Pressing Backspace only clears…
Absolute table column references need a syntax update
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 months ago, I talked about how it would be good…
Giles Male and Harry Matthews talk Excel with Jeremy Vine
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 Financial Controller at the Landauer Group. Both discussed their love…
End of content
End of content