excel组合汇总_Excel汇总20160314-CSDN博客

excel组合汇总

Happy Pi Day! In this week's roundup, troubleshoot large Excel files, free webinars, reporting tips, and much more.

皮日快乐！在本周的综述中，对大型Excel文件，免费的网络研讨会，报告技巧等进行故障排除。

Excel Roundup http://blog.contextures.com/

1.对大文件进行故障排除 (1. Troubleshoot Large Files)

Last week, I found a file that was much bigger than expected. To troubleshoot, I used my Excel Tools add-in to create a list of the sheets, and show the used range on each sheet. Wow, one sheet had 15.7 million cells in its used range! To fix it, I deleted those rows, and saved the file.

上周，我发现一个比预期大得多的文件。为了进行故障排除，我使用了Excel Tools加载项来创建工作表列表，并在每个工作表上显示使用范围。哇，一张纸在其使用范围内有1570万个电池！为了解决这个问题，我删除了这些行，并保存了文件。

If you don't have a copy of my Excel Tools add-in, there is a macro on my blog that you can copy to your Personal workbook. Then, run it, to see a list of sheet for the active workbook.

如果您没有我的Excel Tools加载项的副本，那么我的博客上会有一个宏，您可以将其复制到您的个人工作簿中。然后，运行它，以查看活动工作簿的工作表列表。

2. Pi日没有派 (2. No Pies on Pi Day)

In honour of Pi Day, the JMP Blog reminds you to cut back on the pie charts. Can you go a whole day without one?

为了纪念Pi Day，JMP Blog提醒您减少饼图。你能整天没有人吗？

3.观看数据洞察峰会 (3. Watch the Data Insights Summit )

If you can't make it to Microsoft's Data Insights Summit next week (March 22-23), there's good news. You can watch live streaming of the sessions, so go here to register for the broadcast.

如果您不能在下周(3月22日至23日)参加Microsoft的Data Insights Summit，那将是个好消息。您可以观看会话的实时流，因此请转到此处注册广播。

4. Excel资源 (4. Excel Resources)

Whether you know a lot about Excel, or just a little, you'll find some great resources in Brad Edgar's list of 27 ways to improve your Excel skills. Did you find a few that were new to you?

无论您是对Excel的了解还是很少，您都可以在Brad Edgar的27种提高Excel技能的方法列表中找到一些有用的资源。您是否发现了一些新手？

5.报告提示 (5. Reporting Tips)

Charley Kyd shares his 5 best practices for Excel reporting strategies. Are you providing information or documentation?

Charley Kyd分享了Excel报表策略的 5种最佳实践。您是否在提供信息或文档？

6. MOD功能 (6. MOD Function)

Mike Alexander uses bacon (of course) to explain the Excel MOD function. With that many kids, he should be buying more bacon!

Mike Alexander使用培根(当然)来解释Excel MOD功能。有那么多孩子，他应该买更多的培根！

7.慢宏 (7. Slow Macros)

Colin Legg was surprised to find that the SpecialCells method was slowing down his macros. He reminds us to turn off EnableEvents if you're using SpecialCells.

Colin Legg惊奇地发现SpecialCells方法正在减慢其宏的速度。他提醒我们，如果您使用的是SpecialCells，请关闭EnableEvents。