excel组合汇总_Excel汇总20150126

最新推荐文章于 2024-09-15 09:47:04 发布

culiao2169

最新推荐文章于 2024-09-15 09:47:04 发布

阅读量170

点赞数

文章标签： java python 机器学习大数据人工智能

原文链接：https://contexturesblog.com/archives/2015/01/26/excel-roundup-20150126/

版权

excel组合汇总

Here is a short video, by Dennis Taylor from Lynda.com, that shows some keyboard shortcuts for formatting on a worksheet. For example:

这是Lynda.com的Dennis Taylor制作的简短视频，显示了一些在工作表上进行格式化的键盘快捷键。例如：

Ctrl + Shift + - (hyphen) to remove borders in selected cells
Ctrl + Shift +- (连字符)可删除所选单元格中的边框
Ctrl +5 to change text to Strikethrough
Ctrl +5将文本更改为删除线

He also shows how to use the ISFORMULA function, new in Excel 2013, with conditional formatting, to dynamically highlight cells that contain formulas. You can get written instructions for that technique on my website.

他还展示了如何使用具有条件格式的Excel 2013中新增的ISFORMULA函数来动态突出显示包含公式的单元格。您可以在我的网站上获得有关该技术的书面说明。

演示地址

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

Use Microsoft's Power Query add-in to combine data from 2 worksheets
使用Microsoft的Power Query加载项合并2个工作表中的数据

Create a pivot table from data on different sheets
根据不同工作表上的数据创建数据透视表

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文章，它们可能对您有用。

Mary Ann Richardson shows how to use the WORKDAY function to calculate a delivery date..
玛丽·安·理查森(Mary Ann Richardson)演示了如何使用WORKDAY函数来计算交货日期。

Oz du Soleil is tired of people comparing R and Excel, and bashing our favourite spreadsheet.
Oz du Soleil厌倦了人们比较R和Excel并抨击我们最喜欢的电子表格。

XOR LX shows how to sort a list alphabetically, by using formulas.
XOR LX显示了如何使用公式按字母顺序对列表进行排序。

Jordan Goldmeier thinks we make our Excel workbooks more complex than they need to be.
乔丹•戈德迈尔(Jordan Goldmeier)认为，我们使我们的Excel工作簿变得更加复杂。

Power Query was updated in January, and Microsoft's Excel team outlines the improvements that were made..
Power Query在1月份进行了更新，Microsoft的Excel团队概述了所做的改进。

In his latest podcast, Chandoo figures out how to write business logic and rules in Excel formulas.
在最新的播客中，Chandoo指出了如何在Excel公式中编写业务逻辑和规则。

Nitin Mehta created a User Defined Formula to do a lookup to the right or left. You can download the add-in, and look at the code.
Nitin Mehta创建了一个“用户定义的公式”以向右或向左进行查找。您可以下载加载项，然后查看代码。

Ken Puls explains an easy way to reference other Power Query queries, when working on a new query.
Ken Puls解释了在处理新查询时引用其他Power Query查询的简便方法。

Excel公告 (Excel Announcements)

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

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

仪表板课程 (Dashboard Course)

Mynda Treacy is running another session of her acclaimed Excel Dashboard Course, and registration closes January 29th. I reviewed this excellent dashboard course when it first opened, and recently updated my review, after taking a look at the latest version. You can read my detailed review here. The course is an even better investment now, with many new videos added.
Mynda Treacy正在运行她备受赞誉的Excel Dashboard课程的另一期课程， 注册将于1月29日截止。首次开设时，我回顾了这个出色的仪表板课程，并在查看了最新版本后最近更新了我的评论。您可以在这里阅读我的详细评论。现在，该课程是一项更好的投资，并添加了许多新视频。

PASS BA马拉松 (PASS BA Marathon)

Feb. 3, 2015 -- Sign up now, for this free online preview of the upcoming Business Analytics Conference. There will be 6 live webinars, including "Productivity Revolution in Excel", led by Chandoo (Purna Duggirala) and Avi Singh.
2015年2月3日-立即注册，以获取即将到来的Business Analytics Conference的免费在线预览。将有6场实时网络研讨会，包括由Chandoo(Purna Duggirala)和Avi Singh领导的“ 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活动。去年的峰会取得了巨大的成功，今年的活动即将开始报名。现在注册已打开，您可以单击此处进行注册。