excel组合汇总_Excel汇总20151026

excel组合汇总

In this week's roundup, combine data, select multiple items, power query tips, better reports, and much more.

在本周的综述中，结合数据，选择多个项目，提供强大的查询技巧，更好的报告等等。

1.具有下拉列表的多项选择 (1. Multiple Selections with Drop Down List)

If you select an item from a data validation drop down list, it replaces any existing data in the cell. If you'd like to add more items to the cell, instead of replacing the current text, you can use a bit of programming to allow that. You can download my Multi-Select Drop Down sample file, to see how this works, and I've added new code, to prevent a problem that occurs when you try to type an item in the cell.

如果从数据验证下拉列表中选择一项，则它将替换单元格中的所有现有数据。 如果您想向单元格中添加更多项，而不是替换当前文本，则可以使用一些编程来实现这一点。 您可以下载我的Multi-Select Drop Down示例文件 ，以查看其工作方式，并且添加了新代码，以防止尝试在单元格中键入项目时发生问题。

2.在Excel中合并数据 (2. Combine Data in Excel)

If you're combining data to build a dashboard, Mynda Treacy is offering free one-hour Excel Dashboard webinars this week. Get the details, and sign up for a date and time that is convenient for you. The webinars won't be offered again for a few months, so don't miss them!

如果您要合并数据以构建仪表板，则Mynda Treacy本周将提供免费的一小时Excel Dashboard网络研讨会 。 获取详细信息，并注册一个方便的日期和时间 。 几个月后将不再提供网络研讨会，因此请不要错过！

Even if you don't have Office 2016 yet, you can use the techniques in the free sample chapter from Curtis Frye's new book, Microsoft Excel 2016 Step by Step. The chapter title is "How to Combine Data from Multiple Sources in Microsoft Excel 2016", and shows how to use workbooks as templates, link to data in other files, and consolidate multiple sets of data. That's how we combined data before we had all the fancy new Power BI tools, and the techniques still work!

即使您还没有Office 2016，也可以使用Curtis Frye的新书 Microsoft Excel 2016 Step by Step中免费示例章节中的技术。 本章标题为“如何在Microsoft Excel 2016中合并来自多个源的数据”，并显示如何将工作簿用作模板，链接到其他文件中的数据以及合并多组数据。 这就是我们在拥有所有精美的新Power BI工具之前合并数据的方法，并且这些技术仍然有效！

3.数据可视化 (3. Data Visualization)

Chandoo announced a quick visualization challenge, with prizes for the top two entries. Download the data file, then visualize the data in one Excel chart, without using any add-ins or VBA. The deadline is Sunday, Nov. 1st, so get going, if you want to enter.

Chandoo宣布了一项快速的可视化挑战赛 ，并为前两名参赛者颁发了奖品。 下载数据文件，然后在一个Excel图表中可视化数据，而无需使用任何外接程序或VBA。 截止日期是11月1日，星期日，如果您想进入，那就开始吧。

For other projects, if you're creating data visualizations in Power BI Designer or Excel Power View, there's a handy summary chart that shows which chart types are available in each tool.

对于其他项目，如果要在Power BI Designer或Excel Power View中创建数据可视化，则有一个方便的摘要图表，显示每个工具中可用的图表类型 。

4.电源查询 (4. Power Query)

Using Power Query, Gil Raviv shows how to transform any nested table into a Pivot Table. This technique is available for everyone using the new Get & Transform section of the Data tab in Excel 2016, or as an Add-in in previous versions of Excel.

Gil Raviv使用Power Query展示了如何将任何嵌套表转换为数据透视表 。 使用Excel 2016中“数据”选项卡新的“获取和转换”部分或在Excel的早期版本中作为外接程序的所有人都可以使用此技术。

Also, the ebook version of the Power Query book, M is for (Data) Monkey, by Ken Puls and Miguel Escobar, is available now. The print version will be released in December.

另外，Ken Puls和Miguel Escobar撰写的Power Query书的电子书版本M代表(Data)Monkey ，它现在可用。 印刷版将于12月发行。

5.如何使用Office 365 ProPlus获取Office 2016 (5. How to Get Office 2016 With Office 365 ProPlus)

Chris Newman couldn't get the Office 2016 download from this Office 365 ProPlus account, and didn't want until February 2016, for the general release date. Fortunately, he learned how to tweak some Admin settings, to get the new version, and he shows how to do that, if you're in the same situation.

克里斯·纽曼(Chris Newman)无法从此Office 365 ProPlus帐户获得Office 2016下载 ，并且直到2016年2月才希望获得正式发布日期。 幸运的是，他学习了如何调整一些Admin设置以获得新版本，并且他展示了如何在相同情况下做到这一点。

6.更好的Excel报告 (6. Better Excel Reports)

Charley Kyd posted five ways to make your Excel reports incredibly popular with the managers at your company. One suggestion is to create small charts and tables for comparing key data -- but make sure the font is big enough to read!

查理·基德(Charley Kyd)发布了五种方法，以使您的Excel报表在公司的经理中大受欢迎 。 一种建议是创建用于比较关键数据的小型图表和表格，但要确保字体足够大以便阅读！

7. Excel幽默 (7. Excel Humour)

Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here's one of my favourite tweets from this week's collection.

最后，对于电子表格的一些幽默，您可以在我的每周推文集中看到人们对Excel 的评价 。 这是本周收藏中我最喜欢的推文之一。

通过电子邮件获取Excel每周新闻 (Get Weekly Excel News By Email)

To get Excel news and tips by email, add your name for the Contextures Excel newsletter.

若要通过电子邮件获取Excel新闻和提示，请为Contextures Excel新闻通讯添加名称。

翻译自: https://contexturesblog.com/archives/2015/10/26/excel-roundup-20151026/

excel组合汇总