推荐阅读
OneNote for Android UI界面大改！默认主页Feed时间线
今天重启了下手机，打开几天前更新的OneNote，竟然刚露出新UI……版本号：16.0.13901.20176 (Beta)默认主页Feed时间线
Endnote安装教程及Endnote如何连接word实现基础教程
Endnote安装教程及Endnote如何连接word实现基础教程这俩天安装endnote老是有问题，弄了老长时间。所以就想写个安装步骤，如下安装EndnoteX7首先附上一个网盘链接https://pan.baidu.com/s/1mm1Lb6LsxB-IP1lrFamLUQ1.下载完成后，先解压缩，解压后，双击!)EndNoteX7Portable应用程序，安装。安装完毕后，为了方便，可以将EndNote或EndNote_EN发送至桌面快捷方式。这俩个一个是英文版，一个是中文版。2.之后打开Endnote，选择编辑-输出样式-样式管理器
wps office做封面怎么做？
wps做封面怎么做？我们经常使用Word排版制作公司计划书、营销方案、策划这些文稿的时候，都会制作一张精美的封面，而这些封面内容一般是固定不变的。如果每次制作计划书，都要去制作或复制一张封面进来，那确实是比较麻烦。今天，就来教大家一个不错的技巧，我们只要将封面制作好，再将其保存到Word封面库中，日后我们如果我们要用，随时可以插入调用，非常方便。制作封面1、首先，我们来制作一张封面。插入两个文本框，然后在文本框中输入标题和公司名称，最后进入「绘图工具」-「格式」-「形状样式」，在「形状轮廓」中设为「无轮廓」。2、插入公司LOGO，然后在底部在此插入一个文本框，输入公司联系方式等，这样一张简单的封面就制作完成了。3、制作完封面模板以后，我们就要来将封面存入封面库了。首先，使用快捷键「Ctrl + A」全选，然后「插入」-「页面」-「封面」-「将所选内容保存到封面库」，在弹出的「新建构建基块」中创建一个名称，确定即可保存。4、当我们需要用到封面的时候，直接进入「插入」-「页面」-「封面」，在这里我们就可以看到我们制作保存的封面，直接点击即可快速插入进来。是不是非常方便呢？
Word文件如何在安全模式下启动损坏文件
手动修复损坏的Word文件的方法可能在生活中不常用，但是这也不失为一种方法，在以后的工作中多少会起到作用。操作步骤 单击电脑界面左下角的“开始”按钮，此时会弹出一个菜单，然后在“运行”一栏输入“Winword.exe /safe”后按一下回车键，此时便会启动安全模式，我们在安全模式下打开损坏文件便可。 提示：安全模式启动之后并不能自动打开文件，需要用户手动打开破损的文档。
最新发布
透视表终曲_值字段技巧（一）
Pivot Tables grand finale: Tricks with the Values field透视表终曲：值字段技巧This is going to be the last PivotTable post, at least for a while. Unlike the last several posts, the subject matter that follows applies to any PivotTable, not just those connected to SQL Server Analysis Services.这是本阶段内最后一篇关于透视表的文章了。和前几篇文章不同，本主题相关的应用不只是用于连接到SQL Server Analysis Services的,而是任何透视表。In current versions of Excel, one of the capabilities that exist in PivotTables is the ability to adjust the position of the labels that describe the values in the Values region of the PivotTable (i.e. “Sum of Sales”). Excel PivotTables offer significant flexibility in this area – the labels can be on rows, on columns, and anywhere in the hierarchy on either of those areas. When we visit customers to talk to them about how they use PivotTables, though, we see a couple of things. First, the majority of users aren’t fans of our initial placement of the labels. Second, most people have never figured out that the labels can be repositioned. We have tried to address both of these items in Excel 12.在这个版本的Excel中，透视表的一个功能就是，用于描述透视表（例如"Sum of Sales"）中选定范围内值的标签的位置是可以改变的。这一点上Excel透视表非常的灵活，标签可以被放在行，列，或者那些区域层级的任意位置。当我们去客户那里，告诉他们怎么使用透视表的时候，通常，我们会遇到两种情况。一种是，大多数用户不喜欢标签的初始位置。另一种，多数客户根本不知道这些标签是可以移动位置的。我们已经试着在Excel12中解决这些问题了。This area is probably best explained by walking through an example, so here goes. To start with, imagine you were building the following PivotTable. It has some items on rows and columns, and Sales Amount summarized in the Values area.看一个例子，应该是解释这个问题的最好的方式，所以:),here goes。开始，想象一下你原来做下面这张表的时候。列和行上都有一些项目，后面的计算区域还有销售统计额。If you add a second field to the Values area – say Product Cost – then Excel adds some captions (“Sum of Sales Amount”, “Sum of Product Cost”) below the years (“2003”, “2004”) to help the user distinguish which numbers are Sales and which numbers are Product Cost.
透视表终曲_值字段技巧（二）
If you want to re-position the captions elsewhere, you can simply drag-and-drop the “∑ Values” field to another drop zone or another position in the drop zone that currently contains the “∑ Values” field. Say I wanted to see the labels above the “Year” field in the Column area. All I need to do is start dragging the “∑ Values” field, and I get feedback as to where the field will end up when I am done (blue bar, new cursor).如果您想把标题放到其它地方，您只需拖拽"∑ Values"字段到其它拖放区域或者已含有"∑ Values"字段的拖放区域的别的位置。也就是说当我要查看列区域中"Year"字段上面的标签的时候，我所要做的就是拖动"∑ Values"字段，当我要放下（蓝色边，不一样的鼠标指针）的时候就会看见字段竖起来。If I drag the “∑ Values” field above the “Year” field and let go, the PivotTable will refresh, and the captions will now be outside the year information, showing me a different view of my data. Here is what that looks like.如果我将"∑ Values"字段拖到"Year"字段上放下，透视表就会刷新，并且标题也会显示出年度的信息，显示出来的是一个不同的视图。如下：I can also move the captions to the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field to the bottom of the hierarchy on the Row area.我也可以将标题移动到行上。下面是当我移动"∑ Values"字段到行的底端相应级别时透视表的样子：Further, I can move the captions anywhere else in the hierarchy in the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field in between the Product Name and Product Category fields.而且，我可以在行的同级别里随意移动标题。下面是我将"∑ Values"字段移到Product Name 和Product Category字段中间的样子：By now you are probably getting the idea – the placement of the labels is infinitely flexible, allowing you to see the data pretty much any way you want. Hopefully folks see this as a useful feature. As always, I am interested to hear your feedback.
技巧1_色彩缤纷的Data Bars
Conditional Formatting Trick 1 – Multi-Coloured Data Bars条件格式技巧1——色彩缤纷的Data BarsA few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “data bar” … check out this earlier post for a refresher, but the basic idea is that Excel draws a bar in each cell representing the value of that cell relative to the other cells in the selected range. Here is a shot from that post.几个月以前，我讲述了在Excel 2007中新增加的有关条件格式的各种特性，其中之一就是我们称之为“data bar”的……可参阅以前的文章。但是我们只讲到最基础的概念，即在一个选定的区域里面，由Excel根据不同单元格的数值对比情况，在每个单元格中绘制一个色带。下面是以前文章中的截图：The Excel 2007 UI allows you to choose whatever colour you want for your data bars, but, by default, all the data bars you apply to a range have to be the same colour. Someone on our team recently showed me how to use a tiny bit of VBA to simulate having multiple colours of data bars on a range conditionally applied, so I thought I would pass along the trick.Excel 2007允许你为你的data bars选择任何你想要的颜色，但是，默认情况下，同一区域中的data bars，只能有同一种颜色。最近，开发团队中的某位成员向我展示了如何在同一区域中创建多种颜色的data bars，只需要利用非常简单的VBA代码即可。所以，我想我应该好好发挥这个技巧的威力。Say, for example, you are looking at student grades, and you want all the data bars for students with a passing mark (60%+ and above) to be green, and those with a failing grade (59% or less) to be red. The first thing you would do is to add some red data bars to your data, and then some green data bars. By default, Excel shows you the last set applied, so the data bars would be green. If you then launch the VB Editor (Alt + F11) and in the immediate window (Ctrl+G), type:selection.FormatConditions(1).formula = "=if(c3>59, true, false)"You would see that your data now looks like this, which makes it easy to spot the failing grades.
Excel服务——体系架构
Excel Services – Architecture Excel服务——体系架构Before I continue to drill down on the features of Excel Services, I would like to explain the architecture at a high level and touch on configuration possibilities. 在我继续勾勒Excel服务的特性以前，我想从一个较高的层次解说Excel服务的体系架构。Excel Services is built on the SharePoint products and technologies platform. There are three core components of Excel Services Excel服务是建立在SharePoint产品和技术平台之上，有三个核心组件。Excel Calculation ServiceExcel Web AccessExcel Web Service
数据集函数Part1 概述（二）
What are the new CUBE functions?新增的数据集函数是什么？We have implemented seven new CUBE functions that can be used in Excel formulas just like any other function in Excel. These functions permit Excel to fetch data from SQL Server Analysis Services (2000 & 2005), including any member, set, aggregated value, property, or KPI (Key Performance Indicator) from the OLAP cube. This data can then be placed anywhere in the spreadsheet, intermingled with other local calculations and/or within other formulas. Here are the seven new CUBE functions:我们补充了7个新数据集函数，同其它工作表函数一样，可以在Excel公式中使用。这些函数允许Excel从 SQL Server Analysis Services (2000 & 2005) 提取数据，包括任意成员、子集、汇总值、属性或KPI（关键业绩指标）。这些数据可以放在电子表格的任何地方参与本地计算，或者作为其他公式的一部份参与计算。CUBEMEMBER (connection, member_expression,)This function will fetch the member or tuple defined by the member_expression. For example, (from the illustration above,) the formula: =CUBEMEMBER ("Adventure Works", "[Sales Reason].[On Promotion]") returns the member named “On Promotion” from the “Sales Reason” dimension of the Adventure Works cube.该函数通过定义member_expression（成员表达式）提取成员或成员组。例如，上个实例的公式=CUBEMEMBER ("Adventure Works", "[Sales Reason].[On Promotion]")， 从Adventure Works 数据集的“销售成因”维度返回了一个“促销”成员。CUBEVALUE (connection, [member_expression_1], [member_expression_2], …)This function will fetch the aggregated value from the cube filtered by the various member_expression arguments. For example, the formula: =CUBEVALUE ("Adventure Works","[Measures].[Gross Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[FY 2004]") returns the value $5,035,271.22 which is the aggregated amount in the Adventure Works cube for Gross Profit for Bikes in Fiscal 2004.
介绍Excel服务
Introduction to Excel Services, or “running Excel spreadsheets on a server”介绍Excel服务或者说“在服务器上运行Excel工作簿”Back in September, I posted an article on the big picture which mentioned that we are creating an all-new “Excel Services” server technology as part of our Excel 12 work. Some of you may have caught a glimpse of Excel Services being demonstrated as part of our BI announcement in October. For the next few weeks, I am going to cover the work we have done in this area.在9月, 我张贴了有大图的文章提及我们创造了全新Excel服务器技术作为我们Excel12开发工作的一部分。 你们也许瞥见了Excel服务器作为我们BI 公告一部分 在10月发布。 在今后几星期, 我将报道我们完成的这个部分的工作。What is it?Excel Services is brand new server technology that will ship with Office 12. Excel Services supports loading, calculating, and rendering Excel spreadsheets on servers. There are two primary interfaces: a web-based UI that lets you view spreadsheets in the browser, and a web services interface for programmatic access. I will spend some time on both of these interfaces in future posts. For now, let’s start with an example of the type of work flow that we anticipate will be common using Excel services’ web-based UI. Specifically, let’s look at how a sales analyst would share some work done in Excel with a sales manager.它是什么?Excel服务器是将运用于Office12 的全新的服务器技术。 Excel服务支持装载, 计算, 并且反馈Excel报表在服务器。 有二个主要接口: 让您在基于互联网浏览器的观看报表用户界面；存取列表的网络服务器界面。 在以后的文章中我在这两个接口上将花费一些时间用来介绍。 现在, 让我们用一个工作流程的例子来看看我们期望的基于互联网的Excel用户交流界面。 在下面的例子中, 我们看看在销售管理中销售分析员如何分享Excel上的工作。A sales analyst authors a sales analysis spreadsheet using Excel 12
关于我们在Office中书写代码，另外加上一些抓图
A Small Piece Of Pleasant News For Those Of Us That Write Code In Office, Plus Some More Screenshots … 一小段令人愉快的新闻——关于我们在Office中书写代码，另外加上一些抓图Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically, their mouse scroll wheel (or equivalent) does not work in the code window. I just noticed in recent builds of Office 2007 that it does. I am not sure when, exactly, that was fixed, but I am happy to report that it has been, so there you go. 一些用Microsoft Office中VBA编辑器写VB代码的读者大概注意到了它的历史，他们的鼠标滚轮（或者是中键）不能在代码窗口中使用。我刚才注意到了在最近的Office 2007工程中它已经能用了。我没有把握准确的说是什么时候有了这个改进，但是我很高兴的报告他已经可以了，因为事实已经放在那了。Additionally, I sort of blew it in the last post when I didn’t include any screenshots of a PivotTable with Page Fields (or “Report Filters” as we are calling them in Exel 2007). Since they look sharp, I wanted to redress that. Here are 4 of the PivotTables I showed you last time with Report Filters added. Note that they have lost that “button” look and are now nicely formatted text. 另外，在以前的文章中，我没有加入一些关于数据透视表页字段的截图（或者称之为“Report Filters”正如我们在Exel 2007叫的一样）。由于它们看起来非常专业，所以我希望对这点进行补充。下面是我最近展示给大家的已经添加了Report Filters 的4张数据透视图。注意他们已经失去了看起来像“按钮”的那种界面并且现在可以格式化文本，更加好
Word20007的发展历史视频教程
Word是Microsoft公司的一个文字处理应用程序。与Word2003相比，Word2007最明显的变化就是取消了传统的菜单操作方式，而代之于各种功能区。在Word2007窗口上方看起来像菜单的名称其实是功能区的名称，当单击这些名称时并不会打开菜单，而是切换到与之相对应的功能区面板。每个功能区根据功能的不同又分为若干个组，每个功能区的所拥有的功能。 总的来说操作方式和2003都差不多，只是工具菜单键排列有了点变化，在就是增加了一些新功能。今天小编为大家带来Word 20007相关视频教程，欢迎大家学习观看。
教你如何插入公式
欢迎大家来到，本文介绍教你如何插入公式，欢迎大家观看学习。 Word是Microsoft公司的一个文字处理应用程序。与Word2003相比，Word2007最明显的变化就是取消了传统的菜单操作方式，而代之于各种功能区。在Word2007窗口上方看起来像菜单的名称其实是功能区的名称，当单击这些名称时并不会打开菜单，而是切换到与之相对应的功能区面板。每个功能区根据功能的不同又分为若干个组，每个功能区的所拥有的功能。 总的来说操作方式和2003都差不多，只是工具菜单键排列有了点变化，在就是增加了一些新功能。今天小编为大家带来Word 20007插入公式的相关视频教程，欢迎大家学习观看。
如何使用内置样式集和主题
下文是小编带来的使用内置样式集和主题，美化Word文档的方法，让你在word文档中把文档做的更好、更漂亮。 我们在平时编写文档的过程中，往往只注重文档内容的编写，忽视了文档的美化工作。如何才能告别“白纸黑字”，让我们的文档更加时尚和美观呢?利用Microsoft Office 2007的样式集和主题，您可以快速地为您的文档换装，轻松设计出独具个性的文档。 如果您已经在文档中为各级标题指定了样式，但是又觉得这些标题样式的风格在整体上不是很协调。没有关系，Microsoft Office Word 2007内置了许多经过专业设计的样式集，而每个样式集都包含了一整套可应用于全篇文档的样式设置。您只要选择了某个样式集，其中的样式设置会自动应用于全篇文档。 (1)打开“开始”选项卡，单击“样式”选项组的【更改样式】按钮。 (2)在随即打开的下拉菜单中，将鼠标指针移至“样式集”子菜单项，所有样式集选项会显示在您的面前。 (3)当鼠标指针滑过每个样式集，您就可以直接在文档中预览应用后的效果，当确定要使用某个样式集时，只需单击它即可。 文档主题是一个综合性概念，它涵盖了整篇文档的配色方案、字体方案和效果方案，可以从整体上控制文档的基调或风格。我们可以通过主题改变文档的主题颜色、主题字体和主题效果。我们还可以自定义主题并将其保存。保存自定义的主题后，它将出现在自定义主题的列表中，可用于所有的Word、Excel和PowerPoint程序。设置文档主题的步骤如下： (1)打开“页面布局”选项卡，单击“主题”选项组中的【主题】按钮，打开主题库。 (2)“主题库”以图示的方式列出了所有内置的文档主题，您可以在这些主题之间滑动鼠标，通过实时预览功能来试用每个主题的应用效果。 (3)单击一个符合您要求的主题，完成文档主题的设置。这时，文档中的字体、颜色、效果都会随主题发生变化。