EXCEL 2010 Learning Notes-pivot table

Today, organize the course notes for the EXCEL2010 pivot table, which can be used to count and organize multiple sets of data, which is a basic data visualization tool.

A summary of 6 aspects is recorded:

1. Create a PivotTable report

2. Change how a PivotTable report is summarized

3. Change the combination of pivot tables

4. Summarize multiple columns of data and make separate statistics of the data

5. Use formulas for calculations in pivot tables

6. Create multiple worksheets with filter fields

1. Create a PivotTable report

From the basic operational level: After you have obtained the data source, you can generate a PivotTable report with a simple insert function and a drag command. When creating a new table, first determine the row of the last table, and what data will be recorded separately. Each field can be used as ' columns ' and ' values ', respectively.

Select any cell, insert, drag and drop the PivotTable, and delete the field to get an empty table 2, and then

Figure 1

Figure 2 Pivot table-Empty table

Data source and final pivot table

2.3. Change Summary method: Change month display as quarterly KEY: Use combination command

Use the Create Group command to summarize data

4. Summarize multiple columns of data : Generate multiple fields by dragging multiple times, and then modify the field settings to get different data. Inserting multiple fields can cause overlapping problems, and double-clicking a field to set a field setting can modify the summary method.

Double-click the field name to display the Value field settings

5. Use calculations in a PivotTable report:

Problems displayed: Click Cells, right-hand pivot table options, for error values display as "NULL NULL"

Settings for percentages

6. Create multiple worksheets with filter fields:

Insert a field into the value area and the report filter area, Options command Card, display report filter page get 36 separate new worksheets->shift multiple selection, copy and paste empty table Delete original pivot table

EXCEL 2010 Learning Notes-pivot table