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.
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 chance to win an online pivot table course ($199 value)
- 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?
- Tim 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.
- Jon Peltier wrote an epic article that explains everything you need to know about programming charts through events.
- 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.
- Microsoft’s Steve Kraynak explains that spreadsheet management has improved in the new Office 365 search tool.
- Excel or Google? Oz du Soleil shows 3 Excel features that aren’t available in Google spreadsheets.
- Garrett Bugbee offers 6 tips for tidying up your Excel reports.
- Steve gives detailed instructions on how to make an infographic chart in Excel using stacked bar chart, shapes and PowerPoint.
Here are some upcoming events, courses, recently published books, and other new items, related to 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 hereThere 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!
Links to Recent Excel Books on Amazon.com