Wednesday, February 5, 2014

Event Calendar Maker

The Event Calendar Maker is an Excel workbook (.xlsx) that you can use to create your own personalized event calendar. 

REQUIREMENTS

You need a copy of Microsoft Excel to open this file. Event Calendar Maker has been tested only in Microsoft Excel 2007, 2010 and 2013 for Windows. It has not been tested in other versions of Excel for Windows or for Mac versions of Excel. 

FEATURES
  • Creates 12-Month calendars instantly 
  • Works with any year after 1900
  • Start your calendar with any month
  • Start the week with any day
  • 6 Calendar designs (4 12-Month designs and 2 Monthly designs)
  • Displays up to 200 of your events
  • Can handle single-day events and multi-day events
  • Can handle recurring events (Weekly, Monthly, Nth Weekday, Last Weekday)
  • Totally 1000 event instances can be tracked (for example, an event which lasts 5 days has 5 instances)
  • Event dates are highlighted on the calendars
  • In 2 of the designs, event names are also displayed on the calendar
  • Categorize your events in up to 10 different event types
  • Each event type can be highlighted with a different colour 
    • Choose from 15 colour choices
  • Customize weekends: chose weekdays that are non-working days or weekends. 
    • They will be highlighted in red font on the calendars
  • Readily printable
  • No Macros; completely built with formulas and conditional formatting.

BUY

You can purchase the template by using the 'Buy Now' button below. You will be redirected by ejunkie.com to PayPal where you can use your credit card or PayPal account to purchase. You can download the file instantly after payment. An e-mail will also be sent to your e-mail address with a link that you can use to download later. You will also receive all future upgrades of this product to your e-mail for free. If there are any questions about the purchase process, please e-mail me at indzara at gmail.

USD $10
Buy Now


HOW TO USE THE TEMPLATE

The template has 8 worksheets and you can just click on the worksheet name (tab) and go to a specific sheet. You may also use the navigation menu on each sheet. In the Home worksheet, you will get started with entering some basic information about the Calendar.

STEP 1A: BASIC SETTINGS

  • Enter the year 
  • Enter the Month
    • Your calendar will have 12 months beginning with the month in that year 
  • Enter the day you would like the week to begin with. You can choose from (MON, TUE, WED, THU, FRI, SAT, SUN)
  • Enter a name for your calendar. This will be displayed on the calendar.

STEP 1B: SET YOUR WEEKENDS

This option allows you to customize the weekends according to your needs. Choose 'WKD' if you would like a specific Nth weekday of a month to be considered as weekend day. For example, in the image above, all Sundays and all second Saturdays are considered as weekends. They will be highlighted with red font on the calendar. If you would like to change, you can delete ‘WKD’ or select ‘NO’. Blanks are also considered as ‘NO’. 

STEP 1C: SET UP TO 10 EVENT TYPES WITH COLOURS


You can enter your own (up to 200) events that will be displayed on the calendar. You can also categorize them under (up to) 10 event types. First, you will enter the names for the Event Type. You can choose a colour for each event type from the list of 15 pre-chosen colours. The color next to the Event type will be used to highlight the corresponding dates on the calendar. 
Here is an example of some event types and colours. 



STEP 2: ENTER EVENTS

In the ‘Events’ worksheet, you will enter your events. You can enter up to 200 events and these events will be highlighted on the calendar. 

Enter the Event Name, Event Start Date and Event Type. By choosing the event type, the dates will be color-coded on the calendar according to what you chose in Step 1C. 
  • If the Event Type is blank or not one of the Event Types listed in the 1C, the event will not be highlighted with colour on the calendars.
  • If you have multiple events on the same day, you will enter them separately. 
  • You can enter events in any order. They do not have to be in chronological order.
  • Leave the Event End Date blank if it’s a single day event. 
SPECIAL CASES
  • Multi-Day Events
    • If event spans multiple days, enter Event End Date. The template will automatically display the event across multiple days on the calendars.
  • Recurring Events
    • If event is recurring, enter Frequency. 
    • Weekly Events are automatically generated between the Event Start Date and Event End Date, beginning with the Event Start Date. If the Event Start Date is a Monday, every Monday between Event Start Date and Event End Date will be highlighted. You need not choose anything in the Weekday column. It will not be considered for weekly events. 
      • In this example, Event Start Date was 4-Feb-2014 and Event End Date was 28-Feb-2014. The calendar will automatically highlight all Tuesdays between the two dates. Tuesday is chosen because 4-Feb-2014 is a Tuesday. 
    • Monthly Events are automatically generated between the Event Start Date and Event End Date, beginning with the Event Start Date. If the Event Start Date is 25th, every 25th between Event Start Date and Event End Date will be highlighted. You need not choose anything in the Weekday column. It will not be considered for Monthly events.
    • Nth Weekday: You can also create events that happen on a specific weekday in a month. If the event is recurring on 4th Friday, you will choose 4th Weekday as Frequency and FRI as Weekday. You should always enter a Weekday if you choose 1st Weekday, 2nd Weekday, 3rd Weekday, 4th Weekday, 5th Weekday or Last Weekday. Otherwise, the event will be an error and will not be displayed. In this example, the first event (Monthly planning meetings) is a recurring event on 1st MON between 10-Jan-2014 and 20-Dec-2014. 
NOTES
You can enter Notes for each event for your reference in the Notes column.

VALIDATION

Events with errors are shown with a red border in the table. Validation field will display 'Error'. 
  • Event Start Date is prior to the Calendar Start
  • Event End Date is after the Calendar End
  • Event Start Date is after the Calendar End
  • Event End Date is before the Event Start Date
  • You selected Frequency as Nth Weekday (1st, 2nd..Last), but Weekday column is blank. 

In the example, the Event End Date is before the Event Start Date, and hence the Validation field says ‘Error’. This event will not be displayed on the calendars. 

STEP3: CHOOSE CALENDAR DESIGN



There are 6 calendar designs to choose from. All the 6 calendars are automatically generated based on your inputs in STEP 1 and STEP 2. In all the 6 calendars, event dates are highlighted with colours. 



  • 12Month_1: Traditional Design, 12 Months in one page, event names are not displayed
  • 12Month_2: Traditional Design, 12 Months in one page, event names are displayed
    • You can also choose from Events or Instances to display. Up to 200 events or first 200 event instances will be displayed. 
  • 12Month_3: Modern Design - Vertical, 12 Months in one page, event names are not displayed
  • 12Month_4: Modern Design - Horizontal, 12 Months in one page, event names are not displayed
  • Monthly_1: Modern Design, 12 Pages (1 Month in each page), event names are not displayed
  • Monthly_2: Traditional Design, 12 Pages (1 Month in each page), event names are displayed for each instance. Up to 5 event instances will be displayed for each day. 


STEP 4: PRINT OR EXPORT

You can go to any of the 6 calendars and print them. They are already setup to be printed. You can also export calendars to PDF documents.



------------------------------------------------------------------------------------------------------------

SPECIAL SCENARIOS 

WHAT IF MULTIPLE EVENTS HAPPEN ON THE SAME DATE
If multiple events are on the same date, the event which started first (earliest Event Start Date) will be used to colour the date on the Calendar designs (except for Monthly_2 design). If there is a tie, the event that is listed first in the Events sheet will be used for colour choice. In the Monthly_2 design, up to 5 events on the same date are listed separately on the calendar and the colour of each event is provided. In this example, on Apr 22, we have two events, Weekly Status Meetings and Freeze.



EVENT FALLING ON A WEEKEND DAY

If an event overlaps with a weekend day, event’s colour will be used and not the red font used for weekends.

------------------------------------------------------------------------------------------------------------

Please note that only the features that are mentioned here are possible in this template. The objective of this template is to provide a simple solution to a very specific need (to create event calendars quickly). Here are some examples of what the template does not do.
  • The template doesn't create any reminders for events. 
  • The template is not integrated with any other software. It's a stand-alone Excel workbook file.
  • There is no data back-up system. You need to save the file and make back-up copies as necessary in your computer. I would recommend that. 

If you are not sure whether this product will suit your needs, please e-mail me at indzara at gmail and I can let you know. If, after purchase, you realize that the product doesn't meet your needs, please e-mail me within 60 days from purchase and the money will be refunded.

Saturday, January 11, 2014

All-Purpose Calendar Maker now for Excel 2007

I wish everyone a happy and peaceful 2014. 

I am glad to inform that the All-Purpose Calendar Maker is now compatible with Excel 2007. Please visit the page and download the latest version which works in Excel 2007, Excel 2010 and Excel 2013 for Windows. The new file replaces the older file. All the features have been retained. I have modified the formulas to make it compatible with Excel 2007. 

Please share your feedback in the comments.


Friday, November 29, 2013

Useful Excel for Beginners - Course

If you are interested in learning Microsoft Excel, you can try my course 'Useful Excel for Beginners'. This course has been developed with beginners in mind. If you have never used Excel before or if you are a beginner level user, you will find the course useful. 

The course includes 89 videos running for 9.5 hours and you can follow along at your own schedule. It covers topics that I believe will get you started with Excel and make you an effective user. 

Download the course's Table of Contents


Please see the brief video (also on YouTube) below for an overview of the course. 



Where to sign up?
For more details about this course, please visit the course page