Summary reports with charts and pivot tables

- Creating reports can be an overwhelming Excel task that takes hours. In this lesson, we'll use Copilot to quickly summarize and visualize our data in seconds with PivotTables. So here I have some sales data, and I wanna create a quick summary report. So I'm gonna go over to the Copilot task pane and click Summarize using PivotTables or charts. So Copilot has analyzed the data, and it's giving us this nice summary report of sum of revenue by category. It shows more information about it down here. And we can add this report to a new sheet. So the new sheet has been added here. And this report is a PivotTable. Now a PivotTable is essentially a summary report in Excel. And when we click any cell inside the PivotTable, the PivotTable Fields list will appear here on the right side. This is the control panel for the PivotTable, and we can quickly make changes. So if we didn't wanna see Category, we can just drag that…