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,…
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…
