Excel-related articles.
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…
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…
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…
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,…
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%.👎…
We’re only 3¾ years into this decade, yet we’ve already seen game-changer after game-changer come to Excel. Next on the conveyor belt is Copilot, which will be made generally available according to the following schedule: When Microsoft first announced Copilot…
