excel组合汇总_Excel汇总20150706

excel组合汇总

In this week's roundup, create bullet charts, export dashboards, use the Rank feature in pivot tables, and many other Excel tips

在本周的综述中，创建项目符号图，导出仪表板，使用数据透视表中的“排名”功能以及许多其他Excel技巧

We're on our summer schedule now, so the next roundup will be published on Monday, July 20th.

我们现在处于夏季时间表，因此下一次综述将在7月20日星期一发布。

1.上下文帖子 (1. Contextures Posts)

In case you missed them, here are the articles that I posted recently:

如果您错过了它们，这是我最近发布的文章：

• Use the Rank calculation in an Excel pivot table, to make it easier to compare data

  在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.

  要幽默地窥视其他人对电子表格的看法，请在我的Excel Theater博客上阅读最新的Excel推文集 。

2.项目符号图 (2. Bullet Charts)

Jon Peltier has updated and simplified his instructions for creating bullet charts in Excel. If you make other types of complex charts, you can save time with Jon's Excel Charting Utility.

Jon Peltier已更新和简化了他在Excel中创建项目符号图表的说明。 如果您制作其他类型的复杂图表，则可以使用Jon的Excel Charting Utility节省时间。

3.导出仪表板 (3. Export Your Dashboards)

If you ever need to export an Excel dashboard to Work, PowerPoint, PDF, XPS or pictures, download a copy of Robert Mundigl's Dashboard Exporter template. You can export one date range, or several, and save yourself from hours of cutting and pasting.

如果您需要将Excel仪表板导出到Work，PowerPoint，PDF，XPS或图片，请下载Robert Mundigl的Dashboard Exporter模板的副本。 您可以导出一个或多个日期范围，从而节省数小时的剪切和粘贴时间。

4.使用COUNTIF (4. Using COUNTIF)

Alan Murray shows 5 ways to use the COUNTIF function. For example, use it with data validation, to prevent duplicates, or set a conditional formatting rule that highlights items that occur three or more times in a list.

艾伦·默里(Alan Murray)展示了使用COUNTIF函数的5种方法 。 例如，将其与数据验证一起使用，以防止重复，或设置条件格式设置规则以突出显示列表中出现过三次或多次的项目。

5.切片机简介 (5. Introduction to Slicers)

Chandoo wrote a great introduction to Slicers, so if you haven't used that feature yet, or aren't familiar with all the things that Slicers can do, be sure to read it, and download the sample file.

Chandoo对Slicers进行了出色的介绍 ，因此，如果您尚未使用该功能，或者不熟悉Slicers可以做的所有事情，请务必阅读并下载示例文件。

6.公告 (6. Announcements)

• From July 1 - 10, Jan Karel Pieterse is having a summer sale -- get 25% off his Excel utilities – RefTreeAnalyser (easy auditing of formulas) and Excel File Remediation Utility (helps you salvage Excel models with problematic content accumulated during a long editing history)  

  从7月1日至10日， Jan Karel Pieterse将进行一次夏季大减价– 从他的Excel实用工具中获得25％的折扣 -RefTreeAnalyser (可轻松地对公式进行审核)和Excel File Remediation Utility ( Excel文件修复实用工具) (可帮助您修复在长时间编辑过程中累积有问题内容的Excel模型历史)

  To get your 25% discount, use this coupon code:

  要获得25％的折扣，请使用此优惠券代码：

  JKPADS-Summer2015

  JKPADS-2015年夏季

• Power Query experts Ken Puls and Miguel Escobar have opened registration for their next online Power Query training. On August 12th and 13th, you'll have live online training (4 hours per day). Then attend a live online follow-up Q&A session, a week later (Aug. 20). The class size is limited, so register early!

  Power Query专家Ken Puls和Miguel Escobar已为他们的下一次在线Power Query培训开放注册。 8月12日至13日，您将接受实时在线培训(每天4个小时)。 然后，一周后(8月20日)参加实时的在线后续问答环节。 班级人数有限，请尽早报名！

翻译自: https://contexturesblog.com/archives/2015/07/06/excel-roundup-20150706/

excel组合汇总