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!
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:
This short video shows how one of the Christmas Tree files work.
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.
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.
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!
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.
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.
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.
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.
There are two versions of this tree, and your can read the details on how the Excel Christmas trees work.
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: December 26, 2020 10:32 AM