Holiday Preparations for Excel Overachievers

Last year, I posted a link to my Excel Christmas planner, that includes a scheduler for holiday meals.

Despite the rude comments from my Excel buddies (OCD? Torturing guests with pivot tables?), I still use that planner to stay on schedule.

Maybe those doubters go out for their holiday meals, so they don’t have to worry about planning!

Gantt Chart in Holiday Planner
Gantt Chart in Holiday Planner

Black Friday Sales Planner

Even if you don’t have to plan the holiday dinner, you might want to plan your Black Friday shopping trip, or compare gift prices at different stores.

In the latest version of the Excel Christmas Planner there’s a Black Friday worksheet.

Enter Store Names at the top of the table, then enter product info and prices in the rows below.

BlackFridaySales02

Find Best Prices

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.

BlackFridaySales01

With this handy Excel Holiday Shopping worksheet, you’ll know where to start your shopping blitz, so you get the most for your money.

And that’s what the holidays are all about, right? 😉

Happy Thanksgiving!
__________

0 thoughts on “Holiday Preparations for Excel Overachievers”

  1. Wow! I wish I would have had this – so handy! I always thought I was good at planning and getting ahead but – wow! You put me to shame! haha Thanks for the neat idea on the excel sheet!

Leave a Reply

Your email address will not be published.

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