Copilot is now available as an Excel function for Microsoft 365 insiders, enabling natural-language prompts directly inside formulas. The COPILOT function can be used alongside existing functions such as IF, SWITCH, LAMBDA, and WRAPROWS, and can reference results from other formulas. Formulas that include Copilot update automatically when underlying data changes, removing the need to redo prompts or manually refresh outputs. Access requires enrollment in the Microsoft 365 Beta channel and a Microsoft 365 Copilot subscription. The feature aims to reduce complexity and speed tasks like data wrangling, summarization, categorization, and brainstorming within spreadsheets.
"It can be painful and time-consuming to wrangle data, summarize feedback, categorize information, and brainstorm ideas," Microsoft said in . "The new COPILOT function in Excel for Windows and Excel for Mac is here to save time and supercharge your workflows. Just enter a natural language prompt in your spreadsheet, reference cell values as needed, and watch Copilot instantly generate AI-powered results."
"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."
Collection
[
|
...
]