EXCEL IS 40! 🥳
Happy birthday to Excel! Check out my video reflecting on its beginnings and the path that led to where it is today. Watch the video Transcript Microsoft Excel is 40! That’s right. It was on 30th September 1985 when the…
Remove Excel worksheet and workbook protection
If you think Excel’s worksheet and workbook protection will truly keep your files secure — think again. Both are surprisingly easy to bypass. That’s bad news if you’re relying on them for security, but good news if you’ve ever forgotten…
Convert a flat list to an itemised list in Excel
Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you’ll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it…
Building an Excel football league table — 5 years on
Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well, what better place to start than the very thing that…
Extract URLs from hyperlinks in Excel
If you copy a set of hyperlinks with friendly text from a website and paste them into Excel, each URL is embedded as part of the cell’s metadata. This poses a challenge if you want to extract them, as there’s…
How the FORMULATEXT function could be improved in Excel
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…
