Excel-related articles.
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,…
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…
If you ever get disoriented in the worksheet grid, Focus Cell makes it much easier to stay on track. It highlights the active cell’s row and column so you can edit and input with greater assurance you’re in the right…
