数据透视表及数据透视图.docVIP

数据透视表及数据透视图 25 种简易数据透视表 显示如何使用数据透视表分析数据时存在困难,本文介绍如何从基本数据源开始创建数据透视表来回答有关数据的常见问题。您可以将这些技术用于任何类型的源数据，下面提供了可用于多种用途的报告: 比较销售人员 比较产品 比较订单 比较您的客户 要直接使用这些 显示如何使用数据透视表分析数据时存在困难,本文介绍如何从基本数据源开始创建数据透视表来回答有关数据的常见问题。您可以将这些技术用于任何类型的源数据，下面提供了可用于多种用途的报告: , 比较销售人员 , 比较产品 , 比较订单 , 比较您的客户 要直接使用这些数据透视表，请 下载 Excel 2002 示例:数据透视表(英文)，即本文的参考工作簿。除了包含本文中的源数据和报表的副本外，这些工作簿还包含四个数据透视表，它们说明了如何以图形方式来显示信息。 为了使示例易于理解，它们均采用报表 5 格式，您可以使用“设置报告格式”命令将此格式应用到您自己的数据透视表。 比较销售人员 从包含销售人员信息的源数据开始。以下是一些用于本节中报表的源数据记录。要查看整个源数据区域，请下载本文的参考工作簿(英文)。 设置数据透视表: document management as a breakthrough, and constantly improve the content, active in the application. Government information between the provincial and municipal governments all passed through a network of offices, and six counties (districts) have complete decision-making service system and through dial-up internetworking is realized with the city, the City Planning Commission and other 10 departments has been one of the first to achieve a single network with the city. On the Governments website, focus on strengthening the management and operation of the site, update the website in a timely manner, strengthening the network resource sharing. At present, nearly 700 municipal government website page, updated news more than more than 6,000. Not long ago, China International e-government technology and application Conference was carried out in the country, survey of best public services Government website activities in Pingliang city peoples Government website in five Northwestern provinces (districts) ranked second, ranked first in the Gansu province. V, infrastructure has made new breakthroughs In 2002 smooth completed organ office building of construction, and decoration and relocation of based Shang, we according to organ construction general planning, demolition hospital within old room 37 between, transformation garden 3600 square meters, new plant lawn 2700 square meters, planting 1. 单击源数据中的一个单元格。 2. 在“数据”菜单上，单击“数据透视表和数据透视图”。 3. 按照向导步骤 1 至步骤 3 中的说