DESCRIPTION
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft Excel. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Outlook.
Tired of marking events and dates with a color pen on a wall calendar?
If you have Excel, you can now generate YOUR OWN wall, desk or email calendars, just by entering the intended YEAR and event details, like it's Name, start and end date. Use different colors for each event or category. Select background and font colors for your calendar. Automatically insert event's legend. Use your own background image.
Really easy to use, just fill in the values in the Input Cells (or import them from Outlook) and press the "Run" button to create different styles of Calendars.
——————
FULLY FEATURED
? – 6 types of Calendar: 3 Annual formats (Traditional, Table and Planning) and 3 Monthly Formats (Monthly, Monthly 4-5-4 and List), from the same event list.
• Academic / Fiscal Calendars: Select the Start Month for any 12 Month Calendar. Create calendars spanning multiple years (Example: August 2007 to July 2008).
• 4-5-4 Fiscal Calendar format supported.
? – Import Tasks and Events from Outlook as calendar events! Great way to print Outlook Calendars in style.
?
• FULLY CUSTOMIZABLE calendar plans. 5 areas of customization. Less time adjusting calendars after generation.
?
• AUTOMATIC HOLIDAYS generator for ANY YEAR: Automatically add holidays to ANY year calendar (USA only).
?
• 3 Legend Options – Events Category, Event List or None
• HEADER & FOOTER Printing: Calendars can have custom Headers & Footers when printing.
• OPTIONAL inclusion of Week Numbers in Annual Formats.
?
• Optional Background Image – Add your picture of choice!
?
• Easier to Reuse: Clean all existing tasks with a single button click!
?
• LOCALIZATION: 2 dates formats (dd/mm or mm/dd) and Start of the Week (Sunday or Monday)
—————
AUTOMATIC HOLIDAYS GENERATOR FOR ANY YEAR
Automatically add holidays to the event list for ANY YEAR (USA holidays only for the current edition). Just select the Holiday List to Insert and press the "Insert Holidays" button. Event color and category can be defined on the Advanced Settings sheet.
—————
OUTLOOK INTEGRATION
Most Excel users are also Microsoft? Outlook users and already have events like Meetings, Holidays and other tasks on Outlook So why write them again for a Traditional or Planning Calendar? Import Tasks or Calendar Events from Microsoft? Outlook!
Importing from Outlook is as easy as defining the desired source (Outlook Calendar or Task list) and Start and End Dates for the imported tasks. Press the Import from Outlook button and select the first row for the imported tasks (no overwriting of manually entered tasks). Relax and see your tasks being automatically added for you!
—————
HIGHLY CONFIGURABLE
The Traditional Calendars for Excel macro allows you to easily configure and personalize several look and content items:
• Month Names;
• Weekday names;
• Background colors form some cells, namely the colored ones like events and weekends;
• Font colors for Month Names and Legend;
• Gridlines ON or OFF;
• Weekend Colors;
• Automatic Holiday Colors;
• Outlook Events Colors;
—————
HELP INCLUDED
There are three sheets on the Microsoft? Excel Workbook The first one is the Input sheet, the second is the Help one.
Easily customize your calendar with personalized event colors and categories. Simplify your scheduling process by importing tasks directly from Outlook with just a few clicks.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Calendar Excel: Group Calendar Maker for Excel Excel (XLS) Spreadsheet, officehelp
Calendar Team Management Value Chain Analysis Workshops Gantt Chart Templates Account Management Sales Vision Statement Lean Game Business Resilience ISO 22301 Cost Reduction Assessment Business Continuity Planning Teamwork Chief Strategy Officer Strategy Development Henry Mintzberg Balanced Scorecard Social Media Strategy
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |