excel组合汇总_Excel汇总20140714

excel组合汇总

Are you using Power Pivot or any of the other Power BI tools in Excel 2013? If you’re not sure where to start, there is a new series on the Power BI blog, that will help you dive into the new BI and visualization features.

您是否在Excel 2013中使用Power Pivot或任何其他Power BI工具？ 如果您不确定从哪里开始，那么Power BI博客上会有一个新系列，可以帮助您深入了解新的BI和可视化功能。

The series outline is here, and it will have links to all the articles, as they are added to the blog. The first article is Getting Started with Power Query – Part 1, and it features the 15-minute video shown below. You’ll need Excel 2013, and the article has a link to download the Power Query add-in.

该系列的大纲在此处 ，并且将包含所有文章的链接，这些文章已添加到​​博客中。 第一篇文章是《 Power Query入门–第1部分》 ，其中包含以下15分钟的视频。 您将需要Excel 2013，并且该文章具有下载Power Query加载项的链接。

演示地址

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• Automatically add new items to a drop down list -- the macro asks if you want to add the new item, then sorts the list in alphabetical order

  自动将新项目添加到下拉列表中 -宏询问您是否要添加新项目，然后按字母顺序对列表进行排序

• Hide zero items in a pivot table, and allow multiple filters per field

  在数据透视表中隐藏零项，并允许每个字段使用多个过滤器

• Enter a number in the input box, and that amount is added to each cell in the selected range, with this macro. I use this to add a week, to a  group  of date cells.

  在输入框中输入一个数字，然后使用该宏将该数字添加到所选范围内的每个单元格中。 我用它来向一组日期单元格添加一个星期。

• I sent out an update for my PivotPower Premium add-in last week. If you missed the email, or didn’t open it before the deadline, please let me know and I’ll send you a new link. You can read about the new features on my Pivot Table blog.

  上周，我发送了有关PivotPower Premium加载项的更新。 如果您错过了电子邮件，或者在截止日期之前没有打开电子邮件，请告诉我，我会给您发送一个新链接。 您可以在数据透视表博客上阅读有关新功能的信息。

• Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

  最后，要幽默地窥视其他人对电子表格的看法，请在我的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文章，您可能会发现它们很有用：

• Do you agree with these 10 common spreadsheet mistakes? I'm not even sure what some of them mean!

  您是否同意这10个常见的电子表格错误 ？ 我什至不知道其中一些是什么意思！

• Dick Kusleika finished his 5-part series on converting Numbers to Words in Excel VBA.

  Dick Kusleika完成了他在Excel VBA 中将数字转换为单词的 5部分系列文章。

• On Microsoft’s MSDN Blog, Eric Ligman shared a list of free ebooks, including Excel shortcuts and quick start guide.

  在Microsoft的MSDN博客上，埃里克·利格曼(Eric Ligman)分享了免费电子书的列表 ，其中包括Excel快捷方式和快速入门指南。

• Chandoo announced the winners of his state migration dashboard contest. He said the winner, Roberto Mensa, was Messi, but apparently that's a compliment. 😉

  Chandoo宣布了他的州迁移仪表板竞赛的获胜者。 他说赢家罗伯托·门萨(Roberto Mensa)是梅西(Messi)，但这显然是一种赞美。 😉

• The FrankensTeam has created another interesting chart in Excel, and you can download the sample file. It’s based on a vintage chart that shows occupational distribution.

  FrankensTeam在Excel中创建了另一个有趣的图表，您可以下载示例文件。 它基于显示职业分布的老式图表 。

• Scott Lyerly shows how to use VBA And ADO To Change Data to SharePoint Lists.

  Scott Lyerly展示了如何使用VBA和ADO将数据更改为SharePoint列表 。

• Bill Jelen wrote a macro to copy the Status Bar statistics to the clipboard. Then, select a blank range and press Ctrl+V to paste the stats to the worksheet.

  Bill Jelen编写了一个宏， 将状态栏统计信息复制到剪贴板 。 然后，选择一个空白范围，然后按Ctrl + V将统计信息粘贴到工作表中。

Excel公告 (Excel Announcements)

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

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

• Mynda Treacy’s Excel Dashboard course is open for registration, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Save 20% if you sign up by July 24th. Registration closes on July 31st.

  Mynda Treacy的Excel Dashboard课程已开放接受注册，我强烈推荐此在线课程，该课程内容丰富，并得到Mynda的大力支持。 如果您在7月24日之前注册，可节省20％ 。 注册将于7月31日截止。

  BONUS: If you sign up for the course through this link, you can have a copy of any

  奖励：如果您通过此链接注册课程，则可以拥有任何内容的副本

  one of my Contextures Products. When you sign up, type DebraD in the Referral Code box (below the Buy Now button), and email me your receipt number.

  我的Contextures产品之一 。 注册后，在“推荐代码”框中(在“立即购买”按钮下方)键入DebraD ，然后通过电子邮件将收据编号发送给我 。

• Charles Williams has released a new version his add-in, FastExcel V3, and you’ll get 50% off the bundle price, if you use Coupon Code FXLV3Intro Warning: The 50% Discount ends soon -- July 31 2014. Don’t miss the deadline!

  查尔斯·威廉斯发布了一个新版本，他的加载项， FastExcel V3 ，你会得到50％的折扣捆绑价格，如果您使用优惠券代码FXLV3Intro警告：50％ 优惠期即将结束 - 7月31日2014年不错过最后期限！

• Jon Peltier’s new Advanced Charting Utility for Mac Excel was just released (the Windows version is also available)

  Jon Peltier的Mac Excel新的高级制图实用程序刚刚发布(也提供Windows版本)

Excel Tables: A Complete Guide (pdf version) by Zack Barresse and Kevin Jones ”The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource. “

Excel表格：完整指南 (pdf版本) Zack Barresse和Kevin Jones ”这本书首先说明了什么是表，如何创建它们以及如何将它们用于报告中，然后再介绍一些更高级的主题，包括切片器和筛选，使用VBA宏以及在Excel Web应用程序中使用表。 Excel的新手和专家都将在这种独一无二的资源中找到相关，有用和权威的信息。 “

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

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请在下面的评论中共享一个链接，并提供简要说明。 谢谢！

翻译自: https://contexturesblog.com/archives/2014/07/14/excel-roundup-20140714/

excel组合汇总