Excel-related articles.
Today, it suddenly dawned on me that Office Scripts has been around for five years. After being announced at the Microsoft Ignite Conference in November 2019, it was reasonable to assume this was going to be the natural replacement for…
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…
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,…
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…
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…
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…
