For example, you can use the function to reference cell values and categorize data. Because it is a function, COPILOT can be used alongside other functions.

Microsoft is adding a COPILOT function to Excel, letting you use natural language prompts inside formulas to analyze, summarize, and categorize data.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.