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

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

The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, ...