Excel Roundup 20141103

Rick Grantham explains what a Monte Carlo Simulation is, and shows how to run one in 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:

  • For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Other Excel Articles

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

  • 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?
  • 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.

Excel Announcements

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

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
excelsumo 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)

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!

Weekly Excel Roundup http://blog.contextures.com/

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.