excel组合汇总
The ModelOff Live Final for the 2013 Financial Modeling World Championships were held last December, in New York City, and Hilary Smart, from London, was the winner.
去年12月,2013年金融建模世界锦标赛的ModelOff Live决赛在纽约举行, 伦敦的希拉里·斯玛特(Hilary Smart)获胜 。
The organizer have just published an infographic about the competition, and you can see the full image on their blog.
组织者刚刚发布了有关比赛的信息图,您可以在其博客上查看完整图像 。
语境帖子 (Contextures Posts)
Here’s what I posted last week:
这是我上周发布的内容:
To find the last item in a list category, you can use a formula with the INDEX and MATCH functions.
要查找列表类别中的最后一项 ,可以将公式与INDEX和MATCH函数一起使用。
In Excel 2010 and later, you can turn repeating item labels on and off in a pivot table
在Excel 2010和更高版本中,您可以在数据透视表中打开和关闭重复项标签
To make your favourite commands easier to use, you can add them to the Quick Access Toolbar. Show the buttons for all workbooks, or just one.
为了使您喜欢的命令更易于使用,可以将它们添加到“快速访问工具栏”中 。 显示所有工作簿或仅一个工作簿的按钮。
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文章,您可能会发现它们很有用:
On Microsoft’s Excel team blog, Jeff Johnson shows 4 ways that you can filter your data, to show only part of the data in a chart.
在Microsoft的Excel团队博客上,杰夫·约翰逊(Jeff Johnson)显示了4种过滤数据的方法,以仅显示图表中的部分数据 。
Ken Puls is in the design stage of a new reporting system for his company. He’d like to know how you start designing software, so leave a comment on his blog post.
On the Daily Dose of Excel blog, Jeff Weir shows how you can add leader lines to non-pie charts, in Excel 2010 and earlier. If you have Excel 2013, this feature is now built-in.
在Excel的Daily Dose博客上,Jeff Weir展示了如何在Excel 2010及更早版本中向非饼图添加引线 。 如果您具有Excel 2013,则现在已内置此功能。
It’s not just Excel that changes its format occasionally, causing compatibility problems with older versions. John Thysell explains the pain of maintaining spreadsheets in OpenOffice / LibreOffice.
不仅仅是Excel会偶尔更改其格式,从而导致与旧版本的兼容性问题。 John Thysell解释了在OpenOffice / LibreOffice 中维护电子表格的痛苦 。
Do you have a favourite Excel book? Chandoo shared his top picks, and you can see other people’s choices in the comments. Add your own list of favourites to the discussion.
你有一本最喜欢的Excel书吗? Chandoo分享了他的首选,您可以在评论中看到其他人的选择。 将您自己的收藏夹列表添加到讨论中。
Mike Alexander shows how to use Power Query to combine data from multiple Excel files into one table. It's an amazing way to clean up your data, and you can see a demo in the End-to-End Power BI webinar (see the 24 Hour PASS Replays link below)
Mike Alexander展示了如何使用Power Query 将来自多个Excel文件的数据组合到一个表中。 这是清理数据的一种了不起的方式,您可以在“端到端Power BI”网络研讨会上观看演示(请参见下面的“ 24小时PASS重放”链接)。
在线课程 (Online Courses)
Last week, there were free Business Analytics courses online, in promotion of the upcoming PASS conference. If you missed them, the replays are available: 24 Hour PASS Replays
上周,在线免费提供了业务分析课程,以促进即将举行的PASS会议。 如果错过了它们,则可以使用以下重播 : 24小时PASS重播
Chandoo has just re-opened his Power Pivot online course, and you can get the course info and registration details here: Power Pivot Course
Chandoo刚刚重新开放了他的Power Pivot在线课程,您可以在这里获取课程信息和注册详细信息: Power Pivot课程
你读了什么? (What Did You Read?)
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below. Please include a brief description, and a link to the article. __________________________________
如果您想在上周阅读其他有趣的Excel文章,请在下面添加评论。 请提供简短说明和文章链接。 __________________________________
翻译自: https://contexturesblog.com/archives/2014/02/10/excel-roundup-20140210/
excel组合汇总