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…
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…
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…
Say goodbye to dialog boxes — say hello to panes
One stealthy arrival to Excel recently is a Workbook Links button in the Data tab to replace the old Edit Links. Clicking it now unveils a pane to manage links to external data sources, such as other Excel workbooks. Previously,…
Excel gets Sheets-esque checkboxes
Checkboxes have never been Excel’s biggest strength because: 👎 They cannot sit in cells.👎 They cannot be resized.👎 They cannot be coloured.👎 They are only compatible with desktop versions.👎 They are visibly pixelated even after zooming in a tad over 100%.👎…
End of content
End of content