News

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are many ways to do it. Microsoft 365’s new FILTER () function is a powerful upgrade.
This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.