Microsoft / Elyse Betters Picaro / ZDNET
ZDNET's key takeaways
A new COPILOT function in Excel lets you use AI in a formula.
The new skill is now available to Microsoft 365 insiders.
Reduces some of the complexity involved in creating formulas.
Get more in-depth ZDNET tech coverage: Add us as a preferred Google source on Chrome and Chromium browsers.
Using functions in Excel can sometimes be challenging, especially if you're trying to devise complex formulas to work with your data. Now Microsoft is tapping into AI in an attempt to ease the process.
New COPILOT function
On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a prompt to tell Excel what you want to achieve.
You're able to use the new COPILOT function alongside existing functions such as IF, SWITCH, LAMBDA, and WRAPROWS. Alternatively, you can use the results from other formulas as part of your prompt. If your data changes, the resulting formula using Copilot automatically changes. So you don't have to redo or revise the prompt or refresh the results on your own.
... continue reading