素材分类
零度网 对编辑公式功能的改进Part 3_Excel 2007新知_Excel教程 attach_img
Formula editing improvements Part 3: new functions 对编辑公式功能的改进 Part 3:新增函数 In addition to improving the formula editing UI in Excel 12, the team has spent some time adding to Excel’s fu ...
最后发表: 零度网@ 2017-12-8 23:31 12 0 2017-12-8
零度网 对编辑公式功能的改进Part 1_Excel 12 编辑栏_Excel 2007新知_Excel教程 attach_img
Meet the Excel 12 formula bar, or “don’t hijack my grid!” . 相约Excel 12 编辑栏——“请别妨碍到表格” I’d like to shift gears a bit and talk about the work we’ve done to improve the experience ar ...
最后发表: 零度网@ 2017-12-8 23:31 17 0 2017-12-8
零度网 条件格式与Ribbon_Excel 2007新知_Excel教程 attach_img
现在我们回顾一下Excel 12中新增加的条件格式功能,让我们看看要如何更容易的找到并使用这些功能。我们的目标之一,是在界面中突出展示这些新功能,所以我们把条件格式的入口放在新的Excel Ribbon中的第一个标签里面 ...
最后发表: 零度网@ 2017-12-8 23:31 17 0 2017-12-8
零度网 Excel 2007条件格式中的新规则_Excel教程
在我介绍条件格式的改进目标时,收到了很多的反馈信息。我曾说过,改进目标中的重要一项是使用条件格式时尽可能不需要编写任何公式。下面让我简要的介绍一下这方面的情况。 Excel 2003在允许用户在创建条件格式时使 ...
最后发表: 零度网@ 2017-12-8 23:31 15 0 2017-12-8
零度网 在VBA中使用条件格式的示例_Excel 2007新知_Excel教程
Since I have had some comments and emails asking about how the new conditional formatting features could be accessed using VBA, I wanted to provide a few brief examples. One of the Excel team’s princ ...
最后发表: 零度网@ 2017-12-8 23:31 10 0 2017-12-8
零度网 更多有关条件格式的内容……_Excel教程 attach_img
Another goal that we had for conditional formatting was to address top customer requests, like more than three conditions, the ability to reorder conditions, and the ability to have more than one cond ...
最后发表: 零度网@ 2017-12-8 23:31 14 0 2017-12-8
零度网 对编辑公式功能的改进Part 4_名称_Excel教程 attach_img
polFormula building improvements Part 4: Defined Names 对编辑公式功能的改进 Part 4:名称 Defined names are a very useful tool for authoring formulas. Defined names allow users to name cell ranges, for ...
最后发表: 零度网@ 2017-12-8 23:31 7 0 2017-12-8
零度网 Tables Part 1_处理列表中的数据_Excel 2007新知_Excel教程 attach_img
Tables Part 1: Working With Tables Of Data 列表(第一部分):处理列表中的数据 (译者注:本文中的“列表”其原文为“Table”,在已经发布的Excel中有一项功能称为“模拟运算表”【在数据菜单中】,在其相应当英 ...
最后发表: 零度网@ 2017-12-8 23:31 8 0 2017-12-8
零度网 Tables Part 3_在列表中使用公式(二)_Excel 2007新知_Excel教程 attach_img
When I press enter to commit the change, Excel adds another column to my table – the appropriate formatting is applied to the rows, the border around the table adjusts, etc. So far so good. 按下回车 ...
最后发表: 零度网@ 2017-12-8 23:31 12 0 2017-12-8
零度网 Tables Part 3_在列表中使用公式(一)_Excel 2007新知_Excel教程 attach_img
Tables Part 3: Using Formulas with Tables 列表(第三部分):在列表中使用公式 One of our goals with tables was to create a set of features that reduce the overall maintenance required to keep a spreads ...
最后发表: 零度网@ 2017-12-8 23:31 4 0 2017-12-8
零度网 对编辑公式功能的改进Part 2_Formula AutoComple_Excel 2007新知_Excel教程 attach_img
poFormula editing improvements Part 2: Formula AutoComplete 对编辑公式功能的改进 Part 2:Formula AutoComplete Last post I covered improvements we made to a long-time fixture of the Excel UI - the form ...
最后发表: 零度网@ 2017-12-8 23:31 11 0 2017-12-8
零度网 Tables Part 4_自动筛选的改进(二)_Excel 2007新知_Excel教程 attach_img
In the spirit of completeness, Excel 12 also provides text-based filters for working with non-numeric columns. 为了力求功能的完整,excel 12 对没有数字的列也提供了文本筛选功能 Another feature for date ...
最后发表: 零度网@ 2017-12-8 23:31 4 0 2017-12-8
零度网 Part 5_Excel 12中的排序问题(二)_Excel 2007新知_Excel教程 attach_img
… and I wanted to see all the yellow and red items at the top. I would simply use the sort/filter button to sort first by red … 我想在上面看到所有黄色和红色项目. 我只简单的使用排序/筛选按钮先对红色 ...
最后发表: 零度网@ 2017-12-8 23:31 12 0 2017-12-8
零度网 数据透视表III—更多可选择、更简洁精美的样式_Excel教程 attach_img
PivotTables part 3: More clickable, more compact, and nicely styled 数据透视表3:更多可选择、更简洁精美的样式 Today, I would like to cover some of the improvements we made in Excel 12 to make PivotTab ...
最后发表: 零度网@ 2017-12-8 23:30 5 0 2017-12-8
零度网 VIII -推迟数据透视表更新_Excel教程 attach_img
PivotTables VIII: “Defer Layout Update”, or adding multiple fields in one fell swoop 数据透视表 VIII:“推迟布局更新”,还是猛然添加很多字段 In this article, I’ll cover a small yet very useful Pivo ...
最后发表: 零度网@ 2017-12-8 23:30 5 0 2017-12-8
零度网 Tables Part 4:自动筛选的改进(一)_Excel 2007新知_Excel教程 attach_img
Tables Part 4: AutoFilter improvements: much more than just multi-select … 自动筛选的改进:远远不仅是多项选择 Sorting and filtering are two of the most important types of basic analysis that you can ...
最后发表: 零度网@ 2017-12-8 23:30 5 0 2017-12-8

快速发帖

还可输入 80 个字符
您需要登录后才可以发帖 登录 | 立即注册

本版积分规则

- 手机版-禁闭室- 零度资源网.   

Powered by 零度网 零度素材 © 2015-2018 www.d20.net.  蜀ICP备16007770号-9