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

Published
Categorised as Excel, Humour

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

Published
Categorised as Excel, Humour