Excel Pivot Tables 简明教程

Excel Pivot Tables Tutorial

数据透视表是用于切片和处理数据的极强大工具。在本教程中，您将详细了解这些数据透视表功能以及示例。完成本教程后，您将会对数据透视表功能有充分的了解，可以开始根据要求来探索、分析和报告数据。

PivotTable is an extremely powerful tool that you can use to slice and dice data. In this tutorial, you will learn these PivotTable features in detail along with examples. By the time you complete this tutorial, you will have sufficient knowledge on PivotTable features that can get you started with exploring, analyzing, and reporting data based on the requirements.

Audience

本指南的目标是跟踪和分析数以十万计数据点的专业人士，使用紧凑型表格。

This guide targets professional who have to track and analyze hundreds of thousands of data points with a compact table.

本指南的目标是希望在演示中使用表格或图表，并帮助他人快速理解数据的人员。无论您是想进行比较、显示关系还是突出趋势，这些表格都可以帮助您的受众“看”到您所说的内容。

This guide targets people who want to use tables or charts in presentations and help people understand data quickly. Whether you want to make a comparison, show a relationship, or highlight a trend, these tables help your audience “see” what you are talking about.

Prerequisites

在继续本教程之前，我们假定您已了解 Microsoft Excel 基础知识。如果您不太了解这些概念，我们建议您学习我们关于 Excel 的简短教程。

Before you proceed with this tutorial, we are assuming that you are already aware of the basics of Microsoft Excel basics. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel.