推荐阅读
PPT排版技巧
本文 次要 解说了PPT 建造时的PPT排版 本领， 次要分三 部门内容：PPT排版之 规划之美、PPT排版之图形 使用、PPT排版之 详细 设想三 部门。 上面本文将本教程的 次要框架及 报告的内容 形貌 以下， 其他的 部门 各人 本人下载本文 最初的附件的PPT教程 进修。 1、PPT排版之 规划之美 间隔之美、对齐之美、对称之美、留白之美 2、PPT排版之图形 使用线、框、圈、面、色块及图形的 使用如线在 题目栏中的 使用、线在内 题目 设想上的 使用、线在 注释中的 地区 朋分 感化、线在 注释中的 鸿沟 感化、线在 注释中对称和 粉饰 感化、线在图表中的 毗连 感化;框的模块化 感化、框 构成的对齐 结果，很规整、用框 展现 援用 概念或案例、圈的 灵敏 使用，艺术化排版;面 设想出 团体内容页的版面、用色块 展现 差别的模块内容、色块和图形 构成模块 地区 结果、用色块 展现 概念和案例及 装点、色块 设想 题目栏和过渡页与标识及页码等、 具备 通明 结果色块和图形的搭配 结果、色块与图形搭配 使用 构成Win8 气势派头、母色块放上子色块 构成的逻辑 结果; 3、PPT排版之 详细 设想
如何在excel工作簿中查找包含循环引用的单元格
循环引用就是公式中引用了自己所在的单元格，例如在A1单元格中输入如下公式：=A1*B1Excel会弹出一个循环引用警告，提示公式中包含循环引用而无法计算。按ESC键或单击“取消”按钮，公式会返回“0”。同时在状态栏中Excel会显示循环引用的提示。Excel 2003中的循环引用提示：Excel 2007中：如果某个已打开的工作簿中包含循环引用，而当前活动工作表中不包含循环引用，则状态栏中不会显示单元格地址，仅显示“循环”或“循环引用”字样。这时要定位循环引用所在的单元格，可以用下面的方法：Excel 2003：1.单击菜单“视图→工具栏→循环引用”，打开“循环引用”工具栏。2.单击“循环引用”工具栏中的下拉箭头查看循环引用所在的工作簿和工作表。Excel 2007：
excel2010调整列宽的教程
Excel2010中调整列宽是较为常用的操作，具体该如何调整列宽呢?接下来是小编为大家带来的excel2010调整列宽的教程，供大家参考。 excel2010调整列宽的教程： 调整列宽步骤1：打开一篇需要调整的Excel文档，如下图，把鼠标放在C列和D列之间的线上，此时鼠标会变成一个双箭头的图标，拖动鼠标把它调整为合适的列款; 调整列宽步骤2：如果下图所示，需要调整行高，则把鼠标定位在A5和A6中间的线上，当鼠标变为一个双箭头的时候，拖动鼠标调整合适的行高; 调整列宽步骤3：提示：以上的方法在我们日常生活中是最为普遍的，相信广大用户也会使用。
这样在线下载和安装word2007
虽然现在Microsoft Office已经出了更多的新版本，但是也有很多老用户还是心仪这款经典的Microsoft Office 2007，如今系统也不断的更新换代，不少用户在使用最新系统时候不知道如何安装Microsoft Office 2007，那么下面就由小编为大家分享下在线下载和安装word2007的技巧，希望能帮助您。 在线下载和安装word2007的步骤如下： 步骤一：将下载的解压包解压，可看到如下图片。 步骤二：点击文件夹，双击“setup”可看到如下图片。 步骤三：显示“输入您的产品密钥”，将产品密钥：DBXYD-TF477-46YM4-W74MH-6YDQ8输入，点击“继续”可看到如下图片。 步骤四：点击阅读条款后，打扣“我接受此协议的条款”，点击“继续”，可看到如下图片。 步骤五：点击阅读条款后，会显示立即“安装”或者“自定义”安装，根据需要我们选择安装。可看到如下图片。 步骤六：在“自定义”安装里，选择“安装位置”后，点击“立即安装”，可看到如下图片。 步骤七：接着等待安装过程，这个过程大概需要3—5分钟。可看到如下图片。 步骤八：安装完成后出现如下画面，点击关闭。可看到如下图片。
最新发布
数据透视表III—更多可选择、更简洁精美的样式
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 PivotTables easier to read and explore.今天，我介绍一下Excel 12的一些改进，这些改进使得数据透视表更易于阅读与理解。Expand CollapseOne of the nice exploration features of PivotTables is the ability to expand and collapse items in order to view values at different levels of detail. In Excel 12, we have added expand/collapse indicators to the PivotTable to make it easy to discover when there are more details to explore (and to make it obvious that this feature even exists!). The expand indicator is a “+” and the collapse indicator is a “-”.展开折叠数据透视表中一个值得探索的特征就是展开和折叠项目的功能，使用户能够按照不同的明细等级察看数据。在Excel 12 里，我们给数据透视表增加了展开/折叠指示器，让用户很容易就能看出是否含有隐藏的明细数据。这个展开指示器是一个“+”，折叠指示器是一个“-”。Let’s look at an example. In the PivotTable below, I have added three fields to the row area and the sales amount field to the values area. Currently only items of the first field, year, are showing. To display the details below 2001, all I have to do is to click the expand indicator:
VII －条件格式与数据透视表（二）
Let me briefly explain the three options. (Note, we are still working on the wording of the last option. It’s also worth noting that these options are also exposed in the conditional formatting creation and management UI, so you don’t have to rely on the on-object UI.)我简单解释一下这三个选项。（注意，我们还在考虑最后一个选项的措辞。同样，值得注意的是这些选项同样会出现在条件格式创建和管理的用户界面上，因此你不必依赖于该对象上的用户界面。）• Selected cells – this will leave the conditional formatting applied to just the selected cells• All “Sum of Sales Amount” cells – this will apply the conditional formatting to all Sum of Sales Amount cells in the PivotTable, regardless of level, and including subtotals. This will be useful in cases for measures that aren’t sums – if you have an “Average Retention” measure, for instance, all values (including subtotals and grandtotals) will be between 0 and 1 and can be sensibly formatted using a single rule.• All “Sum of Sales Amount” cells with the same fields – this will apply conditional formatting to all Sum of Sales Amount cells at this level in the PivotTable, which excludes subtotals. I suspect this will be the most commonly used.• 所选单元格——仅所选单元格会保留条件格式• 所有“Sum of Sales Amount”单元格——这将应用条件格式到数据透视表里所有的Sum of Sales Amount单元格，不管其层次，并包括小计在内。当这些衡量标准没有加和时，这会很有用——例如，如果你有一个“Average Retention”衡量的话，那么所有的数值（包括小计和总计）都会在0和1之间，并且可以敏感地使用单一规则设置格式。• 所有“Sum of Sales Amount”中具有相同字段的单元格——这将应用条件格式到数据透视表该层次中所有的Sum of Sales Amount单元格上，不包括小计。我觉得这将会最常用的使用In this case, I want to apply the rule to all cells displaying sales for individual bike models and individual years. To do this, I’ll pick: All “Sum of Sales Amount” cells with the same fields. After I have made this selection, the PivotTable will now show the conditional formatting in all cells showing sales for an individual product category and an individual year.
图形－Shapes
One More Great-Looking Documents Post – Shapes又一篇关于“精美文档”的文章——图形A few weeks ago I posted a series of articles about great-looking documents. I have had a few questions about shapes since I wrote those posts, so I thought I would write a quick post on changes to shapes in Excel 2007 (and Office 2007 really – anything I write here applies to all the apps).几周前我发布了关于“精美文档”的一系列文章，在那之后，我收到了一些有关图形的提问，所以我想我要尽快撰写有关于Excel 2007里图形的变化(包括Office 2007，所有我在这里写的都能适用于所有的Office应用)的文章。Much the same way that charts were improved (new great-looking visuals, results-oriented ribbon UI), shapes have been improved as well. Here is a summary of the changes, which fall into a number of categories.我们已经知道，2007版本里面的图表在许多方面进行了改进(如新增漂亮的可视化效果，效果生成向导的用户界面)，同样的，图形方面也进行了与此相似的改进。下面是这些变化的总结，可以分为几种类型。1. New graphics effects and options – like charts, shapes will look a lot better in Excel 2007 … in fact, charts are built using shapes in Excel 2007, so the improvements in shapes and charts in this area are identical. Specifically,· Better shadows· Better gradients
非常酷的状态栏和精美图表
Quick detour – cool things on the status bar and great-looking charts快速入门-非常酷的状态栏和精美图表Today I decided to take a quick break from Excel Services totalk about a few small but useful changes that have been made to the status bar andshow off a few chartsFirst, the status barZoom control – we have added a slider that allows the user to adjust the “zoom” of the document without needing to pop up any windows. When you slide the control, the document resizes as you slide, so you can adjust to just the “zoom” you want before you let go of the slider. You can also click on the + and – buttons to increment or decrement “zoom” by 10% per click. Finally, for those of you that like using the zoom dialog, you can just click on the 100% (which is a button) and it will launch the Zoom dialog.我今天要谈Excel2007中质的突破：1. 小巧变化的状态栏
X 服务器格式，翻译和成员属性
PivotTables X: Server formatting, translations, member properties数据透视表 X：服务器格式，翻译，成员属性In this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing to keep in mind as you read is that since all these are defined in Analysis Services (i.e. on a server), every PivotTable created that pulls data from Analysis Services will get the benefit of these features without the PivotTable author or user needing to do anything.在本文里，我将带领你浏览我们现在在Excel 数据透视表里支持的Analysis Services功能——服务器格式，翻译和成员属性。你在阅读的时候请牢记一件事，因此这些都是在Analysis Services（例如在服务器上）上定义的，从Analysis Services获得的数据而创建的每个数据透视表将会从中获益而不需要数据透视表作者或者用户去做任何事情。Server formattingWhen designing a model in Analysis Services, formatting can be associated with values. Excel PivotTables will display this formatting by default (you can control it in the connection properties dialog for the connection being used by the PivotTable, so if you want to turn off the formatting, you can).服务器格式在Analysis Services设计模型时，设计数据的同时也可以设置格式。Excel数据透视表将会默认地显示这些格式（你可以在连接属性对话框里控制它，因此如果你想要关闭格式的话，你可以做到）Here is an example of a PivotTable displaying number formatting as defined on the server – in this case dollars with two decimals. As you add fields to the Values area of the PivotTable, the formatting is done automatically.
IX 对SQL服务器分析服务的更强大支持（一）
PivotTables 9: Great support for SQL Server Analysis Services数据透视表 9：SQL服务器分析服务的强大支持Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine Analytical Processing) data sources, specifically Microsoft SQL Server Analysis Services models (in addition to its relational database product, SQL Server includes a feature named Analysis Services which provides business intelligence and data mining capabilities). Excel has worked with SQL Server Analysis Services for several versions now, but we have put a lot of time and effort into Excel 12 in order to make it a great front end to SQL Server Analysis Services, especially Microsoft SQL Server 2005 Analysis Services (Microsoft SQL Server 2005 Analysis Services was recently released as part of Microsoft SQL Server 2005 and introduced many new, powerful features for analyzing data … for more information on Analysis Services, please take a look here and here).今天，我将开始我们在数据透视表和OLAP（OnLine Analytical Processing联机分析处理）数据源，特别是Microsoft SQL Server Analysis Services模式（除了它有关的数据库产品之外，SQL Server还包括了一个名叫Analysis Services的功能，它提供业务情报和数据发掘能力）连接方面所作改进的系列文章。Excel已经有好几个版本能和SQL Server Analysis Services协作了，但是，为了使其作为SQL Server Analysis Services的前端能更好的工作，我们仍花了很多时间和精力在Excel 12上，特别是与Microsoft SQL Server 2005 Analysis Services （Microsoft SQL Server 2005 Analysis Services在前不久，作为Microsoft SQL Server 2005的一部分发布了，并且增加了很多新的，强大的数据分析功能……有关Analysis Services的更多详细信息，请看看这里）的协作上。Before I launch into discussing how Excel 12 works with SQL Server Analysis Services, I wanted to summarize what I see as several key benefits to using Analysis Services as a tool for working with business data.在我进入讨论Excel 12如何和SQL Server Analysis Services协作之前，我想总结一下我所认为的使用Analysis Services作为分析业务数据的注意好处。• Friendliness. Business data is typically stored in relational databases optimized for data input or storage and not analysis of that data. Names of columns etc. are typically not intuitive to end users, there are no clear relationships between fields, etc. Analysis Services provides a user-friendly model where you can provide understandable business names, specify relationships between fields (Product Category – Product Subcategory – Product) so that it is possible for business users to design their own reports without help from IT. • 友好：业务数据通常储存于相关的数据库里，这些数据库适于数据输入或者存储，但是不适于数据分析。诸如列名之类的元素对于终端用户不是很直观，字段之间没有清楚的关系，等等。Analysis Services提供了一个用户友好的模型，你可以提供易于理解的业务名称，明确字段（Product Category – Product Subcategory – Product）之间的关系，这样一来，业务用户就可能设置他们自己的报告，不必求助于IT部门了。• Personalization. Analysis Services offers tools for personalizing individual users’ reporting experience by only showing them the data that they care about and have permissions to see; in addition, Analysis Services can translate data into users’ preferred languages.
XI 关键性能指标，动作和名称集（二）
ActionsAnalysis Services models can have “actions” associated with them. Actions allow users exploring data in Analysis Services to react to what they find in their data … executing an action will take the context of the report (the data the user is looking at) and run a different application with the context as input. For example, the PivotTable below is connected to an Analysis Services model that has an action associated with the product category level. If a user right-clicks any item of that level (here we have picked Accessories for example), there is a Server Actions menu with the option to launch a report for Accessories.动作Analysis Services模型可以有一个随带“动作”。动作允许用户当他们在他们的数据里发现什么时相应在Analysis Services里浏览数据……执行动作会使用报告的上下文（用户正在查看的数据），并且使用该上下文作为输入运行一个不同的应用程序。例如，下面的数据透视表连接到Analysis Services模型，该模型有一个产品类别关联的动作。如果用户在该级上任意地方单击右键（例如我们选择Accessories），就会有个Server Actions菜单，带有一个启动Accessories报告的选项。In the example, the action is launching a sales comparison report for Accessories built using SQL Server 2005 Reporting Services. Here is a screenshot of that report in my web browser.在本例中，该动作是使用SQL Server 2005 Reporting Services（报表服务）创建Accessories的销售比较报表。这是在我网页浏览器上的报表截屏。Note that the action can take a wide variety of forms – running ERP applications, navigating to web pages, etc. Here is a link to a tutorial on MSDN. 注意，该动作可以使用各种形式——运行ERP应用程序，浏览到网页，等等。这里有个连接到MSDN的指南。Named Sets
VII －条件格式与数据透视表（一）
PivotTable VII: – Conditional formatting gets even better, or visualizing your data in PivotTables数据透视表VII －条件格式使数据透视表变得更好，数据更形象化In a series of previous articles I introduced the new conditional formatting capabilities in Excel 12 (see here for the whole series of posts). Today I want to add one more article to the series, which is the work we have done to make conditional formatting work really well in Excel PivotTables. This is an area that I love to show people, because the work we have done reduces a formerly-tricky task down to a few clicks.在我之前一系列的文章中，我介绍了Excel 12里面的条件格式。今天，我想在此系列里再增加一篇文章，那就是我们在Excel数据透视表里使用条件格式所作的努力。这是一个我乐意给人们展示的领域，因为我们所作的工作将以前难以完成的任务简化为非常简单的操作。The first point I want to make is that all the features we added around new types of conditional formatting (data bars, colour scales, icon sets, etc.), new rules (top 10, below average, etc.), and new UI are available for use on PivotTables. However, we did not stop there. To provide a great experience with conditional formatting inside PivotTables, we now associate the conditional formatting rules to the structure of the PivotTable instead of to the cells. What this means is that as users work with PivotTables (adding and removing fields, refreshing the data, expanding and collapsing levels, Pivoting fields between rows and columns, grouping fields, etc.), the formatting tracks the cells in the PivotTable appropriately, so the users don’t need to worry about what is happening to the formatting – things just work, and they can focus on analyzing their data instead. Let’s walk through an example.首先一点我需要说明的是，关于条件格式新格式（数据条，颜色比例，图标，等等），新规则（前10，均值之下，等等），以及新用户界面等方面增加的所有特点，在数据透视表里面都是可用的。然而，我们并没有就此满足。为了在数据透视表里面提供一个强大的条件格式体验，我们现在将条件格式的规则与数据透视表联系起来，而不是与单元格了。这意味着当用户操作数据透视表时（添加和删除字段，刷新数据，展开和折叠层次，在行与列之间透视字段，组合字段，等等），格式将恰当地追踪数据透视表里的单元格，因此用户不必担心格式会发生什么变化——照常运转，他们可以侧重于分析他们的数据。我们来看一个例子吧。In the PivotTable below I’m looking at sales for different bike models, and I have arranged my report so that I have a column with sales data for each year. To make it easier to visually compare the sales of various bike models, I want to apply conditional formatting to the sales values. In the same way as I would when conditionally formatting “ordinary” (i.e. non-PivotTable cells), I select some cells containing sales values …在下面的数据透视表里，我在看不同型号自行车的销售情况，我已经做好了我的报告，其中一列是每年的销售数据。我想要将条件格式应用到这些销售数据上，将不同型号自行车销售情况的比较变得形象化。就象设置“普通”（例如，非数据透视表单元格）的条件格式一样，我选择一些包含销售数据的单元格……… and then I use the ribbon to add a Data Bar format which helps users quickly scan their data to compare values and find outliers.
令人耳目一新的Excel 2007文档
Excel 2007 documents – easy on the eyesOne of the themes we focused on with Office 2007 was “great looking documents”. For the next half-dozen articles, I am going to explain what that means for Excel, and some of the cross-application features that users will see in Office 2007. Office 2007中我们集中研究的主题之一是“精美的文档”，接下来的六篇文章将诠释这对Excel来说这意味着什么，并且用户将在Office 2007中看到office应用程序间交互的特点。Way back when we were starting planning for Excel 2007, we talked to a lot of people about the documents they created using Office, and we looked at many, many examples of people’s work. We asked them about what they found difficult, what they would like to see fixed, and what they thought good-looking output looked like. We also looked at many examples of “professional” output, drawn from textbooks, business journals, scientific journals, and professional design firms. During our planning, it became clear that there was still a lot of additional capability that we could add in this area that would benefit all sorts of users, so we set out to really improve Excel’s capabilities in this area in a number of ways. Specifically, we set out to:早在我们开始设计Excel 2007时，我们和许多用户就他们在使用Office创建文档进行了交谈，并且仔细地研究了大量在实际工作中应用的例子。我们询问他们在使用过程中碰到的困难是什么，他们愿意看到固定的样式是什么，他们认为美观的输出是什么样的。我们也从教科书、商业杂志、科技杂志和专业设计公司中研究了一些“专业”输出的例子。在我们设计过程中，需要改进的思路变得清晰了，在这个方面我们仍然能够添加一些额外的功能，使各类用户都能从中受益。于是，我们通过使用多种方法对Excel在这个方面的功能进行改进。具体地讲，我们着手做了以下工作：Address existing limitations in Excel that made it challenging to create modern-looking documents Make formatting documents much faster and simpler Provide professionally-designed content available out-of-the-box Make it easy to see what your work will look like printed as you create it Make it easier to maintain your spreadsheet and update formatting Address some long-standing print-related customer requests Provide some examples of great-looking documents Make it easier to move your content (i.e. charts) to other Office applications (i.e. PowerPoint) without hassle Do this all in a way that is consistent between Word, PowerPoint, and Excel, so that users can apply features from one application in other applications针对Excel存在的局限性进行改进，使其能够创建现代风格的文档。使格式化文档更简便快捷提供专门设计的可利用的且具有独创性的内容容易看到你的工作成果，就像已经打印出来的一样更容易维护电子表格和进行格式更新满足一些长期从事与打印相关的顾客的需求提供一些美观的文档的示例更容易移动你的内容(例如图表)到其它Office应用程序(例如PowerPoint)在Word，PowerPoint和Excel中的所有操作方法都是一致的，因此，用户能够将某个应用程序的特点应用到另一个应用程序中These goals translated in to the following work:我们为实现这些目标做了以下工作：Changing the number of unique colours allowed a single workbook from 56 to 4.3 billion (32-bit colour) (see post here) as well as adding some new visual effects, like gradient fill. Vastly improved charting. This will be covered in more detail in a later series of posts, but you can check out this post for some visuals that should give you an idea. Improvements to Excel’s existing cell styles feature, and the addition of styles for Tables, PivotTables, and Charts (see here and here for information on Table styles and PivotTable styles) “Galleries” of professionally-designed styles (for all the objects previously listed) A new view – Page Layout View – to supplement Normal and Page Break Preview "Live preview" of formatting Click-and-type headers and footers Some print-related features commonly requested by customers“Document Themes” (colour, font, and effect variations that can be shared between Office applications) Updates to Office shapes (think Drawing toolbar) and WordArt ~25 great-looking templates available out-of-the-box增加在工作薄中可显示的颜色数从(原先的)56色到(现在的)43亿(32位色)(见这里)，也添加了一些新的视觉效果，如渐变填充。极大的改进了图表。这将在后面的一系列文章中详细介绍，也可以先从这篇文章中看出一些端倪。改进了Excel中现有的单元格样式特点，添加了条件格式到列表，数据透视表和图表（详细的表格样式信息和数据透视表样式信息见这里和这里）专业的“图表”样式(以前列出的所有的对象)一个新的视图——页面布局视图——补充到了普通视图和分页预览视图中格式的“现场预览”单击即可输入页眉和页脚顾客普遍需要的一些与打印相关的特点
选项卡和模板
Charting III – Tabs and TemplatesIn the previous two charting posts, I wrote about how you can make a professional chart with four simple choices – chart type, chart layout, chart style, and document theme. As useful as we hope that is, we know that some users will want to tweak and control every aspect of their charts. Today I want to walk through the tabs that are available when you are working with a chart and provide an overview of all the capabilities that are exposed in the ribbon. I am also going to briefly cover templates.图表三：选项卡和模板在前两个贴子里,我写了如何通过4个简单步骤创建专业图表：图表类型、图表版式、图表样式、文档主题。希望对你有益。我们知道有些用户想从各个方面来调节图表。今天我想通过ribbon上的图表选项卡来介绍图表设置。我也会简要介绍一下模板。Design TabWhen you are working with a chart, three additional contextual tabs will be available – Design, Layout, and Format. Here is a shot if the Design Tab.设计选项卡当你制作图表时,有三个选项卡可用：设计、样式、格式。下图是设计选项卡。(Click to enlarge)