No more Power Query needed.

Microsoft introduces a new COPILOT function in Excel. It will allow users to create formulas using simple language. This feature is currently available to Microsoft 365 Copilot subscribers in the Beta ...

Microsoft adds IMPORTTEXT and IMPORTCSV to Excel, letting users pull text files directly into the grid with simple formulas.

TL;DR: Microsoft is launching Copilot AI for Excel, a new feature that uses advanced language models to help users analyze data, summarize information, and generate ideas directly in their ...

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...