Some people are very prescriptive about how things should be done. They’ll tell you there’s a ‘proper way’ — a set process you’re supposed to follow. But the reality is, that so-called proper way doesn’t always hold up. Recently, I…
When you open a file in Excel with US dates (month/day/year), things can quietly go wrong. The US is the only major country in the world that uses this format as its primary standard, while the vast majority use day/month/year….
Earlier today, I caught up with the latest episode of Unpivot. Host Wyn Hopkins introduced a new feature called ‘Worth a follow’, and I was delighted to be Mark Proctor‘s choice. He said I’m one of his “favourite social media…
Since IMPORTTEXT and IMPORTCSV were announced earlier this month, I’ve seen a few people asking the same question: What’s the point of these functions when we already have Power Query? I think that question misses something important. Excel isn’t one…
Some spelling errors are easy to forgive. A missing apostrophe, a rushed typo, a stray capital letter — we’ve all been there. But contextual spelling errors are different. They’re harder to spot, more persistent, and often slip past automated checks…
Saw this Evri bag today and instantly spotted an apostrophe inconsistency — shortly followed by a comma splice. There are three instances of the contraction “I’m” that all use a single smart quote (’) as the apostrophe. However, the first…
