Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Learn to use the best new features in Excel for Microsoft 365 in Windows.

New COPILOT function On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet cells with AI.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Certain Windows 365 Copilot users now have access to a new feature in Excel that lets you use Microsoft's Copilot AI ... if you're using the COPILOT function, you need to keep an eye out for the AI ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.