20/12/2025: “I think a sub-45 [10K] is within reach in 2026.” So it proved, as I beat my 45:38 from then with a 44:45 today — a 53-second improvement. I haven’t budged from my weekly routine: one 10K at slow-medium…
Custom formatting is a great way to control how values are displayed, but formats are designed to sit on a single line, which isn’t always ideal. Take a football match summary, for example. You might want to display the day,…
Excel’s calculation engine just got upgraded. And it’s the biggest change since dynamic arrays came about at the back end of the last decade. Formulas can now respond to the active cell, something that previously required VBA. As a result,…
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….
Focus Cell is a great feature that has only been around for 1½ years, despite many people requesting it for years before. With a single click of the button on the View tab, Excel highlights the active row and column,…
