Andrew Moss
Technical Writer & Excel Aficionado
Wouldn’t it be great if the HYPERLINK function was 𝘧𝘶𝘭𝘭𝘺 compatible with dynamic arrays? Here’s the function’s syntax: HYPERLINK(link_location, [friendly_name]) I have a table called tblWebsites featuring three websites, each…
Apple Vision Pro won’t suffer from the ill-fated collapse that 3D TVs did. This time there’s trajectory. We know exactly where we’re headed, although emerging from the formative stages will…
In recent years, it’s become customary for multi-billion dollar corporations and conglomerates to rainbow-wash their social media accounts in support of June’s Pride Month.This trend initially started as a laudable…
Ah, it’s all Excel’s fault again, isn’t it? Austria’s Social Democratic Party ran an election over the weekend to determine its new leader. After nearly 600 members cast their votes,…
Typing equals (=) in a cell or the formula bar followed by a letter presents you with Formula AutoComplete, a dynamic drop-down that displays functions beginning with that letter. The…
So, it’s Eurovision tonight, and the UK is hosting the event for the first time since 1998, when Birmingham’s National Indoor Arena welcomed 24 nations from across Europe. On that…
Year 6 pupils in the UK (ages 10–11) took their SATs this week, statutory assessments designed to measure academic performance in preparation for secondary school. However, there was dismay amongst…
What constitutes copyright infringement on LinkedIn? That’s the question I’ve been asking myself recently, and I felt compelled to post this after seeing yet another blatant breach of copyright law…
Looks like Excel’s error dialog boxes have finally been brought into the 21st century! They now have a modern appearance and fit better with the Excel theme. It’s a minor…
At 15:00 BST today (23/04/23), an emergency alert will blare out from every phone across the UK as part of a government test. The system intends to inform the public…
Amid the pain and anguish of multi-millionaire celebrities relinquishing their blue ticks by refusing to pay the $8-per-month Twitter tax (or an eyewatering $11.92 if they’re from the UK), many…
As a rule of thumb, referencing a whole column in Excel isn’t considered good practice. It’s better to include only the cells you need in a range. And it’s even…