Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it now.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet ...

Working like a normal Microsoft Excel function, users can add prompts in quotes and optional cell ranges for even more context, leading results to automatically change when the source data changes.