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!
This short video shows how some of the Christmas Excel 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.
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!
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.
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.
1) Simple Christmas Tree
First, this simple tree uses conditional formatting to show its lights.
2) Christmas Tree With Scroll Bar
This Christmas tree is fancier, with a scroll bar that adds lights, tinsel, and gifts, as you move the scroll bar marker to the right..
3) Christmas Tree with 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
Get the Christmas Trees
There are three versions of this tree, and you can read the details on how the Excel Christmas trees work.
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.
Last updated: November 16, 2022 3:41 PM