The template has 9 worksheets and you can just click on the worksheet name (tab) and go to a specific sheet. In the Home worksheet, you will get started with entering some basic information about the Calendar.
STEP 1A: BASIC SETTINGS
Event Calendar Maker Excel Template – Basic Settings
STEP 1B: SET YOUR NON-BUSINESS DAYS
Event Calendar Maker Excel Template – Weekends
This option allows you to customize the weekends according to your needs. Choose the weekend option. For example, in the image above, all Sundays and Saturdays are considered as weekends. They will be highlighted with red font on the calendar.
Event Calendar Maker Excel Template – Holidays
Enter a list of holidays in the Holidays table. These days will also be considered as non-business days and highlighted in red font.
STEP 1C: SET UP TO 12 EVENT TYPES WITH COLOURS
Event Calendar Maker – Excel Template – Event Types
You can enter your own (up to 300) events that will be displayed on the calendar. You can also categorize them under (up to) 12 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.
STEP 2: ENTER EVENTS
Event Calendar Maker – Excel Template – Events Entry
In the ‘Events’ worksheet, you will enter your events. You can enter up to 300 active events and these events will be highlighted on the calendar.
STEP 2A. Enter Event Name, Event Type, Event Start Date and Event End Date.
STEP 2B. FREQUENCY TYPES
Event Calendar Maker – Excel Template – Frequency Types
Please watch the demo video where all frequency types are explained and shown.
STEP 2C. CHOOSE WEEKDAYS
STEP 2D. Enter N
Event Calendar Maker – Excel Template – N, Non-Business Days, Active Events & Priority
N is applicable for 7 of the 12 frequency types. They are provided below with examples.
Event Calendar Maker – Excel Template – N
Applicable Frequency Types (with examples)
• Every Nth day: Enter 2 as N to create events every 2 days
• Weekly: Enter 2 to create events every 2 weeks
• Monthly: Enter 2 to create events every 2 months
• Nth Wkday of Mth: Enter 2 to create events every 2nd Weekday of Month (Weekday will be chosen in the previous step)
• Every Nth Busn Day: Enter 2 to create events every 2nd Business day
• Nth Busn Day of Mth: Enter 2 to create events on the 2nd Business day of a month
• Nth Busn Day of Week: Enter 2 to create events on 2nd Business Day of a week
STEP 2E. NON-BUSINESS DAYS
STEP 2F. PRIORITY
STEP 2G ACTIVE EVENTS
STEP 2H. ADDITIONAL COLUMNS
STEP 2I. VALIDATION
STEP 3. CHOOSE CALENDAR DESIGN
Yearly: 12 Months in one page, event names are not displayed
Yearly with Events: 12 Months in one page, event names are displayed
Monthly: 12 pages (1 Month in each page), event names are not displayed
Event Calendar Maker – Excel Template – Monthly Design
Monthly with Events: 12 pages (1 Month in each page), up to 5 event names per day are displayed
Event Calendar Maker – Excel Template – Monthly with Events Design
One Month: 1 page where you can choose one month to display
Weekly with Events: Choose any day and you can see the week’s events.
Daily with Events: Choose any day and you can see the day’s events.
Event Calendar Maker – Excel Template – Daily with Events Design