Use Excel to Plan Christmas

You can mock me if you want to, but every year I use my Excel Christmas planner to keep track of all the things I want to do, over the holiday season.

Holiday Budget sheet in Excel Holiday Planner Workbook
Holiday Budget sheet in Excel Holiday Planner Workbook

Where Are the Gifts?

I make a few tweaks to the planner every year, and in this year’s version there is a column to note where you hid a present, after you’ve brought it home.

That should prevent those Christmas Eve panics, while you try to find everything. Not that I’ve ever gone through that – I’m only thinking of you! 😉

Gift Ideas list in Excel Holiday Planner
Gift Ideas list in Excel Holiday Planner

Black Friday Shopping Plan

This year, the stores are even advertising Black Friday and Cyber Monday sales in Canada, so I’ll be able to use the Black Friday planning sheet, to find a few bargains.

Based on the prices that you enter, the worksheet calculates which store has the best price for each item, and which store has the most deals.

Note: If prices are the same at multiple stores, the first store will be shown in the “Best Price” column.

Price Comparison shopping list in Excel Holiday Planner
Price Comparison shopping list in Excel Holiday Planner

Download the Excel Christmas Planner

To download the file, you can visit the Excel Christmas Planner page on my Contextures website.

Happy Thanksgiving, and good luck finding those awesome Black Friday sales tomorrow and in the Cyber Monday sales!

____________________

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.