How to make a summary report?

In the table, under the Data menu bar, you can make a summary report by sorting and summarizing, or you can make a summary report by inserting a PivotTable report under the Insert menu bar.

1. First, open excel. You can make a summary report by classifying and summarizing, and sort the categories that need to be classified and summarized in data installation to keep the same categories together.

2. After selecting data, click "Data".

3. Then click "Classified Summary".

4. Set classification fields and selected summary items, and click OK.

5. In this way, we can classify and summarize and make a summary report.