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 ways. In Excel, you’ll be able to ask questions about…
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) — represents any number of characters. ? (question mark) —…
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 before going on to have versions for Windows XP, Windows…
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 > Launch Power Query Editor. A small but welcome addition.
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 this way. Prior to Excel 2007, only 65,536 rows and…
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 and returns an array of the results. Take a look…
