excel组合汇总_Excel汇总20150831

excel组合汇总

In this week's roundup, see the results from the last roundup's pivot table survey, build a better dashboard, see some new chart types, and much more.

在本周的综述中，请查看上次综述的数据透视表调查的结果，构建更好的仪表板，查看一些新的图表类型等等​​。

We're almost at the end of our summer schedule now, and the next roundup will be published on Monday, Sept 14th.

现在我们的暑假时间表已经快要结束了，下一次综述将在9月14日星期一发布。

视频：Excel综述20150831 (Video: Excel Roundup 20150831)

Watch this short video, with highlights from the Excel Roundup 20150831. Written details and links are below the video.

观看这段简短的视频，其中包括Excel Roundup 20150831的重点内容。视频下方提供了书面的详细信息和链接。

演示地址

1. Excel数据透视表调查 (1. Excel Pivot Table Survey)

In the August 17th roundup, I asked for your opinion in a short survey, and thank you for all the responses. There were 3 questions:

在8月17日的综述中，我通过简短调查征求了您的意见，并感谢您的所有答复。 有3个问题：

1. Do you use Excel pivot tables?
   您是否使用Excel数据透视表？
2. If you use pivot tables, what is your skill level? From 1 (very low) to 10 (awesome)
   如果使用数据透视表，您的技能水平是多少？ 从1(非常低)到10(超赞)
3. How do you feel about pivot tables?  Scale of 1 (Hate) to 10 (Love)
   您如何看待数据透视表？ 1(恨)至10(爱)的等级

Most of the respondents use pivot tables, but the percentage is likely lower in the overall Excel user population. People who don't use pivot tables were less likely to fill in the survey. Before you look at the results, can you predict the outcome?

大多数受访者使用数据透视表，但在整个Excel用户总数中，该百分比可能会更低。 不使用数据透视表的人填写调查的可能性较小。 在查看结果之前，您可以预测结果吗？

• What was the average skill level?
  平均技能水平是多少？
• What was the average love/hate rating?
  爱情/仇恨的平均评分是多少？

You can see the answers in this interactive workbook, shown below. If you can't see the workbook in your browser, you can download it from my Contextures website. Go to the Sample Files page, and in the Pivot Tables section, look for PT0042 – Results from Pivot Table Survey.

您可以在此交互式工作簿中看到答案，如下所示。 如果在浏览器中看不到该工作簿，则可以从我的Contextures网站下载它。 转到“样本文件”页面，然后在“数据透视表”部分中查找“ PT0042 –数据透视表调查的结果” 。

演示地址

2.工作表导航提示 (2. Worksheet Navigation Tips)

Do you have trouble finding a specific worksheet in a large Excel file? AlexJ shared his worksheet navigations tips, and I added a couple of my own tips. See how to use the navigation arrows, popup sheet list, coloured tabs, and spacers tabs.

您在大型Excel文件中查找特定工作表时遇到麻烦吗？ AlexJ分享了他的工作表导航技巧 ，并且我添加了一些自己的技巧。 了解如何使用导航箭头，弹出工作表列表，彩色标签和间隔标签。

3.在工作表上透视表前10个过滤器 (3. Pivot Table Top 10 Filter on Worksheet)

In a Pivot Table top 10 filter, you can't link to worksheet cells for the settings. However, with a bit of programming, so you can control the filter with worksheet drop downs. Download the sample file to see how it works.

在数据透视表的前10个筛选器中，您无法链接到工作表单元格进行设置。 但是，通过一些编程，您可以通过工作表下拉列表控制过滤器 。 下载示例文件以查看其工作方式。

4. Excel旋涡仪 (4. Excel Spirograph)

5.设计仪表板 (5. Designing a Dashboard)

On her Excel for Educators blog, The Science Goddess shows the steps that she went through, while designing dashboards to show student performance in different grades and subjects, over 4 years. See the different versions that she created, for demographic and achievement data, and the final results. You'll get good ideas for your own dashboards.

在她的Excel for Educators博客上，《科学女神》展示了她所经历的步骤，同时设计了仪表板以显示四年来学生在不同年级和科目的表现。 查看她创建的不同版本 ，以获取人口统计和成就数据以及最终结果。 您将为自己的仪表板获得好主意。

On his blog, Chandoo shows how to show pivot table data in a dashboard, by using the GetPivotData function. I love that function, and you can find more examples and videos on the GetPivotData page on my Contextures website.

Chandoo在他的博客上展示了如何使用GetPivotData函数在仪表板上显示数据透视表数据 。 我喜欢这个功能，您可以在我的Contextures网站上的GetPivotData页面上找到更多示例和视频。

6.新的Excel图表类型 (6. New Excel Chart Types)

On Microsoft's Excel Team blog, you can see three of the new chart types that are in Excel 2016. These are statistical charts – Histogram, Pareto and Box and Whisker. The article explains how each chart type works, with sample data and the resulting chart. There is a link where you can download the Office 2016 preview, and then try the new chart types for yourself.

在Microsoft的Excel Team博客上，您可以看到Excel 2016中的三种新图表类型 。 这些是统计图-直方图，帕累托和Box and Whisker。 本文介绍了每种图表类型的工作方式以及示例数据和结果图表。 有一个链接，您可以在其中下载Office 2016预览，然后亲自尝试新的图表类型。

7. Excel技巧 (7. Excel Tips)

On the Lifehacker blog, I saw a link to this post on 8 Great Tools to Make You an Excel Expert. Most of the tips are okay, but beware of tip #7 – "Control Decimals with the FIXED Function". The result of a FIXED formula is text, not a number, so their value will be zero if you include those cells in a total. You should use Round, or one of the other rounding functions from the Math category, unless you just want the numbers to look pretty, and not use them in any totals.

在Lifehacker博客上，我看到了指向8个使您成为Excel专家的出色工具的链接。 多数技巧都可以，但是要提防技巧7 –“使用FIXED函数控制小数”。 FIXED公式的结果是文本，而不是数字，因此，如果您总共将这些单元格包括在内，则它们的值为零 。 除非您只希望数字看起来很漂亮，并且不以任何总计使用它们，否则应该使用Round或Math类别中的其他舍入函数之一。

REMEMBER: If you want really great Excel tips, get a copy of Bill Jelen's (Mr. Excel) latest book, Mr. Excel XL – The 40 Greatest Excel Tips of All Time. It will be released tomorrow, September 1st.

记住 ：如果您真的想要出色的Excel技巧，请获取比尔·杰伦(Bill Jelen)(Excel先生)最新的书《 Excel XL先生–有史以来最伟大的40条Excel技巧》 。 它将在9月1日明天发布。

8. Excel公告 (8. Excel Announcements)

• John Michaloudis is launching his new Excel podcast this week. To celebrate, John is giving away some awesome Excel courses and add-ins. To participate in the fun, subscribe to the podcast and leave an honest review. Get all the details here.

  John Michaloudis本周将发布他的新Excel播客。 为了庆祝，John赠送了一些很棒的Excel课程和加载项。 要参加这个有趣的活动，请订阅播客并进行诚实的评论。 在这里获取所有详细信息 。

• Register for the free online course – Analyzing and Visualizing Data with Excel – at the Microsoft Virtual Academy. The course has about 2 hours of short, lecture-based videos, along with demos, quizzes, and hands-on labs. (Level – Intermediate/Advanced)

  在Microsoft Virtual Academy上注册免费的在线课程– 使用Excel分析和可视化数据 。 该课程包含约2个小时的基于讲座的简短视频，以及演示，测验和动手实验。 (级别-中级/高级)

• Registration is now open for the 4th Annual Financial Modeling World Championships, which begins Saturday October 17, 2015 . There are two online rounds and the top 16 competitors will be flown to London UK for the ModelOff 2015 Finals. Sign up now, on the registration page.

  现在已经开始报名参加第四届年度金融建模世界锦标赛，该锦标赛将于2015年10月17日星期六开始。 共有两场在线比赛，前16名竞争对手将飞往英国伦敦参加ModelOff 2015决赛。 立即在注册页面上注册 。

9. Excel幽默 (9. 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 的评价 。 这是本周收藏中我最喜欢的推文之一。

翻译自: https://contexturesblog.com/archives/2015/08/31/excel-roundup-20150831/

excel组合汇总