如何使用Excl中的数据透视表.docVIP

作业指导 MS Excel 如何制作数据透视表 概述 如何利用数据透视表分析数据 定义 不适宜使用的情况 必备的知识 如何制作一张简单的电子数据表 1.2 点开“数据”菜单，再点击“数据透视表和数据透视图”菜单 1.3选择“数据透视图（仅数据透视表）” 点击“下一步”，这时你会看到一个对话框“请选定要建立数据透视表的数据源区域”，你可以发现在图表上系统已经默认用虚线将所有数据包括在内。 使用鼠标去选择你想要的数据范围，当然你也可以在对话框中直接输入你想要的数据范围。在本例中，我们取用从1至52行的有效数据。 然后单击“下一步”，将会弹出一个对话框询问数据透视表的显示位置，在此我们推荐选择“新建工作表”。 然后单击“完成”。 现在，已经成功的创建了一个新的数据透视表，你可以往其中添加所需要的数值了。 2. 在数据透视表中添加数值 2．1在这一步，我们使用“地点”作为横轴底坐标，使用鼠标左键单击“地点”，然后用鼠标将“地点”拖拽到数据透视表底部的“在此处放置分类字段”上。 拖拽完成后，我们可以看到横轴底坐标是与“位置”相关的项目。 接下来，我们将继续导入一些数据。 2.2点击“分钟数”，用同样的方式将其拖拽入图表上标有“请将数据项拖至此处”的灰色区域，如下图所示： 如果我们还想看一下人员对于结果的的影响，我们可以单击“人员”，然后将它拖拽至数据表右侧“在此处放置系列字段”处，显示如下。 数据透视表制作完成。 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 ol