I would like to know what the excel pivot table is used for?

Pivot tables can help users analyze and organize data. It can be used to quickly classify and exchange data from different angles.

First of all, it should be clear that not all worksheets have the need to create pivot tables (graphs).

For worksheets with a large number of records, records in the form of journals, and complex structures, in order to reveal some of the inherent laws, the worksheets can be reorganized and algorithms added. That is, create a pivot table (graph).

For example, there is a worksheet that contains an employee of a large company (name, gender, date of birth, department, working time, political affiliation, academic qualifications, technical title, length of service, graduation school, graduation Time, etc.) information list, not only has many fields (columns), but also has a large number of records (rows). To this end, a pivot table needs to be established to reveal some inherent patterns.