excel组合汇总
In this tutorial, from the Lynda.com website, you can learn 5 helpful Excel keyboard shortcuts, for tasks such as toggling the Ribbon on and off, and showing a print preview.
在Lynda.com网站上的本教程中,您可以学习5个有用的Excel键盘快捷键,以执行诸如打开和关闭功能区以及显示打印预览之类的任务。
I use the mouse, and buttons on the QAT, for most of these commands, but if you're a keyboard person, you might like a couple of these shortcuts. Or did you know all of them already?
对于大多数这些命令,我都使用鼠标和QAT上的按钮,但是如果您是键盘手,则可能需要使用其中一些快捷键。 还是您已经全部认识了?
语境帖子 (Contextures Posts)
Here’s what I posted recently:
这是我最近发布的内容:
You can delete worksheet rows based on a specific Conditional Formatting color
您可以基于特定的条件格式颜色删除工作表行
Give your Excel Pivot Table a makeover so the data is easier to read and understand
对您的Excel 数据透视表进行改头换面,使数据更易于阅读和理解
Robert Lepper sent me his tip for creating a color spectrum with 2-color gradients in a range of cells, and I added it to my Formatting Tips page.
Robert Lepper向我发送了有关在一系列单元格中创建具有2种颜色渐变的色谱的技巧,并将其添加到“格式提示”页面中。
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文章,它们可能对您有用。
Sohail Anwar, posting on Chandoo's blog, shares 8 reasons why you must get better at Excel in 2015.
Miguel Escobar uses Power Query to combine multiple files of different file types.
Miguel Escobar使用Power Query组合了不同文件类型的多个文件 。
Dick Kusleika tries to find the next row in a ListObject when using VBA. It's not as easy as you'd hope.
使用VBA时,Dick Kusleika尝试在ListObject中查找下一行 。 这并不像您希望的那么容易。
Jon Peltier uses a chart's secondary axis to show the current donations as a percentage of a fundraising target.
乔恩·Perl捷(Jon Peltier)使用图表的辅助轴来显示当前捐款(占筹款目标的百分比) 。
Charles Williams explains how Excel handles array expressions and constants in single-cell and multi-cell Excel formulas. He's filling in the gaps in the official documentation. Have a cup or two of coffee, before you dive into this one!
Charles Williams解释了Excel如何处理单单元格和多单元格Excel公式中的数组表达式和常量 。 他填补了官方文件中的空白。 在您深入研究这杯咖啡之前,先喝一杯或两杯咖啡!
Here's a quick Power Pivot tip from Melissa Coates (SQL Chick), so you can see the calculated measures in alphabetical order. That makes it easier to find things in a long list. You can do the same thing for the field list in a regular pivot table.
这是Melissa Coates(SQL Chick)的快速Power Pivot技巧,因此您可以按字母顺序查看计算的度量 。 这使得在长列表中查找内容变得更加容易。 您可以对常规数据透视表中的字段列表执行相同的操作。
Teylyn explains why you need to use True or False in the last argument of a VLOOKUP formula
Teylyn解释了为什么需要在 VLOOKUP公式的最后一个参数中使用True或False
Erika is a freelance writer, and she's very proud of the budget/cashflow spreadsheet that she uses for her business. Nice shirt and mug too!
Erika是一位自由撰稿人, 她为自己的业务所用的预算/现金流电子表格感到非常自豪。 衬衫和杯子也不错!
Excel公告 (Excel Announcements)
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
这是与Excel相关的一些即将发生的事件,课程,最近出版的书籍以及其他新项目。
仪表板课程 (Dashboard Course)
Mynda Treacy has opened registration for her acclaimed Excel Dashboard Course, and you'll get 20% off, if you sign up by January 22nd. I reviewed this excellent dashboard course when it first opened, and just 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月22日之前注册,您将获得20%的折扣 。 最初开设这门出色的仪表板课程时,我就进行了回顾,并在查看了最新版本后才更新了我的评论。 您可以在这里阅读我的详细评论 。 现在,该课程是一项更好的投资,并添加了许多新视频。
Mynda is also offering a free introductory webinar on How to Build Excel Dashboards. Get the details on this one-hour session, and sign up for a date and time that is convenient for you.
Mynda还提供有关如何构建Excel仪表板的免费入门网络研讨会 。 获取此一小时课程的详细信息,并注册一个方便的日期和时间 。
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. Unfortunately, it has nothing to do with bacon, which was my first thought, when I saw the website name, "passbaconference.com".
2015年2月3日-立即注册,以获取即将到来的Business Analytics Conference的免费在线预览 。 将有6场实时网络研讨会,包括由Chandoo(Purna Duggirala)和Avi Singh领导的“ Excel中的生产力革命”。 不幸的是,这与培根无关,这是我第一次看到网站名称“ passbacon ference.com”时想到的。
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. Bookmark this page, for event details and registration: Amsterdam Excel Summit 2015
阿姆斯特丹Excel峰会 ,2015年4月13日至15日。将日历标记为4月13日至15日,这样您就可以参加这个令人惊叹的Excel活动。 去年的峰会取得了巨大的成功,今年的活动即将开始报名。 收藏本页,获取活动详细信息和注册: Amsterdam Excel Summit 2015
分享您的活动和文章 (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/01/19/excel-roundup-20150119/
excel组合汇总