Excel gets a date picker
Yippee! 🥳 Excel finally has a date picker 📅 — imitating another Google Sheets feature — except going above and beyond to ensure it’s a cut above. At the moment, it’s only available to Excel for web users but will…
‘Hallucinate’ crowned Word of the Year 2023
Cambridge Dictionary (CD) has named ‘hallucinate’ as Word of the Year. No, not to celebrate a surge in psychoactive substance usage, which causes users to see, hear, feel, or smell something that doesn’t actually exist. But because 2023 will go…
Summing Columns in Excel
The announcement of eta lambda support has further simplified the summing of columns. When the BYCOL function was released, I was impressed that we finally had a solution that didn’t involve referencing every column individually. It’s gone to the next…
Excel has new and improved web scraping capabilities
Web scraping in Excel has just got better. If you’ve ever used the Get Data From Web tool, you’ll know how limited it was. After pasting a URL and clicking OK, you’d be presented with the Navigator window containing a…
Manchester United’s lack of possession vs Manchester City
On Sky Sports yesterday, Jamie Carragher was absolutely right when he said Manchester United play “underdog football” after our 3–0 drubbing to Manchester City. I know that possession isn’t everything, but every time we play City, it’s always us on the back…
How to convert UTC to UK Time
Enjoyed your extra hour in bed today? 🛌 😴 That’s right. Across Europe, clocks went back 60 minutes at 01:00 UTC (Coordinated Universal Time). In the UK, we moved into Greenwich Mean Time (GMT) a second after 01:59:59 BST (British…
