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.
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
Here’s what I posted recently:
- Pivot tables are awesome, but they have a few problems. I created a list of my top 5 pivot table problems; what would you add?
- My office looks less cluttered, now that I’ve cleared most of the old computer books from my office shelves. Do you keep old manuals too?
- I had problems testing VBA code; occasionally the F8 key didn’t stop at the next line when troubleshooting. A registry change seems to have fixed the problem.
- 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.
- Bill Jelen shares formulas for creating a list of the alphabet, or Roman numerals
- To save time, Sara Silverstein created custom chart templates, with all her favorite settings.
- 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.
- If you import data that has numbers formatted as text, Chandoo shares a quick tip for fixing them.
- Seán Byrne shows that some OneDrive users have been hit by Excel file corruption when editing their workbooks online
- If you like both Excel and geography, take a look at Erik Svensen’s analysis of the Icelandic volcano Vatnajökull activity, using Excel’s Power Map.
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.
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