- 表格制作excel教程:COUNTIFS函数基础应用
- xcel表格制作教程入门:批量绘制Excel图表
- excel vba教程:Excel 终值函数FV的应用
- excel入门教程:定义名称法创建动态数据透视表
PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs
数据透视表4:任务向导用户界面,或“为我们提供改进的 Ribbon”,及对话框的一些其它优点。
As I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader range of users. Today I want to take a closer look at the new user interface – especially the ribbon – and how we have tried to make commonly-used features and functions much more visible and available with very few clicks of the mouse. I am also going to briefly cover some changes and additions to the PivotTable Options and Field Settings dialogs.
正如我在前面的文章中提到的,Excel12中数据透视表的一个主要目标就是通过使用RIBBON和新的对话框来提高性能,使更多的用户易于使用它。今天我想更进一步介绍新的用户界面——特别是RIBBON——以及我们如何使常用的特性和功能更容易被发现和利用,并只需点几下鼠标就能实现。首先,我简要的介绍一下数据透视表选项和字段设置对话框的一些改变和新增功能。
PivotTable tab I – the Options tab
When a PivotTable is active (meaning the active cell is inside a PivotTable), you will see two extra PivotTable tabs in the ribbon: Options and Styles. Here is what the PivotTable Options tab looks like in the beta build (note, there is a fair bit not done in this tab, so it is definitely not what you will see in the next beta or when we release Office 12).
数据透视表标签I:选项标签
当数据透视表激活时(意味着活动单元格在数据透视表中),在RIBBON上你会看到两个额外的数据透视表标签:选项和样式。如下图是透视表选项标签在测试版中所看到的样子(注:其中有相当一部分未完成,所以你在下一个测试版或最终版的Office12中看到的会不一样)。
This tab is designed to hold all the commands you would commonly use when working with a PivotTable. In addition to giving us more room to expose all the functionality that already exists in Excel PivotTables, it also provides space to advertise new features we have added in Excel 12. In our testing, we have found that it allows all users (both beginning and power users) to take advantage of a wider range of features than in previous versions of Excel. We are pretty excited to see this sort of improvement.
这个标签用来容纳你在使用数据透视表时的所有常用命令。它给了我们更多的空间来陈列Excel数据透视表已有的全部功能,同样,它还提供了列出Excel 12新增功能的空间。我们在测试中发现:比起以前的Excel版本,所有用户(包括新手及高级用户)能够更广泛地利用Excel的功能。我们很高兴看到这样的改进。
Let’s walk through a few of the interesting “chunks” and controls on the Options tab (I will try and cover others as I put up more posts in the future). The first one I would like to point out is the Change Data Source button.
让我们来看看选项标签中一些有意思的“chunks”和控制项(我会发表更多的文章介绍其它的命令)。我想指出的第一个就是“更改数据源”按钮。
Clicking this button opens a dialog which allows you to easily change either the source data range for PivotTables based on data inside Excel or to change the connection for PivotTables based on external data (which is something we hear customers ask about all the time). An example of this would be switching from a test database to a production database. Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.
点击这个按钮将打开一个对话框,在对话框中你可以很容易地改变基于内部数据的数据透视表的源数据范围或者基于外部数据的数据透视表的数据连接(这是用户经常提及的东西)。例如:我们将数据源从一个测试数据库转换为一个产品数据库。下面是对话框的一个截图,举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。
Next, let’s take a look at the “Clear” drop down and the “Change Location” button.
下一步,我们看看“清除”下拉菜单和“改变位置”按钮。
上一篇:excel函数公式大全:PowerPoint和Word中的图表 下一篇:excel函数教程:随心所欲设置Excel日期格式
郑重声明:本文版权归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。