excel组合汇总_Excel汇总20141103-CSDN博客

excel组合汇总

Excel汇总20141103 (Excel Roundup 20141103)

Rick Grantham explains what a Monte Carlo Simulation is, and shows how to run one in Excel.

瑞克·格兰瑟姆(Rick Grantham)解释了什么是蒙特卡洛模拟，并展示了如何在Excel中运行模拟。

You can download the sample file from his blog, and watch the video below, to see the steps.

您可以从他的博客下载示例文件，并观看下面的视频以查看步骤。

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

A quick tip to create new workbook based on old one without using Save As
在不使用另存为的基础上，基于旧的工作簿创建新工作簿的快速提示

What scares you about pivot tables? Enter the Pivot table online course giveaway
数据透视表让您感到恐惧吗？进入数据透视表在线课程赠品

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

The first Wednesday in November is International Keyboard Shortcut Day, (proclaimed by Dick Kusleika, from Daily Dose of Excel). Do not use your mouse from 2:30 to 3:30 PM. Will you participate at the Novice, Journeyman or Fanatic level?
11月的第一个星期三是“ 国际键盘快捷键日 ”(由Excel Daily Dose的Dick Kusleika宣布)。请勿在下午2:30到3:30 PM之间使用鼠标。您会参加新手，游侠或狂热者级别的游戏吗？

Dr. Timothy Mayes has posted a new variance/covariance builder add-in for Excel 2010/2013. You can download this free add-in and examine the code.
Timothy Mayes博士发布了Excel 2010/2013的新的方差/协方差生成器加载项。您可以下载此免费加载项并检查代码。

Jon Peltier wrote an epic article that explains everything you need to know about programming charts through events.
乔恩·Perl捷(Jon Peltier)撰写了史诗般的文章，解释了通过事件对图表进行编程所需了解的一切。

Ken Puls shows how he warns users that they will be prompted to enter a Power Query setting, and reminds them which one to select. Showing warnings to users can be useful in other situations too.
肯·普尔斯(Ken Puls)展示了他如何警告用户，将提示他们输入超级查询设置，并提醒他们选择哪个。向用户显示警告在其他情况下也很有用。

Microsoft's Steve Kraynak explains that spreadsheet management has improved in the new Office 365 search tool.
微软的Steve Kraynak解释说，新的Office 365搜索工具改进了电子表格管理。

Excel or Google? Oz du Soleil shows 3 Excel features that aren't available in Google spreadsheets.
Excel还是Google？ Oz du Soleil显示了3个Excel功能，这些功能在Google电子表格中不可用。

Garrett Bugbee offers 6 tips for tidying up your Excel reports.
Garrett Bugbee提供了6条技巧来整理Excel报告。

Steve gives detailed instructions on how to make an infographic chart in Excel using stacked bar chart, shapes and PowerPoint.
Steve提供了有关如何使用堆积的条形图，形状和PowerPoint 在Excel中制作图表图的详细说明。

Excel公告 (Excel Announcements)

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

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


LONDON	Chris Webb is running a one-day Power Query course in London on Nov. 13, 2014. This course is aimed at Excel users and BI professionals who want to learn how to use Power Query to load data into Excel and use it with Power Pivot and the rest of the Power BI stack. The course will include practical exercises, and for attendees to take part they must bring a laptop with Excel 2013 and Power Query installed.

	Advanced Excel Essentials, by Jordan Goldmeier "For Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications…starts from the assumption that you are well-versed in Excel—and builds on your your skills to take them to the advanced level."

	Six Sigma Statistics with Excel and Minitab, 2E by Issa Bass "This practical guide provides the perfect toolbox of theory, illustrations, explanations, exercises, and case studies both in the book and on an affiliated website to show how to use Excel and Minitab in conjunction with Six Sigma for an ideal improvement package. It reviews the quality tools that require Excel and/or Minitab, including measurement system analysis, SPC, the Taguchi method, and process capability

LONDON	Abbot Katz is presenting a series of Excel courses in London on consecutive Monday evenings, November 3-24, at the offices of the Guardian newspaper near the Kings Cross station

	Excel Sumo -- The sporting contest of Microsoft Excel Spreadsheets, Formula and Add-Ins Enter your best Excel solution in the Excel Sumo tournament by Nov 3, 2014. Free registration - read the details here There are four categories of Excel Sumo for your submission (you can choose multiple): Business and Productivity, Lifestyle, Fun and Entertainment, Technical (e.g. VBA, Macros, Data Visualization)


伦敦	克里斯·韦伯(Chris Webb)将于2014年11月13日在伦敦举办为期一天的Power Query课程。本课程面向想要学习如何使用Power Query将数据加载到Excel并将其与Power Pivot和Power BI堆栈的其余部分一起使用的Excel用户和BI专业人员。该课程将包括实践练习，与会人员必须携带一台装有Excel 2013和Power Query的笔记本电脑才能参加。

	乔丹·戈德迈尔(Jordan Goldmeier)撰写的Advanced Excel Essentials “对于希望学习如何提高生产力和开发功能更强大的应用程序的中级或高级excel用户……从您对Excel精通的假设出发，并基于您的技能将其提升到高级水平。”

	Issa Bass 使用Excel和Minitab进行6西格玛统计，2E “该实用指南在书中和相关网站上提供了理想的理论，插图，解释，练习和案例研究工具箱，以展示如何将Excel和Minitab与Six Sigma结合使用以获得理想的改进包。它审查了需要Excel和/或Minitab的质量工具，包括测量系统分析，SPC，田口方法和过程能力

伦敦	住持卡茨(Abbot Katz) 将于11月3日至24日在星期一连续的晚上在伦敦国王十字车站附近的《卫报》办公室提供一系列Excel课程

	Excel Sumo -Microsoft Excel电子表格，公式和加载项的体育竞赛在2014年11月3日之前在Excel Sumo锦标赛中输入您最好的Excel解决方案。免费注册- 在此处阅读详细信息提交的Excel Sumo有四种类别(您可以选择多个类别)：业务和生产力，生活方式，娱乐和娱乐，技术(例如VBA，宏，数据可视化)

分享您的活动和文章 (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活动，请在下面的评论中共享一个链接，并提供简要说明。谢谢！