David Benaim does it successfully on YouTube and at the Edinburgh Festival. Matt Parker does it as a very popular stand-up comedian and bestselling author. I’ve tried to be funny about Excel a couple of times on this blog. Then Microsoft has updated Excel to actually implement my satirical suggestions. It’s hard to be funny… Continue reading It’s hard to make spreadsheets funny
Category: Excel
Broken links in Excel: down the rabbit hole
When somebody sends a spreadsheet that they have edited from their desktop, all too often it includes links to other spreadsheets in their personal area. Excel tries to get the data from those links, but inevitably fails. For some link types – particularly those connecting to a proper external data source, such as an online… Continue reading Broken links in Excel: down the rabbit hole
Four functions I’d like to see in the next version of Excel
Originally published on my company internal blog. Excel provides a bewildering array of built-in functions for all manner of scientific and statistical analysis. It even lets users write their own functions. But no matter how flexible a tool is, users will inevitably want immediate, specific functionality that meets their needs now. Here are some Excel functions… Continue reading Four functions I’d like to see in the next version of Excel
Six baffling Excel functions
Originally published on my company internal blog. BAHTTEXT What it does: The baht is the currency of Thailand. BAHTTEXT(123) returns the words “One hundred and twenty-three baht”, but in Thai. Why it’s baffling: Because this is the only function in Excel that does anything like this, and it’s only available for the baht. There’s no… Continue reading Six baffling Excel functions
