数据透视表（）.doc

数据透视表（） Excel PivotTable and PivotTable Fundamentals Overview of PivotTable and PivotTable show all hide all Using PivotTable, you can aggregate, analyze, browse, and provide summary data. Using data perspectives, you can visualize this summary data in a PivotTable, and you can easily view, compare, model, and trend. Both PivotTable and PivotTable enable you to make decisions about key data in your business. The following sections provide an overview of the PivotTable and pivottable. Content of this article About PivotTable Method for processing PivotTable About perspective Compare pivot tables and perspective views What is the difference between a PivotTable and a chart? Handling the PivotTable data source data source data and Perspective About PivotTable A PivotTable is an interactive way to quickly aggregate large amounts of data. Using PivotTable, you can analyze the numeric data in depth, and you can answer some unexpected data problems. The PivotTable is specially designed for the following purposes: Querying large amounts of data in a variety of user friendly ways. Sorting, aggregating, and aggregating numeric data, aggregating data by category and subcategory, creating custom calculations and formulas. Expand or collapse, focus on the data level of the results, and see the details of the summary data for the area of interest. Move rows to columns or move columns to rows (or perspective) to see different collections of source data. Filtering, sorting, grouping, and conditionally formatting the most useful and interesting data subsets enables you to focus on the information you need. Provide concise, attractive and annotated online reports or printed reports. If you want to analyze the relevant aggregate values, especially when you want to add up a larger list of numbers and compare each of them, you usually use the pivottable. In the PivotTable report below, you can easily see how the third quarter Golf sales in cell F3 compare with other sports or quarterly