Excel-related articles.
My new Excel Christmas long-sleeved T-shirt arrived today, and I couldn’t wait to try it on! Here it is… If you’re an Excel longtimer, you will have inevitably faced the #REF! error from time to time. What is so significant…
I’m not sure how proficient Mr Trump is at Excel, but I just discovered something bound to pique his interest… 🇺🇸🇲🇽 In the ribbon border dropdown on the Home tab (also found in the right-click formatting menu), selecting ‘Thick Bottom…
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…
End of content
End of content
