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
Contextures Posts
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.
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!
_____________________
__________________________________