excel组合汇总_Excel汇总20141006

excel组合汇总

In this video, Annie Cushing shows how to create a scrolling table, by using the INDEX function and a scroll bar form control. This technique would work nicely in a dashboard, where space is limited.

在此视频中，Annie Cushing演示了如何使用INDEX函数和滚动条表单控件创建滚动表 。 这项技术在空间有限的仪表板中效果很好。

For more dashboard tips, take a look at Mynda Treacy’s Excel Dashboard course which has just opened for registration, until Oct. 23rd. Details are in the Announcements section, below.

有关更多仪表板技巧，请查看Mynda Treacy的Excel Dashboard课程 ，该课程刚刚开放注册，直到10月23日。 详细信息在下面的“ 公告”部分中。

演示地址

Or watch on YouTube: How to Create a Scrolling Table in Excel

或在YouTube上观看： 如何在Excel中创建滚动表

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• After you create a custom Ribbon tab, design and add your own icon to it

  创建自定义功能区选项卡后，设计并向其中添加自己的图标

• You can download my Excel weekly meal planner, which creates a pivot table shopping list, grouped by grocery store section.

  您可以下载我的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推文集 。

其他Excel文章 (Other Excel Articles)

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

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

• Alan Murray shows how to create a battery chart. It's based on a 3-D stacked cylinder, but he shows it without rotation.

  艾伦·默里(Alan Murray)展示了如何创建电池图表 。 它基于3D堆叠圆柱体，但他没有旋转就显示了它。

• Can Excel help your love life? OKcupid founder on big data, Excel tinkering and the results of that for his company.

  Excel可以帮助您的爱情生活吗？ OKcupid创始人，致力于大数据，Excel修补以及其公司的成果。

• For a bit of fun, try creating formulas in the interactive Pizza Party Panic. You have to type in the cell references, but it's an interesting experiment..

  有点有趣，请尝试在交互式Pizza Party Panic中创建公式。 您必须输入单元格引用，但这是一个有趣的实验。

• Abbott Katz had a problem with rounding in pivot table groups, and was able to solve it, with a bit of indirect help from me.

  雅培·卡兹(Abbott Katz) 在数据透视表组中四舍五入时遇到了问题，在我的一些间接帮助下，它得以解决。

• Ken Puls explains how to pull named ranges into Power Query, from the workbook.

  Ken Puls解释了如何从工作簿中将命名范围提取到Power Query中 。

• Dave Bruns, from ExcelJet, show 5 uses for pivot tables that you probably haven't seen before.

  来自ExcelJet的Dave Bruns显示了5种您可能从未见过的数据透视表的用法 。

• Brad Edgar uses options buttons and the CHOOSE function to control the display on a dashboard.

  Brad Edgar使用选项按钮和CHOOSE功能来控制仪表板上的显示 。

Excel公告 (Excel Announcements)

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

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

	Mynda Treacy’s Excel Dashboard course is open for registration, until Oct. 23rd. Save 20% if you sign up by Oct. 16th.  I highly recommend this online course, which has excellent content, and great student support from Mynda.  A new Power Pivot course is available too, and you can get both courses in a bundle. BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products. When you sign up, type DebraD in the Code box, and email me your receipt number.
	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.”
	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)

	Mynda Treacy的Excel Dashboard课程已开放注册，直至10月23日。 如果您在10月16日之前注册，可节省20％ 。 我强烈推荐此在线课程，该课程内容丰富，并获得了Mynda的大力支持。 新的Power Pivot课程也可用，您可以将这两个课程打包在一起。 奖励：如果您通过此链接注册课程，则可以拥有我的任何Contextures产品的副本。 注册后，在代码框中键入DebraD ，然后通过电子邮件将收据编号发送给我 。
	化学工程师的实用数值方法： Richard A. Davis的VBA与Excel结合使用 “最新的第三版通过100多个VBA宏继续扩展了实用数值方法的广度，以扩展Excel在工程和科学分析中的功能。 工程师和科学家将发现适用于其各自学科中各种问题的计算工具的覆盖面扩大了。”
	Excel VBA for Financials ，由Excel专家Jan Karel Pieterse和Tony de Jonker主持的为期2天的课程 此荷兰课程专门针对金融专业人士。 它没有多余的装饰，也没有技术上的庞然大物-只是您需要在日常工作中取得更大成功的VBA。 日期：2014年11月19日和12月3日 所在地：乌得勒支(荷兰)

分享您的活动和文章 (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/10/06/excel-roundup-20141006/

excel组合汇总