excel组合汇总
In a short video, Sara Silverstein shows 6 keyboard shortcuts for formatting numbers in Excel. Do you use any of these?
在短片中,Sara Silverstein显示了6个用于在Excel中格式化数字的键盘快捷键。 您使用其中任何一个吗?
You can see the shortcuts in the video below, or on the Business Inside website.
您可以在下面的视频中或Business Inside网站上看到快捷方式。
语境帖子 (Contextures Posts)
Here’s what I posted recently:
这是我最近发布的内容:
Ignore blank cells when copying and pasting on a worksheet
在工作表上复制和粘贴时忽略空白单元格
Create a simple calculated field in a pivot table
在数据透视表中创建一个简单的计算字段
For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. There is a poll at the end, so please vote for your favourite tweet.
要幽默地窥视其他人对电子表格的看法,请在我的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文章,它们可能对您有用。
Instead of showing all your data in a chart, use Jon Peltier's technique to create variable endpoints for the chart data.
Sumit Bansal builds a one variable data table, in the first part of his series on Data Analysis.
Sumit Bansal在其有关数据分析的系列文章的第一部分中构建了一个可变数据表 。
If you're just getting started with programming, Philip Treacy explains how workbook and worksheet events work.
如果您刚刚开始编程,那么Philip Treacy会解释工作簿和工作表事件的工作方式 。
Chandoo shares a quick tip for opening and saving files faster in Excel 2013.
Chandoo分享了一个快速提示, 可以在Excel 2013中更快地打开和保存文件 。
The Dashboard Spy ask if there is a difference between dashboards and scorecards.
Charles Williams thinks that there are better alternatives to both VLOOKUP and INDEX/MATCH.
Charles Williams认为VLOOKUP和INDEX / MATCH都有更好的替代方法 。
Chris Webb shows how to combine data from multiple Excel files with Power Query, the easy way.
克里斯·韦伯(Chris Webb)展示了如何使用Power Query (一种简单的方法)将多个Excel文件中的数据组合在一起。
And for another Power Query trick, Ken Puls shows how to combine multiple worksheets in Power Query.
对于另一个Power 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相关的一些即将发生的事件,课程,最近出版的书籍以及其他新项目。
| The ModelOff 2014 finalists have been selected, and you can attend the finals: Sunday December 7, 2014 at Microsoft in New York |
ONLINE | Registration is open for Felienne Hermans' MOOC Course -- Data Analysis: Take It to the MAX() "Using video lectures and hands-on exercises, we will teach you cutting-edge techniques and best practices that will boost your data analysis and visualization skills." You can audit this 8-week course for free, and classes start Apr. 6, 2015. |
| Data Analysis in Sport by Peter O'Donoghue and Lucy Holmes "Introduces the fundamental principles of data analysis, explores the most important tools used in data analysis, and offers guidance on the presentation of results...Covers commercial packages for performance and data analysis, including Focus, Sportscode, Dartfish, Prozone, Excel, SPSS and Matlab" |
LONDON | Abbot Katz is presenting the final course in his series of Excel courses in London, at the offices of the Guardian newspaper near the Kings Cross station. Nov 24th -- Grabbing and grooming the numbers |
已选择2014年ModelOff决赛入围者,您可以参加决赛 : 2014年12月7日,星期日,纽约,微软 | |
线上 | Felienne Hermans的MOOC课程现已开放注册- 数据分析:将其带到MAX() “通过视频讲座和动手练习,我们将教给您最先进的技术和最佳实践,以提高您的数据分析和可视化技能。” 您可以免费审核这门为期8周的课程,课程将于2015年4月6日开始。 |
| Peter O'Donoghue和Lucy Holmes 在体育中进行数据分析 “介绍了数据分析的基本原理,探索了数据分析中使用的最重要的工具,并提供了有关结果表示的指导...涵盖了性能和数据分析的商业软件包,包括Focus,Sportscode,Dartfish,Prozone,Excel, SPSS和Matlab” |
伦敦 | 住持卡兹(Abbot Katz)将在伦敦国王十字车站附近的《卫报》办公室展示其在Excel系列课程中的最后一门课程 。 11月24日-抓取和整理数字 |
分享您的活动和文章 (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/2014/11/24/excel-roundup-20141124/
excel组合汇总