Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.

As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...

Build a free 2026 Excel budget file with bank import and XLOOKUP categories, so you track spending and savings without manual typing.

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Khadija Khartit is a strategy, investment, and funding expert, and an ...

Then, in the same function, you can add another query and specify cells, and pull data in from multiple places—it becomes an Xlookup on steroids. The function will only be available to Microsoft 365 ...