- Can now interact with excel cells in natural language with = co -pilot
- It does not interact with the external web data … still
- You can combine it with other Excel functions
Microsoft is implementing a new Excel AI function directly in the cells, so you can take advantage of the generative AI and take even more information even more easily than you can achieve a simple formula in your spreadsheet software.
Copilot in Excel Cells is being implemented in Microsoft 365 Copilot Beta users in the internal program and the beta channel to start, the most strict integration will be available in Windows (version 2509+) and Mac (version 16.101+) before it reaches the web version.
Working as a normal Microsoft Excel function, users can add indications in quotes and ranges of optional cells to obtain even more context, which carries the results to automatically change when the data of origin changes.
Excel co -driver function
“Simply enter a natural language application on your spreadsheet, the values of the reference cells as necessary and see the co -pilot instantly generating results with AI,” said associated director Catherine Pidgeon in a blog post.
In addition to using the AI tool to create new types of indications or generate formulas that could not have been able to do without expert knowledge, users can also combine the Excel co -ilot formula with other functions such as, Switch, Lambda or Waprows.
Some examples of the cases of use of = co -senses include summarizing customer comments, classifying data, integrating external knowledge and formatting.
In its simplest form, a function can resemble “= co -pilot (soon [context1]) ” – Although the context is optional.
Pidgeon said the function = Copilot only uses data in which it was trained, so you cannot access new web data or company documents at this stage.
Being a beta product, there are still some improvements that Microsoft expects to make its Excel AI assistant, including more data sources beyond the training of LLM and the date of date of the series format of the expand of the Excel date instead of the only text, as is currently the case.