Microsoft Excel
Copilot in Excel: When to Use a PivotTable vs Functions
Copilot in Excel can create PivotTables in seconds, and that is great for basic summaries. But when you need calculations that go beyond what a PivotTable can show — median, second highest, third highest — functions are the better approach. Here is how to use Copilot for both, and when to choose