excel组合汇总_Excel汇总20140331-CSDN博客

excel组合汇总

Last week, three Office apps were released for the iPad – Excel, Word and Powerpoint. Have you downloaded any of the apps, and tried using them?

上周，为iPad发布了三个Office应用程序– Excel，Word和Powerpoint。您是否下载了任何应用程序并尝试使用它们？

If you’re not sure whether to download them, you can read Ed Bott’s review of the new apps – he’s quite impressed by them. Bill Jelen (Mr. Excel) also reviewed the Excel app, and you can see his report here. Bill lists what’s in the apps, and what’s missing.

如果您不确定是否要下载它们，则可以阅读Ed Bott 对新应用程序的评论 -他对它们印象深刻。 Bill Jelen(Excel先生)还查看了Excel应用程序，您可以在此处查看他的报告。 Bill列出了应用程序中的内容以及缺少的内容。

In the video below, there is a short interview with Han-Yi Shaw, head of Microsoft’s Office Design Studio. For more details, click here to read the Mashable interview.

在下面的视频中，对Microsoft Office Design Studio的负责人Han-Yi Shaw作了简短的采访。有关更多详细信息，请单击此处阅读Mashable采访。

演示地址

语境帖子 (Contextures Posts)

Here’s what I posted last week:

这是我上周发布的内容：

In one of my files, an image changed size after previewing the worksheet. No idea why it happened, but a simple tweak fixed the problem.
在我的一个文件中，预览工作表后，图像更改了大小。不知道为什么会发生，但是一个简单的调整就解决了这个问题。

You can create two types of formulas in a pivot table – calculated items and calculated fields. See what the differences are, and an example of how to use them.
您可以在数据透视表中创建两种类型的公式-计算项目和计算字段。查看差异是什么，以及如何使用它们的示例。

While working with pivot tables, I ran into the least informative error message that I’ve ever seen in Excel.
使用数据透视表时，我遇到了在Excel中见过的信息最少的错误消息。

Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
最后，要幽默地窥视其他人对Excel的看法，请在我的Excel Theater博客上阅读本周的Excel推文集。

其他Excel文章 (Other Excel Articles)

Here are a few of the Excel articles that I read last week, that you might find useful:

以下是我上周阅读的一些Excel文章，您可能会发现它们很有用：

Jon Peltier shows how to make a specific chart label a different colour, using formulas, instead of programming.
乔恩·Perl捷(Jon Peltier)展示了如何使用公式而不是编程来使特定的图表标签具有不同的颜色。

Sharepoint MVP, John White, warns not to update your Power Query structure after building your data model..
Sharepoint MVP John White警告，构建数据模型后，请勿更新Power Query结构。

Mynda Treacy shows how to plot missing dates in a pivot chart
Mynda Treacy展示了如何在数据透视图中绘制缺失的日期

Chandoo challenged us to solve an Excel problem, and find the products with the maximum change in monthly sales. There were 170 comments, with a wide variety of solutions.
Chandoo要求我们解决Excel问题，并找到月销售额变化最大的产品。有170条评论，提供了多种解决方案。

If you’re a little rusty in statistics, Mike Alexander gives a clear explanation of standard deviation, and the options for calculating it in Excel
如果您对统计数据有些生疏，Mike Alexander会给出标准偏差的清晰说明，以及在Excel中进行计算的选项

Instead of March Madness basketball, David Ringstrom has a battle between your favourite Excel features and functions. It’s down to the Sweet 16 now, so which ones will you vote for?
大卫·林斯特罗姆(David Ringstrom)可以在您最喜欢的Excel功能和特性之间进行斗争，而不是进行三月的疯狂篮球。现在取决于Sweet 16，那么您会投票给哪个？

Excel资源 (Excel Resources)

Here are some upcoming events, courses and new books, related to Excel.

以下是一些与Excel相关的活动，课程和新书。

Registration is open for the Amsterdam Excel Summit. The one-day event runs on May 14, 2014, and features sessions by several Excel MVPs, such as Bill Jelen (Mr. Excel), Ken Puls and Charles Williams. All the sessions are in English, and the limit is 100 participants, so sign up now, if you’re interested.
阿姆斯特丹Excel峰会现已开放注册。为期一天的活动于2014年5月14日开始，由多个Excel MVP(例如Excel先生的Bill Jelen，Ken Puls和Charles Williams)主持。所有课程均使用英语，最多可参加100人，因此，如果您有兴趣，请立即注册。

您读或写了什么？ (What Did You Read or Write?)

If you read or wrote any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email. Please include a brief description, and a link to the article. __________________________________ Screenshot – Excel for iPad

如果您最近想阅读或编写任何其他有趣的Excel文章，并希望与他人分享，请在下面添加评论，或给我发送电子邮件。请提供简短说明和文章链接。 __________________________________屏幕截图– Excel for iPad