Search Contextures Sites

 

 

Excel -- Christmas Planner

Thanks to Sarah Stoski for contributing to this Christmas Planner, and to Jimmy Peña, who created the Recipe Selector tool.

The workbook has sheets you can use to plan holiday events. Print them and write your notes, or enter data in the worksheets, and use Excel's features to sort and total your lists.

For tips on using the workbook, see the tutorials on Conditional Formatting, Data Validation and Sorting.

Download a zipped Excel Christmas Planner file

 

Sheets include:

 

 
 

Holiday Calendar

Enter the first Sunday date in the workbook, and you can see a 9-week calendar, starting from that date. Then, you can print the calendar, and write your notes on it, or type in the cells, on the Excel worksheet.

Christmas Day is highlighted with a red fill colour, and the first day of each month is highlighted in green.

holiday planner calendar

Dinner Planner

There's a worksheet where you can enter your holiday dinner time, and Excel will calculate the start time for each dinner preparation step. For instructions on this sheet, see the Holiday Dinner Planner page.

Excel Dinner Planer

Recipe Selector

If you're looking for new ideas for holiday dinner recipes, use the Recipe Selector sheet to find recipes, based on the ingredient that you select. For instructions on this sheet, which was created by Jimmy Peña, see the Excel Weekly Meal Planner page.

Excel Dinner Planer

Holiday Budget

To help you stay on budget over the holidays, there's a Holiday Budget worksheet. Enter the estimated amount that you plan to spend on holiday expenses, such as gifts or travel. Then, enter the amount that you've actually spent. You can see the totals at the top and bottom of the worksheet..

Excel Dinner Planer

Holiday Checklists

The Excel Holiday Planner has several checklists to help you plan your shopping, holiday tasks, and party planning. Fill those in, by following the sample data or column headings, or create your own holiday checklists.

  • Holiday Tasks
  • Master Gift List
  • Black Friday Price Comparison
  • Christmas Card List
  • Holiday Wardrobe
  • Holiday Crafts
  • Holiday Music
  • Holiday Movies
  • Holiday Traditions

Download a zipped file:

Excel Christmas Planner for Excel 2007 and Excel 2010

Excel Christmas Planner for Excel 2003 and earlier versions

 

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright ©2011
All rights reserved.

 

Last updated: November 15, 2009 2:24 PM