Excel汇总20150216

In this video, Bill Jelen (Mr. Excel) and Mike Girvin (ExcelIsFun) show two different ways to insert an apostrophe at the start of a long column of numbers.

在此视频中，Bill Jelen(Excel先生)和Mike Girvin(ExcelIsFun)展示了两种不同的方式来在长数字列的开头插入撇号。

There is an interesting bit of history, starting at the 1:00 mark – Bill shows how that apostrophe, and other characters, affected cell entries in old versions of Lotus 1-2-3.

有一段有趣的历史，从1:00开始-Bill显示了撇号和其他字符如何影响Lotus 1-2-3的旧版本中的单元格条目。

演示地址

Or watch on YouTube: Add Leading Apostrophe to Column of Data

或在YouTube上观看： 将领先的撇号添加到数据列中

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• Hide pivot table subtotals quickly, using a Ribbon command or a macro.

  使用功能区命令或宏快速隐藏数据透视表小计 。

其他Excel文章 (Other Excel Articles)

Here are a few of the Excel articles that I read recently, that you might find useful.

以下是我最近阅读的一些Excel文章，它们可能对您有用。

• Here's another reason to start using Power Query. Gašper Kamenšek shows how to get all the data from a folder.

  这是开始使用Power Query的另一个原因。 GašperKamenšek展示了如何从文件夹中获取所有数据 。

• Jan Karel Pieterse has updated his comprehensive article on working with circular references in Excel.

  Jan Karel Pieterse更新了他有关在Excel中使用循环引用的综合文章。

• In case you missed any of the new features in Office 365, you can check this list of what was added in January 2015.

  如果您错过了Office 365中的任何新功能，则可以检查此2015年1月添加的功能列表。

• If you don't mind clicking though the items one at a time, ComputerWorld UK has 10 free apps to boost your Excel and Word 2013 productivity.

  如果您不介意一次单击一项，那么ComputerWorld UK拥有10个免费应用程序来提高Excel和Word 2013的工作效率 。

• Excel is easier to use if you understand basic math, so your kids might enjoy playing Prodigy, a free online math game. My 7-year-old grandson loves it!

  如果您了解基本数学知识，则使用Excel更容易，因此您的孩子可能会喜欢玩免费的在线数学游戏Prodigy 。 我7岁的孙子喜欢它！

• The Investintech blog shares 9 simple tips for working with Excel data. Of all those tips, I probably use #4 most often. How about you?

  Investintech博客分享了9个使用Excel数据的简单技巧 。 在所有这些技巧中，我可能最常使用＃4。 你呢？

• Jordan Goldmeier is presenting at this year's PASS Business Analytics conference, and has released an hour-long preview webinar for his session – Creating Outstanding Spreadsheet Models.

  乔丹·戈德迈尔(Jordan Goldmeier)在今年的PASS Business Analytics会议上作了演讲，并发布了一个小时的预览网络研讨会，该研讨会的主题为“ 创建出色的电子表格模型” 。

• Here is another use for pivot tables – Susan Wenograd uses them to visualize search query mismatches, for AdWords reports.

  这是数据透视表的另一种用途– Susan Wenograd使用它们来显示 AdWords报告的搜索查询不匹配情况。

Excel公告 (Excel Announcements)

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

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

Excel课程 (Excel Course)

• Chandoo has a new online course – 50 Ways to Analyze Your Data. It is not for beginners though – you should have at least intermediate or higher level Excel skills for this course.

  Chandoo开设了新的在线课程- 分析数据的50种方法 。 但是，它不是针对初学者的–您应该至少具有中级或更高级别的Excel技能。

Excel书籍 (Excel Books)

• • "This is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively.  It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems.  If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you."
    “这是第一本展示了Microsoft Excel有效教授生物和生命科学统计学功能的书。这是针对需要精通Excel解决实际科学问题的学生和从业人员的循序渐进的练习指导。理解统计数据并不是您最适合的选择，对数学的要求不是特别高，或者如果您对计算机保持警惕，这是您的最佳选择。”

  Excel 2013 for Biological and Life Sciences Statistics, (pre-order), by Thomas J Quirk, Meghan Quirk, Howard Horton 

  Excel 2013 for Biological and Life Sciences Statistics (预购)，作者：Thomas J Quirk，Meghan Quirk，Howard Horton

• • "This is learning made easy. Get productive fast with every Office for iPad app–plus OneNote, too! Jump in wherever you need answers–brisk lessons and colorful screen shots show you exactly what to do, step by step."
    “这使学习变得容易。每个Office for iPad应用程序-再加上OneNote，都可以快速提高生产力！跳到您需要答案的地方-敏捷的课程和丰富多彩的屏幕截图逐步向您展示了确切的操作。”

  Microsoft Office for iPad Step by Step, by Joan Lambert

  Joan Lambert撰写的iPad版Microsoft Office逐步指南

• • "Helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge as they walk you step-by-step through each software application's capabilities, while 12 all-new case studies present scenarios and problems common in today's business practice."
    “可帮助您有效地使用Access数据库管理系统和Excel电子表格来分析和解决实际业务问题。六个用户友好的教程将逐步引导您了解每个软件应用程序的功能，从而积累您的实践知识，而十二个全部最新的案例研究提供了当今商业实践中常见的场景和问题。”

  Problem Solving Cases In Microsoft Access and Excel, (pre-order), by  Ellen Monk, Joseph Brady, Gerard S. Cook, Emillio Mendelsohn

  《 Microsoft Access和Excel中的问题解决案例》 (预购)，艾伦·蒙克，约瑟夫·布雷迪，杰拉德·库克，埃米尔里奥·门德尔松

Excel峰会 (Excel Summit)

• Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration will open soon, for this year's event. Registration is now open, and you can click here to register.

  阿姆斯特丹Excel峰会 ，2015年4月13日至15日。将日历标记为4月13日至15日，这样您就可以参加这个令人惊叹的Excel活动。 去年的峰会取得了巨大的成功，今年的活动即将开始报名。 现在注册已打开，您可以单击此处进行注册 。

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

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请告诉我。 谢谢！

翻译自: https://contexturesblog.com/archives/2015/02/16/excel-roundup-20150216/