excel组合汇总_Excel汇总20141201

excel组合汇总

Wow! It's December already – how did that happen? It's Cyber Monday too – a big online shopping day. Did you find any Excel bargains?

哇！ 已经是十二月了-那是怎么发生的？ 也是网络星期一-一个重要的在线购物日。 您找到任何Excel便宜货吗？

To start the countdown to Christmas, Mynda Treacy created an Advent Calendar in Excel. You can download the file, if you'd like a bit of fun while you count the days until Christmas

为了开始圣诞节的倒计时，Mynda Treacy 在Excel中创建了一个出现日历 。 您可以下载文件，如果您希望数一数直到圣诞节的日子过得很开心

You'll have to answer a quiz each day, to open the calendar doors. To get a head start, you can start thinking about the answer to the December 5th question, shown in the screen shot below.

您必须每天回答一个测验，才能打开日历门。 首先，您可以开始思考12月5日问题的答案，如下图所示。

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• To fix data from another region, you can quickly change currency separators with the Text to Columns feature

  要修复来自其他区域的数据，您可以使用“文本转换为列”功能快速更改货币分隔符

• When you group dates in a pivot table, Excel creates extra items in the pivot table filter – see a couple of workarounds for this problem

  当您在数据透视表中对日期进行分组时，Excel 在数据透视表过滤器中创建了额外的项目 –请参见此问题的几种解决方法

• For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. There is a poll at the end, so please vote for your favourite tweet.

  要幽默地窥视其他人对电子表格的看法，请在我的Excel Theater博客上阅读最新的Excel推文集 。 最后有一个民意调查，所以请投票给您最喜欢的推文。

其他Excel文章 (Other Excel Articles)

Here are a few of the Excel articles that I read recently, that you might find useful.

以下是我最近阅读的一些Excel文章，它们可能对您有用。

• At Macworld, Lou Hattersley compares the iPad versions of Microsoft Excel and Apple Numbers. Which app do you think she recommends?

  在Macworld上，Lou Hattersley 比较了iPad版本的Microsoft Excel和Apple Numbers 。 您认为她推荐哪个应用？

• Mu Lin offers 3 guidelines for designing data dashboards. The article focuses on news reports, but the tips can be applied to business dashboards too..

  木林提供3条设计数据仪表板的指南 。 本文着重于新闻报道，但是这些技巧也可以应用于业务仪表板。

• Cells with drop down lists only show an arrow when selected, so Jon Acompora created a workaround, to always show an arrow.

  带有下拉列表的单元格在选中时仅显示箭头 ，因此Jon Acompora创建了一种变通方法，始终显示箭头。

• It's hockey season here in Canada, but Tanner Bell is thinking about baseball, and uses pivot tables to calculate projected standings for the fantasy baseball draft.

  这是加拿大的曲棍球季节，但Tanner Bell正在考虑棒球，并使用数据透视表来计算幻想棒球选秀的预计排名 。

• In part 2 of his series on data analysis, Sumit Bansal explains how to set up a 2-variable data table.

  Sumit Bansal在其有关数据分析的系列文章的第2部分中，介绍了如何建立2变量数据表 。

• Charlotte Utting explains why Excel and R are useful together, and how you can connect them.

  夏洛特·乌廷(Charlotte Utting)解释了为什么Excel和R一起使用很有用 ，以及如何连接它们。

• Hui shows us how to calculate Pi by throwing hot dogs at Excel, and you can download his sample file. Just remember, it's all fun and games until someone loses an eye!

  Hui向我们展示了如何通过在Excel中抛出热狗来计算Pi ，您可以下载他的示例文件。 请记住，这是所有娱乐和游戏，直到有人失去视力！

Excel公告 (Excel Announcements)

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

这是与Excel相关的一些即将发生的事件，课程，最近出版的书籍以及其他新项目。

ONLINE	PowerPivot Pro is offering a free online seminar today, Excel to Power Pivot: Cross the Gap Walkthrough. Date: Today -- Monday, Dec. 1st, 12 noon to 1 PM (Pacific time)
	The ModelOff 2014 finalists have been selected, and you can attend the finals: Sunday December 7, 2014 at Microsoft in New York
ONLINE	Registration is open for Felienne Hermans' MOOC Course -- Data Analysis: Take It to the MAX() "Using video lectures and hands-on exercises, we will teach you cutting-edge techniques and best practices that will boost your data analysis and visualization skills." You can audit this 8-week course for free, and classes start Apr. 6, 2015.
	Data Analysis in Sport by Peter O'Donoghue and Lucy Holmes "Introduces the fundamental principles of data analysis, explores the most important tools used in data analysis, and offers guidance on the presentation of results...Covers commercial packages for performance and data analysis, including Focus, Sportscode, Dartfish, Prozone, Excel, SPSS and Matlab"

线上	PowerPivot Pro今天提供免费的在线研讨会，即Excel to Power Pivot：跨越鸿沟 。 日期：今天-12月1日，星期一，中午12点至下午1点(太平洋时间)
	已选择2014年ModelOff决赛入围者，您可以参加决赛 ： 2014年12月7日，星期日，纽约，微软
线上	Felienne Hermans的MOOC课程现已开放注册- 数据分析：将其带到MAX() “通过视频讲座和动手练习，我们将教给您最先进的技术和最佳实践，以提高您的数据分析和可视化技能。” 您可以免费审核这门为期8周的课程，课程将于2015年4月6日开始。
	Peter O'Donoghue和Lucy Holmes 在体育中进行数据分析 “介绍了数据分析的基本原理，探索了数据分析中使用的最重要的工具，并提供了有关结果表示的指导...涵盖了性能和数据分析的商业软件包，包括Focus，Sportscode，Dartfish，Prozone，Excel， SPSS和Matlab”

分享您的活动和文章 (Share Your Events and Articles)

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请告诉我。 谢谢！

翻译自: https://contexturesblog.com/archives/2014/12/01/excel-roundup-20141201/

excel组合汇总