Excel Roundup 20140908

If you have Excel, do you even need any other programs? In this week’s video, David Buchanan, from the Chef’s Resources website, shows how to use an Excel workbook to plan every step in an event, from the idea phase, to prep and ordering, to recipes. I like his description of this process as “mental mise en place” worksheets, to help you organize tasks.

excel event planning http://blog.contextures.com/

To see how it works, you can watch the first 7 minutes of this video, to get the overall concepts. For the step-by-step instructions, watch the full video.

You can download some cooking-related workbook templates from their website too.

Or watch on YouTube: Excel Event Planning for Chefs

Contextures Posts

Here’s what I posted recently:

  • Finally, 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:

  • Annie Cushing made a video to show how to use INDEX, instead of OFFSET for marketing analysis. It’s worth a visit, just to see the cat picture.
  • Summer is almost over, but there are still a few holidays left this year. Glen Feechan explains how to calculate working days, and account for upcoming holidays.

Excel Announcements

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

Beginning Power BI with Excel 2013, by Dan Clark

“Guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter.”


Registration has opened for this year’s ModelOff competition. Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.

  • Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th.
  • The Top 16 finalists will compete in New York in December.

Note: A video starts to play automatically on the ModelOff site – turn off your speakers, if you don’t want to alarm your co-workers.


Microsoft Excel 2013 Functions and Formulas 3rd Ed. by Bernd Held

”In this completely updated edition covering Excel 2013 and previous versions, Microsoft Excel Functions and Formulas 3/e demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. A comprehensive CD-ROM accompanies the book with tips, video tutorials, shortcuts, and ready-made Excel formulas.”


101 Ready-to-Use Excel Formulas by Mike Alexander and Dick Kusleika

”The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.”


Excel 2010 for Health Services Management Statistics by Thomas Quirk and Simone Cummings

”This is the first book to show the capabilities of Microsoft Excel to teach health services management statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical health services management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.”

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