Microsoft Copilot enables Excel natural-language analysis

Microsoft has been positioning Copilot in Excel as a way to let users query spreadsheets in plain language rather than build every formula, pivot and chart by hand. Microsoft Support says Copilot in Excel can help users “create and understand formulas, analyze your data for insights, and more,” while Microsoft Learn training materials describe workflows for summarizing data and creating visualizations from prompts. That framing matches how some practitioners described the tool on X on May 19, where users pointed to prompts such as asking Excel to identify sales declines by region and produce a graph. Other posts the same day said some licensed users still had not spent enough time learning the feature set, underscoring a gap between access and day-to-day use. (support.microsoft.com) ### What does Copilot in Excel actually do when someone types a question? Microsoft Support says Copilot in Excel is built to respond to natural-language requests across several common spreadsheet tasks: analyzing data, generating formulas, explaining formulas and creating visuals. Microsoft’s Excel help page describes the same bundle more simply — generate formulas, analyze and summarize data, and add visuals to spreadsheets. (microsoft.com) Microsoft’s training materials show the product is meant for short, direct requests. One Microsoft Learn module says users can “quickly generate formulas, summarize data, and create visualizations,” while another says prompts can be used to produce summaries, comparisons and visualizations from a dataset. ### Why are people using it for sales-drop and regional-analysis prompts? (support.microsoft.com) Sales analysis is one of the clearest use cases because it combines three things Excel users often need at once: a comparison, a calculation and a chart. Microsoft’s documentation says Copilot can work with tables, charts, PivotTables and formulas, which means a prompt about regional sales declines maps directly onto functions Excel already performs manually. (learn.microsoft.com) Microsoft also provides examples that mirror that pattern. Its formula-generation documentation says Copilot can create rows or columns that calculate totals, and its charting documentation says users can ask Copilot to create the kind of chart they want from existing data. ### What has to be in place before those prompts work well? (support.microsoft.com) Microsoft says Copilot in Excel works only with Excel files saved to OneDrive or Microsoft 365 SharePoint locations with AutoSave turned on. The company also says users should make sure data is in a supported format such as a table, a requirement that matters because Copilot performs best when headers, columns and ranges are clearly structured. (support.microsoft.com) Microsoft Support adds that chart creation is available, but not every Excel chart type is supported. The company says Copilot currently supports more than 12 chart types. ### Why do some licensed users still say they have not mastered it? Microsoft’s own training material suggests part of the answer is prompt craft. A Microsoft Learn path on prompting says users get better results when they provide a clear goal, context, source and expectation. (support.microsoft.com) That implies the tool is accessible in plain language, but still rewards users who learn how to ask for a specific output. (support.microsoft.com) Microsoft has also built a Prompt Gallery and multiple Excel-specific learning modules, indicating the company expects a learning curve beyond simply turning the feature on. Those resources include examples, videos and articles meant to help users move from basic requests to more repeatable workflows. ### Where would a new user start right now? Microsoft says the starting point is a workbook stored in OneDrive or SharePoint, with AutoSave enabled and the data arranged as a table. (learn.microsoft.com) From there, users can open the Copilot pane from Excel and begin with direct requests to summarize data, explain formulas or create a chart from a selected dataset. (learn.microsoft.com) Microsoft’s current support pages, Prompt Gallery and Learn modules remain the main reference points for the next step: learning which prompts reliably turn raw spreadsheet data into formulas, summaries and visuals. (support.microsoft.com 1) (support.microsoft.com 2)