Andrew Moss
Technical Writer & Excel Aficionado
Yesterday, Twitter announced a 10,000-character tweet limit (up from 4,000) and the ability to bold and italicise text. The catch? They’re exclusive to Twitter Blue subscribers.It got me wondering, though.…
Those familiar with Google Sheets will be aware of the helpful little box that pops up when you type a function followed by an open parenthesis. It reveals the function’s…
A couple of days ago, Microsoft announced its new AI-powered virtual assistant called Copilot. Popular apps, including Excel, Word, and PowerPoint, will all benefit from the technology in their respective…
Excel’s FILTER function sieves a set of data based on defined criteria. However, it doesn’t allow the use of wildcards for partial matches. What are the wildcard characters? * (asterisk)…
We have a new type of misinformation to look forward to! On Monday, Google announced its AI bot Bard to rival the much-talked-about ChatGPT. In a promotional GIF published on…
Have you heard of Microsoft PowerToys? Thought not. It’s a set of Windows utilities to tune and streamline your experience for greater productivity. You’ll be surprised to learn it first launched for Windows 95…
There’s a brand new keyboard shortcut in Excel. You can now launch the Power Query Editor by pressing Alt + F12 instead of going to Data > Get Data >…
For over 15 years, the bedrock of an Excel worksheet has been its 1,048,576 row by 16,384 column grid to house our data, formulas, tables, and charts. It wasn’t always…
Since Elon Musk’s $44 billion acquisition of Twitter, things have gotten off to a rather tumultuous start. Like a bull in a china shop, he arrived and instantly asserted his authority, purging almost two-thirds…
TEXTSPLIT and BYROW were both released earlier this year. The former allows you to split a text value by a delimiter, whilst the latter applies a LAMBDA to each row…
Want an alternative to those boring 2D images strewn across your worksheet?Consider 3D models, which are graphics that can be rotated 360° or tilted up and down.Excel has an extensive…