excel组合汇总_Excel汇总20140929

excel组合汇总

I’ve seen lots of non-spreadsheet items with “Excel” in their names, such as gum, and bowling gloves, and hand dryers.

我见过很多非电子表格项目，它们的名称带有“ Excel”，例如口香糖，保龄球手套和干手机。

However, this is the first time that I’ve seen a product named after a pivot table. Do you think that they help you analyze your data more efficiently? I wonder if they have a women’s version too.

但是，这是我第一次看到以数据透视表命名的产品。 您认为它们可以帮助您更有效地分析数据吗？ 我想知道他们是否也有女性版本。

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• Color data entry cells with conditional formatting, to make them easy to find

  使用条件格式为数据输入单元着色，以使其易于查找

• Use GetPivotData function to pull the total amount from a pivot table on specific sheet

  使用GetPivotData函数从特定工作表上的数据透视表中提取总额

• 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推文集 。

其他Excel文章 (Other Excel Articles)

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

以下是我最近阅读的一些Excel文章，您可能会发现它们很有用：

• Kyle LeFevre would appreciate your input in his keyboard shortcuts survey (it’s done in a Google form)

  Kyle LeFevre非常感谢您在键盘快捷键调查中的输入(通过Google表单完成)

• On the Frankens Team blog, Krisztina Szabó shows how to copy charts based on named formulas to another workbook.

  在Frankens Team博客上，KrisztinaSzabó展示了如何将基于命名公式的图表复制到另一个工作簿。

• Sumit Bansal shares a tip for automatically increasing the tab numbering when you make a copy of a sheet.

  Sumit Bansal提供了一个技巧，可以在复印纸页时自动增加选项卡编号 。

• Microsoft has made it easier for students and teachers to get a free Office 365 license.

  Microsoft使学生和教师更容易获得免费的Office 365许可证 。

• To enhance your dashboard, use the tips from Gašper Kamenšek, to show the Top 5 or Bottom 5 results, by clicking a radio button.

  要增强仪表板 ，请使用GašperKamenšek的提示，通过单击单选按钮显示前5名或后5名结果。

• If you do any programming in Excel, read Jon Acampora’s tips for using the Immediate window.

  如果您在Excel中进行任何编程，请阅读Jon Acampora的使用即时窗口的提示 。

• Tom S, from Microsoft, shares his troubleshooting tips for unsupported features and corruption, in Excel Services and Office Web Apps Server 2013

  来自Microsoft的Tom S在Excel Services和Office Web Apps Server 2013中分享了有关不受支持的功能和损坏的疑难解答提示

• Bill Jelen (Mr. Excel) shows how to look for 3 specific names, in adjacent cells of a lookup table, by using an array formula that I hadn’t seen before. Watch the video from 1:15 to 2:45, if you’re pressed for time.

  Bill Jelen(Excel先生)展示了如何使用我以前从未见过的数组公式在查找表的相邻单元格中查找3个特定名称 。 如果时间紧迫，请观看从1:15到2:45的视频。

Excel公告 (Excel Announcements)

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

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

	Practical Numerical Methods for Chemical Engineers: Using Excel with VBA by Richard A. Davis “This latest 3rd edition continues to expand the breadth of practical numerical methods with over 100 VBA macros for extending Excel's power for engineering & scientific analysis. Engineers & scientists will find the enhanced coverage of computational tools applicable to a variety of problems in their own disciplines.”
	Financial Modeling for Business Owners and Entrepreneurs, by Tom Y. Sawyer. "You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms."
	Excel VBA for Financials, 2-day course led by Excel experts, Jan Karel Pieterse and Tony de Jonker This Dutch course is specifically aimed at the Finance professional. It has no frills, and no technical mumbo-jumbo – just the VBA you need to achieve more success in your daily job. Date: November 19 and December 3, 2014 Location: Utrecht (Netherlands)
	Beginning Power BI with Excel 2013, by Dan Clark "Guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter."
	Registration is open for this year's ModelOff competition. Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York. Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th. The Top 16 finalists will compete in New York in December.

	化学工程师的实用数值方法： Richard A. Davis的VBA与Excel结合使用 “最新的第三版通过100多个VBA宏继续扩展了实用数值方法的广度，以扩展Excel在工程和科学分析中的功能。 工程师和科学家将发现适用于其各自学科中各种问题的计算工具的覆盖面扩大了。”
	Tom Y. Sawyer撰写的《 企业主和企业家的财务建模》 。 “您将学习在Excel中创建运营和财务模型，以定量方式描述公司的运作方式。”
	Excel VBA for Financials ，由Excel专家Jan Karel Pieterse和Tony de Jonker主持的为期2天的课程 此荷兰课程专门针对金融专业人士。 它没有多余的装饰，也没有技术上的庞然大物-只是您需要在日常工作中取得更大成功的VBA。 日期：2014年11月19日和12月3日 所在地：乌得勒支(荷兰)
	用Excel 2013开始Power BI ，作者Dan Clark “指导您逐步完成分析和可视化数据的过程。BI培训专家，有关这些主题的定期演讲者Daniel R. Clark，将通过动手实践来逐步指导您使用各种工具，以巩固您的工作目标。您在每一章中都学到了。”
	今年的ModelOff竞赛现已开放报名。 与来自世界各地的顶尖建模师一起测试您的财务建模技巧。 来自100多个国家/地区的参与者参加了两场在线资格赛，并在纽约举行了现场决赛活动。 第一轮(在线)是10月25日，第二轮(在线)是11月8日。 前16名决赛选手将于12月在纽约竞争。

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

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请在下面的评论中共享一个链接，并提供简要说明。 谢谢！

翻译自: https://contexturesblog.com/archives/2014/09/29/excel-roundup-20140929/

excel组合汇总