• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Shop
  • Show Search
Hide Search
Home » How To » How to Setup a Christmas Countdown Calendar in Outlook 2010

How to Setup a Christmas Countdown Calendar in Outlook 2010

November 11, 2014

Did you know that although Outlook 2010 doesn’t directly support creating a countdown calendar, you could create one to count down the days to your Thanksgiving holiday, Christmas, the New Year, or even your birthday? With a little bit of help from Excel 2010, you could easily set this up and in this Outlook 2010 tutorial, I’ll show you the step by step process on how to go about creating a Christmas countdown calendar. You can, of course, apply the same principles to create a countdown for any event of your choosing.

RELATED READING: You could read up how to create an Outlook calendar here if you’re new to Outlook.

How to Create a Christmas Countdown Calendar in Outlook 2010

1. Open up Excel 2010 (you can use other versions of Excel but the steps may vary slightly).

2. Create three columns in your worksheet. Name the first column Start Date, the second column Subject and the third one Category.

3. Enter today’s date in the first row of the Date column. You can press Ctrl+; to do this the short way.

4. Select the cell and drag down the fill handle until you have come down to the day before the date of your countdown. In this case, I will drag down until 24th Dec.

creating-a-countdown-calendar-in-excel-2010

 

5. Scroll down to the last date and in the Subject field, enter a description like 1 days until Christmas. Now go to the previous date and enter 2 days until Christmas. This will create a series for you when you drag it up. Now click and select both cells and drag the fill handle up to complete the countdown series.

christmas-countdown-calendar

 

6. Now in the Category column, enter a name you like. I’m going to say Christmas Countdown. You don’t really need to create a category name, but this will come in handy when you want to delete it. I’m going to drag down the category name right to the end as well.

7. Now save the Excel sheet in the CSV format. I’m saving my sheet as Countdown to Christmas.csv . Close the Excel sheet. If you receive a message from Excel stating that it does not support multiple sheets, ignore it.

8. Now you can import this CSV file into Outlook 2010. Open Outlook.

ALSO READ:  3 Ways to Sync Outlook Calendar With iPhone

9. Select the File tab, click Open and then click Import.

10. In the Import and Export wizard, select Import from another program or file and click Next.

import-and-export-wizard-in-outlook-2010

 

11. In the Select file type to import from box, select Comma Separated Values (Windows) and click Next.

12. In the File to import screen, click Browse, navigate to the folder where you saved your Countdown to Christmas.csv file, select it and click OK. Then click Next.

13. In the Select Destination folder, select the Calendar folder where you want to import the file into and click Next.

14. In the following actions will be performed screen, click Map Custom Fields. In the Map Custom Fields dialog, ensure that the mapping is appropriate. For instance, on the right column, you can see that the Start date in Excel is mapped to the Start date in Outlook. Similarly, the Subject is also mapped correctly. Scroll down to categories and you’ll notice that in Excel you created the title Category but Outlook shows it as Categories.

map-custom-fields

 

15. To map this item correctly, drag Category from the left column and place it over categories on the right column. Click OK.

How to Setup a Christmas Countdown Calendar in Outlook 2010

 

16. Now click Finish to complete the import.

17. Now if you head over to your Calendar you will be able to view your countdown. If you want the countdown to display only to you and not others, you can open up the calendar view, and on the View tab, in the Current View group, click Change View and select List.

 

18. Select the date and on the Home tab, in the Tags group, click private to make it as private. To bulk privatize it, just select all the dates in the list, go to the View tab, and click view Settings. There you click Group by and if you see Recurrence, click Ok. Now just hit the private button and its done in a jiffy.

Downloadable: PDF Copy

How to Create a Christmas Calendar in Outlook 2010

I hope you make use of this Outlook 2010 tutorial to create a cool Christmas Countdown Calendar and enjoy doing it as well.

Tweet4
Share20
WhatsApp
Pin3
Buffer
27 Shares

Filed Under: How To Tagged With: outlook how to

You May Also Like

New Features in Outlook to Power Your Productivity - FE
New Features in Outlook to Power Your Productivity
How to Set Up an All Mail Folder in Outlook to See Mail from All Inboxes - FE
How to Set Up an All Mail Folder in Outlook to See Mail from All Inboxes
How to Secure Your Outlook Data Files with a Password fi
How to Secure Your Outlook Data Files with a Password

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Hottest New Gadgets!

Fast External SSD Gadgets for your Mac - TATFI

4 Fast External SSD Gadgets for your Mac (2021)

Anker Powerhouse 100 - TATFI

Charge Your iPhone, Galaxy, iPad, or MacBook with the Portable Power Bank Anker Powerhouse 100

Logitech Circle View - TATFI

Logitech Circle View – A Great Wired Outdoor Camera for HomeKit Users

Spigen Galaxy S21 Cases - TATFI

Spigen Galaxy S21 Cases is Perfect for New Samsung Smartphone

Samsung Galaxy SmartTag Bluetooth Tracker - TATFI

Find Lost Items with the Samsung Galaxy SmartTag Bluetooth Tracker

Popular Tags

android android apps android games android how to apple chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

TheAppTimes © 2021 // Runs on StudioPress