Google finished rolling out its helpful content update last month, which was supposed to provide us with better search results. Well, it seems like it still has some way to go… I search for: “how long does it take to…
Running counts are useful for keeping track of how many times a value has occurred up to a certain point. There are multiple ways of doing this, so let’s look at some traditional and modern methods. Example On page 1,…
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
Interestingly, the words ‘Power Query’ feature in the Excel for Mac ribbon (albeit in brackets) but don’t in the Windows version. That’s despite the former having a non-existent editor (for now). In Excel 2010 and Excel 2013, Power Query was…
37 years ago to the day (30th September 1985), the inaugural Microsoft Excel 1.0 was released. What’s perhaps surprising is that Macintosh users were the first to experience it. Minus the early years, Excel for Mac has always had an…
The current Excel logo was first rolled out in April 2019, which means it’s about the same age as the average lifespan across the series (3.6 years). It arguably represents the best phase of Excel’s illustrious history, where the pace…
