Excel 简明教程

Pivot Tables in Excel 2010

Pivot Tables

数据透视表本质上是从数据库生成的动态汇总报告。该数据库可以驻留在工作表中（以表格形式）或驻留在外部数据文件中。数据透视表可以帮助将无穷无尽的行和列数字转换成有意义的数据表示方式。数据透视表是对数据进行汇总分析的非常强大的工具。

A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers into a meaningful presentation of the data. Pivot tables are very powerful tool for summarized analysis of the data.

数据透视表可在 Insert tab » PivotTable dropdown » PivotTable 下找到。

Pivot tables are available under Insert tab » PivotTable dropdown » PivotTable.

Pivot Table Example

现在，我们借助示例来看数据透视表。假设您有大量选民数据，并且您想要查看按政党划分的选民信息的汇总数据，那么您可以使用数据透视表来实现。选择 Insert tab » Pivot Table 以插入数据透视表。MS Excel 将选中表格数据。您可以选择数据透视表位置，可以是现有工作表或新工作表。

Now, let us see Pivot table with the help of example. Suppose you have huge data of voters and you want to see the summarized data of voter Information per party, then you can use the Pivot table for it. Choose Insert tab » Pivot Table to insert pivot table. MS Excel selects the data of the table. You can select the pivot table location as existing sheet or new sheet.

pivot table

这将生成如下所示的数据透视表窗格。您在数据透视表窗格中有多种可用选项。您可以为生成的透视表选择字段。

This will generate the Pivot table pane as shown below. You have various options available in the Pivot table pane. You can select fields for the generated pivot table.

pivot table structure

  1. Column labels − A field that has a column orientation in the pivot table. Each item in the field occupies a column.

  2. Report Filter − You can set the filter for the report as year, then data gets filtered as per the year.

  3. Row labels − A field that has a row orientation in the pivot table. Each item in the field occupies a row.

  4. Values area − The cells in a pivot table that contain the summary data. Excel offers several ways to summarize the data (sum, average, count, and so on).

在为数据透视表提供输入字段后，它会生成如下图所示带有数据的数据透视表。

After giving input fields to the pivot table, it generates the pivot table with the data as shown below.

pivot table example