Global Excel Summit Portfolio
This page contains a collection of work I’ve created for the Global Excel Summit.
Formula Argument Assistance arrives in Excel for the web
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 syntax, an example, and a description for each argument. Moreover,…
Copilot is coming to Microsoft 365
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…
FILTER with wildcards
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) —…
Pin windows on top of others using PowerToys’ Always On Top utility
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…
New keyboard shortcut to open the Power Query Editor in Excel
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.
