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) —…
Google gaffe takes shine off Bard
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 Twitter, the following question was asked: “What new discoveries from…
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…
