Contextures

Excel for the Holidays

Use these holiday Excel files for gift lists, budget, dinner plans, event calendar, holiday fun. Thanksgiving, Christmas, and more. Download the free Excel workbooks, and get started!

Excel for the Holidays

Holiday planning can be complicated, so use Excel to help you stay organized. There are lots of free workbooks here on the Contextures website, to help you!

For example:

  • The Holiday planner helps you organize your gift buying, holiday tasks, your Holiday budget, and other activities. Use this Excel file as it is, or add your own lists and sheets, as needed.
  • There's a dinner planner too, and I use it for every holiday meal that we have!
  • For holiday fun, see the Excel Advent calendars, and the Excel Christmas Tree workbooks.

This short video shows how one of the Christmas Tree files work.

Excel Holiday Planner

This Excel Holiday Planner helps you organize your gift list, control your holiday budget, track your spending, manage your To-Do list, and more.

When you open the Holiday Planner workbook, a custom tab (PLAN) appears on the Excel Ribbon, to the right of the Home tab. Click the buttons on the PLAN tab, to go to the sheets in the planner workbook.

custom tab on Excel Ribbon

Get the Holiday Planner

To get started, download the free Excel Holiday Planner workbook. The zipped file is in xlsm format, and contains macros that navigate to the worksheets.

For detailed steps on how to use the workbook, go to the Excel Holiday Planner page.

Holiday Dinner Planner

This Excel Holiday Dinner Planner helps you organize your holiday meal, so everything is cooked and ready to put on the table, at the exact time that you want to eat dinner.

You'll start by selecting your dinner time, then list all the meal items that you plan to serve, and the steps you need to do. Excel will calculate when each dish needs to start cooking!

select dinner time

Get the Holiday Dinner Planner

To get started, download one of the free Excel Holiday Dinner Planner workbook. The zipped file is in xlsm format, and contains macros that navigate to the worksheets.

  1. Basic Planner: Download a copy of the free Excel Holiday Dinner Planner. The zipped file is in xlsx format, and does not contain any macros.
  2. With Recipe Finder: Download a copy of the free Excel Holiday Dinner Planner and Recipe Finder. The zipped file is in xlsmx format, and contains macros and connections for the recipe finder.

For detailed steps on how to use the workbook, go to the Excel Holiday Dinner Planner page.

Excel Advent Calendars

Instead of buying an Advent calendar that's filled with chocolate, use one of these Excel Advent Calendars instead. The "treats" behind each door are little pictures, instead of chocolates. They're not as delicious, but they don't cause cavities!

There are 5 different Excel Advent calendars available. Some of the calendars use macros, like this one. It has a red background, with green shapes as the 24 doors.

A couple of the Excel Advent calendars do NOT have macros, like this one. It has a background image on the worksheet, and numbered cells with green fill colour. When the number is less than or equal to the current date, the number and green fill are removed, thanks to the magic of conditional formatting.

Get the Advent Calendars

Macros: Download the red and green Advent Calendar. It has macros that run when you click the shapes

No Macros: Download the Advent Calendar with background image. Conditional formatting shows the pictures each day.

Go to the Excel Advent Calendars page, to see the details on how they work, and get more Excel Advent calendars.

Excel Christmas Trees

It's fun to make Christmas Trees in Excel, and there are many different ways to do that. This simple tree uses conditional formatting to show its lights. You can download the zipped Excel Christmas tree file, and it doesn't contain any macros.

This Christmas tree is fancier, with a scroll bar that adds lights, tinsel, and gifts.

Get the Christmas Trees

There are two versions of this tree, and your can read the details on how the Excel Christmas trees work.

  1. Scroll Bar: To see how the Excel Scroll Bar Christmas Tree file works, you can download the Excel Scroll Bar sample file. It is in xlsx format, zipped, and does NOT contain any macros.
  2. Spin Button: This tree is similar to the Scroll Bar version, with a few new features, like the Santa picture, shown below. It has a Spin button, instead of a Scroll bar, and a check box to change the light colours. Click here to download the Scroll Bar Christmas Tree sample file. It is in xlsx format, zipped, and does NOT contain any macros.

Excel Holiday Fun

Lots of holidays are celebrated with fireworks, and Excel can do that too! Go to Andy Pope's website, and download his Excel fireworks file, to see how it works. It's based on an xy scatter chart, and you can set the number of rockets, the sparks in each rocket, and the effect of gravity.

Andy also has a sample Excel workbook with scrolling text, so you can combine the workbooks to show Happy New Year, and a fireworks display.

More Pages

Holiday Dinner Planner

Excel Holiday Planner

Excel Advent Calendars

Excel Christmas Tree

 

Get weekly Excel tips from Debra

 

Last updated: July 4, 2021 12:11 PM