当前位置:主页 > Office办公 > Word专区 > Word教程 > Word2007教程

最新发布

Tables Part 3_在列表中使用公式(二)_Excel 2007新知
Tables Part 3_在列表中使用公式(二)_Excel 2007新知

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.按下回车键之后,Excel为我的列表添加新的一列——相应的格式将会应用到所有的新添加的行,列表的边框也将进行相应当调整。The next step is to write the formula. I might do something like type "=(" and then use the keyboard to move selection over to the cell I want to calculate – in this case FY05. Excel gives me the following reference: [FY05].下一步是输入公式,输入“=(”之后,然后用键盘选中需要计算的区域——也就是本例子中的FY05,Excel将自动输入[FY05]。As you can see, when referencing a table from within the table itself it is not necessary to prefix the table name. As I use other columns in my formula, they get similar references.这里我们可以看到,如果在列表中使用本列表的相关引用名称,那么不需要列表名称作为前缀,使用类似的方法可以在公式中引用其他的列。When I am finished with my formula and press ENTER, Excel automatically fills that formula down for all rows in the Percent Growth column. 当我输入完公式并按回车后,Excel将自动在“Percent Growth”列中向下填充公式。This is another new feature of tables called calculated columns. Any time a formula is entered into an empty table column it will automatically fill. We think this will help reduce errors introduced by manual filling or copy/paste. Not only does it fill, but it continues to fill down as you add or delete rows in the table. This is another one of those “sticky” properties I mentioned in my previous post. As with other table features, the user does have control over its behavior – at the time you enter a formula in a cell in a calculated column, the auto-fill can be undone using on-object UI (which you can see in the previous screen shot). Further, if you really do not want columns filling down ever, the feature itself can be turned off.

110 次浏览
Tables Part 4:自动筛选的改进(一)_Excel 2007新知
Tables Part 4:自动筛选的改进(一)_Excel 2007新知

Tables Part 4: AutoFilter improvements: much more than just multi-select …自动筛选的改进:远远不仅是多项选择Sorting and filtering are two of the most important types of basicanalysis that you can do with data. In Excel 12, we have improvedsort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were not possible in earlier versions. We have done work in AutoFilter, our sortfunctionality (Data|Sort), and in PivotTables. I will cover the first two (AutoFilter and Sort) in posts this week and PivotTables in a few weeks when I review all our PivotTable work. Today, I will focus on AutoFilter.排序与筛选是分析数据的最基本的两种方式, 在EXEL12 中, 我们的改进使选择与筛选的功能更加强大,普通任务一目了然,关键任务更加简单,使以前版本中不可能的场景成为可能。我们还在自动筛选,排序功能(数据排序),数据透视表方面做了改进。我将在本周发贴谈到前两个问题(自动筛选与排序),数据透视表将在几周后我收到我们所有的资料后谈到。今天,我将主要谈一谈自动筛选。Several of our goals for AutoFilter were driven by a couple of our top customer requests. Specifically, in Excel 12 we have

132 次浏览
移除重复的Excel列表(和区域)记录
移除重复的Excel列表(和区域)记录

Tables Part 6: Removing duplicates from tables (and ranges) of data列表(第6部分):移除重复的列表(和区域)记录Being able to remove duplicate rows of information from a table of data is a request we hear fairly often from our customers (and one of the top questions in the comments in this blog). Some users know that this capability exists in Excel today; unfortunately it is buried under advanced filter settings and it’s not terribly easy to use. So we set out in Excel 12 to build a better interface specifically for this task so that any user could easily remove unnecessary data from their spreadsheet.我们经常听到的一个客户需求是能够从列表中移除重复的数据行(这也是在博客中提出的最多的问题之一)。一些用户知道在目前版本的Excel中已有这个功能,遗憾的是它隐藏在高级筛选设置中且不易使用(译者注:即高级筛选中选择不重复的记录选项)。于是,我们在Excel 12中将这项功能设置在了一个更友好的专门的界面中,以便于任何用户都能容易地从电子表格中移除不需要的记录。Remove duplicates can be found in two places in Excel 12, on the Data ribbon as well as the Table ribbon (just like sort and filters, it’s not necessary to have a table in order to use this feature). To use the feature, a user simply has to select the data they want to examine for duplicates and press the “Remove Duplicates” button. This will bring up a dialog that looks like this:在Excel 12中移除重复记录的功能被设置在Data ribbon和Table ribbon中(就像排序和筛选一样,不需要设置专门的列表框来使用这个功能)。要使用这个功能,用户只需简单地选择想检查的记录,按下”Remove Duplicates”按钮后,出现下的对话框:You’ll notice that all my column headers appear in the dialog. To remove duplicates, just select the columns that Excel should use to evaluate duplicates. For example, in my table above I want to remove all duplicate rows where the first name is the same and the last name is the same. In other words, if there is more than one row where FirstName = David and LastName = Gainer then the extra duplicate rows will be removed. So my table which looked like this:你将看到列表中所有的列标题都出现在对话框中。要移除重复的记录,只需选择这些列标题,Excel将自动筛选除去(满足条件的)重复的记录。例如,在上表中,若要移除所有第一个名字和最后一个名字都相同的记录,即如果第一个名字为David且第二个名字为Gainer的记录多于一条,那么将移除多余的记录行。如下的列表:Now looks like the following after I remove duplicates.

162 次浏览
Tables Part 3_在列表中使用公式(一)_Excel 2007新知
Tables Part 3_在列表中使用公式(一)_Excel 2007新知

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 spreadsheet functioning well over time. This involves making spreadsheets less prone to error, as well as making them more understandable days, months, and years after the spreadsheet was created. Rethinking the interaction between tables and formulas proved to be an important part of meeting that goal.在以前的电子数据表格中,为了使其正常工作,用户需要大量的维护工作,我们引入列表的一个目的就是减少这部分维护工作,它可以使电子数据表格更不容易出错,也可以使生成的电子数据表格更好的理解年月日。列表和公式的协同工作被证明是实现这个目标的重要部分。As many readers have presaged, Excel 12 provides some new ways to reference tables and parts of tables. We refer to our work in this area as “structured referencing” (that is a working title, so it may be called something else when we ship the product). In a nutshell, the structured referencing feature allows you to reference a table and/or subsets of the table directly by name as opposed to by cell coordinates. The feature is similar in concept to named ranges with a few crucial differences. First, the names that can be referenced are automatically generated when the table is created. Specifically, this includes the name of the table itself (which by default is something like “Table1”), and the names of all the columns. Also, the names are automatically removed as columns are deleted or the entire table is deleted. Finally, and perhaps most importantly, the names automatically adjust as the table grows and shrinks. As a result, the majority of the headaches of maintaining named ranges go away with structured referencing.正如很多读者预测的一样,Excel 12提供了一些新的方法用于引用整个列表和部分列表,我们谈到的这部分工作成为“结构化引用”(这是开发过程中的名称,在最终发布的产品中可能使用其他的名称)。简单的说,相比过去我们只能通过单元格坐标进行引用,结构化引用功能使得用户可以通过名称引用整个列表或者部分列表,这个功能和区域名称的概念类似,只有很少的一点区别。首先,在生成列表时会自动产生一个可以引用的名称,这包括列表本身的名称(系统缺省为类似于“Table1”的名称)和全部列的名称,其次,这些名称会随着列或者列表的删除而消失,最后,可能是最重要的一点,名称会随着列表的扩展和收缩而自动调整。使用结构化引用将能够解决令人头痛最主要的问题——名称的维护。So how is all this manifested in the product? Structured referencing represents an addition to the syntax for formulas in Excel. Here are the basics of how it works.系统如何识别这些引用呢?结构化引用可以应用于Excel的公式中,下面我们来简单介绍一下它是如何工作的。· A reference to a table looks like this: =Table1, so if you wanted to sum the values in a table, you could use =SUM(Table1). Note that =Table1 returns all of the data in Table1 without the headers – this is because many of the common functions that work on ranges, like VLOOKUP, assume no headers.

152 次浏览
Excel2007新知:轻车绕便道,题外不言他 #3 Excel在XLL方面所做
Excel2007新知:轻车绕便道,题外不言他 #3 Excel在XLL方面所做

Quick detour #3: Updates we have made to XLLs轻车绕便道,题外不言他 #3:Excel 12在XLL方面所做的更新In the past few months, I have written a couple of articles (big grid, multi-threaded calculation) that prompted comments and questions along the lines of “what about XLLs?” Since the email questions have actually been picking up in frequency (I guess a lot of readers are also XLL authors), I thought I would write a quick article that outlines the changes we are making in this area to support new functionality.在过去几个月里,围绕“XLL将会怎样”的主题我有写过两篇文章(《更大的表格》、《多线程计算》),给出了一些相关的注解及问题。由于我收到的邮件中关于这方面的提问至今仍有相当的频度(我估计这其中的许多读者也是XLL加载宏的作者),我想我还是得再写上一篇简短的文章,来给大家描绘一下我们在新函数的支持方面所作的变更。Stepping back for a minute, let me briefly explain XLLs. An XLL is a DLL that is written so that Excel can open it directly. XLLs can be used for a number of things, but (in my experience at least) the most common use of XLLs is creating user-defined worksheet functions (UDFs) to supplement Excel’s intrinsic functions. Developers who write XLLs do so for a number of reasons, the paramount being performance.先耽搁您几分钟时间,让我来简要地介绍一下XLL为何物。XLL文件实际上就是一个能够让Excel直接打开的DLL(动态链接库)文件。虽说XLL文件可以用来做很多事情,不过,至少在我的经验中是这样,其最通常的应用是创建用户自定义工作表函数,以扩充Excel的内置函数。(译者注:就这一点而言,用VBA也可以做,那为什么还要编译成XLL文件呢?)开发人员这样做的原因有很多,其中一个最重要的原因就是为了提高执行效率。We have made three changes to XLLs in Excel 12, primarily to give developers access to new functionality. With Excel 12, XLL authors will have support for·The bigger grid

157 次浏览
PowerPoint和Word中的图表
PowerPoint和Word中的图表

图表四:PowerPoint和Word中的图表One thing we know is that many of the charts that folks created in Excel end up in PowerPoint presentations or Word documents (I think the statistic is that 50% of all charts in PowerPoint presentations originate from Excel. While users work in Excel to analyze their data, the final results are often given to others, and they rarely want to include all the intermediate steps from Excel. Furthermore, users have all kinds of solutions to transfer their charts. Most just use copy and paste, but some use Excel’s copy as picture command, or write VBA solutions, to update their charts in various ways. In Office 2007, our goal was to make copying and pasting charts into PowerPoint and Word as easy as possible. We also wanted the resulting charts to be as easy to use in PowerPoint and Word as they are in Excel, and we wanted to address a lot of problematic behaviours that existed in current versions of Office when you moved charts from Excel to PowerPoint one way or another. Today I am going to briefly review the work that we did in this area.我们知道有很多图表是在Excel中创建,然后在PowerPoint或 Word中使用(我觉得PowerPoint中大约有50%的图表是来自Excel的)。当用户使用Excel进行数据分析时,最后的报表往往不包含中间步骤,而是将最终结果交给别人。 此外,用户还会使用各种各样的方式传递图表。最多的就是使用拷贝和粘贴,也有些用户会用Excel的“复制为图片”命令,或写VBA解决方案,以各种方式来更新图表。在Office 2007中, 我们的目标是使复制并粘贴图表到PowerPoint 和Word中易如反掌。我们也希望此图表在PowerPoint 和Word中的使用与在Excel中一样方便。在当前Office版本中,当你用某种方式移动Excel图表到PowerPoint中时,我们要解决很多问题。今天我想简单地回顾一下这方面的内容。Charts as OfficeArt ShapesAt the core of all the improvements we have made in this area, charts in PowerPoint 2007 and Word 2007 are just like charts in Excel 2007. They are native objects in PowerPoint and Word, just like they are in Excel, and as a result, the user experience and behaviour is pretty much identical in all three applications. They have the same themes, chart types, layouts, and styles that were discussed in the last article. They even have almost the identical ribbons and dialogs as Excel 2007. Here is a screenshot of charting in Word 2007 in a near-beta-2 build. You can see how this is identical to what we looked at in Excel 2007 last week.我们在这方面改进的核心是:在PowerPoint 2007和Word 2007中使用图表有如在Excel中使用图表。在PowerPoint和Word中图表是默认对象,就像在Excel中一样。在三种不同的应用程序中其制作方法和过程基本相同,他们有同样的源数据,图表类型,布局和风格,也有与Excel 2007几乎相同的Ribbon和对话框。 这是一张Word 2007 beta-2的图表截图, 你可以看到这与我们上一篇里Excel 2007图表是多么相似。(Click to enlarge)The chart’s default theme will come from the presentation or document, just as it does from the spreadsheet’s theme in Excel. This ensures that your charts will match the rest of your document, whichever of the three applications you are using.For Office developers, the entire chart object model from Excel is now available for charts in Word and PowerPoint too. With a few modifications, it’s possible to migrate solutions that used the Microsoft Graph object model over to the new charts, although you can keep using Graph should you not want to migrate your code.

168 次浏览
Excel服务V——介绍“交互”
Excel服务V——介绍“交互”

Excel services part 5: all about “interactivity”Excel services (第5部分):介绍“交互”Now that I have discussed publishing spreadsheets to Excel Services, let’s review how users can “interact” with spreadsheets that Excel Services has generated. To start, I want to explain what we mean by “interact” because it is anther development-team term that may not be clear to everyone reading this article. 到目前为止,我已经讲述了将电子表格发布到Excel Services上的方法,现在来介绍用户如何与Excel Services上的电子表格交互。首先,我想解释一下”交互”的含义,因为这是另一个开发团队的项目,读这篇文章的人可能对此不太清楚。When we set about building Excel Services, we wanted to provide a richer experience than simply displaying a static spreadsheet in a browser. For example, we wanted users to be able to be able to change sorts and filters to better understand data they were looking at without leaving the context of the browser. We wanted users to be able to adjust PivotTables to see exactly they data they wanted to see in order to make better business decisions, again without leaving the context of the browser. We wanted users to be able to set parameters to perform what-if analysis, again from within their browser. We call all these sorts of things “interactivity”, since they involve the user taking actions that change the spreadsheet the user is working with, but do so without leaving the context of the browser. 当我们着手建立Excel Services时,我们希望提供更丰富的用户体验而不是简单地在浏览器中显示静态的电子表格。例如,我们希望用户不必离开浏览器页面就能变换排序和筛选来更好地理解他们正在查看的数据;能调整数据透视表以确切地看到他们想要的数据以便于做更好的商业决策;在浏览器页面就能设置参数来执行假设分析。上述这些都称作”交互”,即用户不须离开浏览器页面就能处理电子表格。Specifically, our goals in this area are to allow users to:具体地讲,我们的目标是允许用户能做如下操作:• view spreadsheets in a browser

134 次浏览
文档格式如何转换
文档格式如何转换

欢迎大家来到,本文介绍教你文档格式如何转换,欢迎大家观看学习。  Word是Microsoft公司的一个文字处理应用程序。与Word2003相比,Word2007最明显的变化就是取消了传统的菜单操作方式,而代之于各种功能区。在Word2007窗口上方看起来像菜单的名称其实是功能区的名称,当单击这些名称时并不会打开菜单,而是切换到与之相对应的功能区面板。每个功能区根据功能的不同又分为若干个组,每个功能区的所拥有的功能。  总的来说操作方式和2003都差不多,只是工具菜单键排列有了点变化,在就是增加了一些新功能。今天小编为大家带来Word 20007相关视频教程,欢迎大家学习观看。

130 次浏览
word2007中使用导入和导出复制样式
word2007中使用导入和导出复制样式

不通的word文档所包含的样式是不一样的,如果需要将一个文档的样式应用到另一个文档中,可以可以使用word2007的导入和导出样式功能,使样式在不同的文档间实现复制。具体方法如下:第1步,打开word2007文档窗口,在“开始”功能区的“样式”分组中单击显示样式窗口按钮,如图一所示。 图一 点击显示样式窗口按钮第2步,在打开的“样式”窗格中单击“管理样式”按钮,如图二所示。 图二 点击“管理样式”按钮第3步,打开“管理样式”对话框,单击“导入/导出”按钮,如图三所示。 图三 点击“导入/导出”按钮

101 次浏览
如何给word2007中给文档加上背景色
如何给word2007中给文档加上背景色

如果您想让word文档更好看,可以给它加上背景色。背景色是显示于word文档最底层的颜色或图案,它可以丰富word文档的页面显示效果。在Word2007中给文档加上背景色的方法如下:第1步,打开word2007文档,切换到“页面布局”选项卡。第2步,在“页面背景”分组中单击“页面颜色”按钮,并在打开的页面颜色面板中选择“主题颜色”或“标准颜”中的特定颜色,如图一所示。 图一 “页面颜色”面板Tips:如果“主题颜色”和“标准色”中显示的颜色依然无法满足您的需要,可以单击“其他颜色”按钮,在打开的“颜色”对话框中切换到“自定义”选项卡,并选择合适的颜色。设置完毕单击“确定”按钮即可,如图二所示。 图二 “自定义”颜色选项卡

117 次浏览
共计3089条记录 上一页 1.. 269 270 271 272 273 274 275 ..309 下一页