Microsoft has launched a new AI-based feature in Excel that will reportedly make spreadsheet work simpler, but the company already wants users to give it a second thought before applying it to anything serious.
The “COPILOT” feature is also available to a group of Windows 365 Copilot users, enabling them to type Excel formulas in simple English rather than struggling with syntax. Instead of memorizing formula syntax, users can simply tell the AI what to do. Typing “=COPILOT(“Summarize this feedback”, A2:A20)” will prompt the AI to build a formula to summarize text in those cells.
This is a game-changer for anyone who has ever sat blankly staring at an Excel spreadsheet, wondering if they should be doing a VLOOKUP or an HLOOKUP. The feature is centered around three functions: sorting information, summarizing data, and creating content from what you already have in your spreadsheet.
The Limitations of Microsoft Excel’s Copilot
But Microsoft is oddly candid about the feature’s limitations. The company outright discourages users from applying the COPILOT feature to “any task where accuracy or reproducibility matters,” especially numerical calculations. They’ve even warned against applying it to financial reporting, legal filings, or other high-stakes uses, which, we’re being realistic here, is a lot of what most people use Excel for.
This cautionary approach is representative of the broader concerns with generative AI tools. Like other AI tools, Excel’s COPILOT function can “hallucinate” giving you answers that appear correct but are not. It also misinterprets requests, leading to formulas that do not do what you actually intended. For a tool designed to deal with data and calculations, problems with accuracy are particularly frustrating.
Privacy is another consideration that users need to keep in mind. Microsoft has stepped up to mitigate this by stating that information transmitted through the COPILOT feature will not be used to train or improve their AI models.
A Title for an Article on AI in Excel
According to their statement, the input data that you provide is kept private and is only used to generate the output you have requested. While this provides some comfort, it’s still something to consider when it comes to what information you’re comfortable transmitting to any AI system.
Nowadays, the feature has several practical limitations besides accuracy problems. The users are restricted to 100 calls within 10 minutes or 300 calls within an hour, which can be restrictive for heavy users of Excel. The feature also cannot access live web data or in-house business documents, limiting its usefulness compared to an AI assistant that you’d expect to be fully integrated.
Because this is currently a beta feature, Microsoft is actively soliciting user feedback in an attempt to make the system better. Currently, it is only available to Microsoft 365 Copilot Beta Channel users, so most individuals will not have access to it yet.
The integration of AI into Excel is a dramatic change in how we will be able to work with spreadsheets in the future. For tasks such as sorting survey answers or creating simple summaries, the COPILOT function might well save time and decrease learning time for new users of Excel.
But Microsoft’s guidance itself points to an important consideration regarding AI tools: they are most effective as assistants, not substitutes, to human judgment. The feature is most suited for exploratory work, rapid summaries, or when an approximation will do.
Focus on Precision and Limitations
For whoever gets to use this feature, the trick will be knowing when and where to use it and when to use old-school formulas. Precision-sensitive operations, such as financial arithmetic, bookkeeping for budgets, or any analysis that must be as precise as possible, are likely best done the old-school way.
As AI moves further into the tools that people use in their daily work, Microsoft’s open approach to explaining limitations is welcome. Instead of hyping the capabilities of the technology, they’re educating users on both its promise and its limitations. That sort of clear communication will be crucial as AI moves further into the tools people use for work.
