Tip of the week # 435
21 November 2014


Download your free calendar for 2015 (Excel 2007 onwards)

Have you started making appointments for 2015, but haven't bought a new calendar as yet? Well, there's no need to rush out to the shops. Excel offers lots of calendar templates that you can easily adapt for your specific needs.

Here's how in Excel 2007:

  1. Click on the Microsoft Office button and click on New.
  2. On the left side of the dialog box, underneath Microsoft Office Online, click on Calendars and click on one of the links. (Don't worry that it seems to stop at 2012; you can easily amend the year.)
  3. Follow step 3 and 4 below.

Here's how in Excel 2010:

  1. Click on the File tab and click on New.
  2. Click on Calendars and click on one of the folders. (Don't worry that it seems to stop at 2012; you can easily amend the year.)
  3. Decide which calendar works best for you (if you click on one of the templates, it appears in a larger view on the right hand side of the dialog box) and double-click its name to download it.
  4. Change the year, introduce pictures of your own and modify the font and font size to your heart's content.

By the way, I got a bit carried away when I was writing this tip - using the Small business calendar (any year, Sun-Sat) template in Excel 2010 - so if you want to download a calendar for 2015 with some of my favourite shortcuts for each month on each separate worksheet, have a look at 2015_tip_calendar.xlsx