Excel-related articles.
If you’re presenting an Excel formula for auditing, troubleshooting, or educational purposes, the FORMULATEXT function is very handy. It lets you display the formula from a cell (or range) as text, while updating automatically whenever there’s a change. Needless to…
I was only trying to give my rabbit a Hollywood smile using the Format Painter tool, but that blimmin’ Copilot button got in the way again! Thankfully, it is possible to switch it off without fully turning off Copilot. Go…
It’s funny how your memory can play tricks on you. I was convinced the lectern at last year’s Global Excel Summit was made of some shade of mahogany wood — more akin to the traditional ones I grew up seeing…
Wow! What can I say? It’s crazy to think a week has already flown by since the eve of the Global Excel Summit 2025. Reading all the rave reviews flooding in since has been great. Such is the eagerness of…
For the second year running, I’m delighted to have participated in John Michaloudis‘ The Best Microsoft Excel Tips & Tricks in 2024. This annual tradition is a roundup of tips and tricks from Microsoft MVPs and experts that will save…
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…
