14 September 2017

Team Calendar Options for Excel, Outlook and SharePoint

Most organizations need one or several shared team calendars to keep track of what people are doing and when they are available. We have products for such tracking, but today I will first show a simple Excel calendar that might work for companies who don't want to invest in a more advanced solution.

Excel calendar
Excel iconAn Excel file can be placed in a shared file folder and used as a calendar. Excel has many calendar templates to select from, but you can also create a custom calendar. That is what I show in the demo below, and a new Excel calendar article in the Tips section gives some more information.

SharePoint calendar SharePoint icon
SharePoint team sites have a default team calendar, so if the team shares information via SharePoint, the SharePoint calendar is a good option. It has several useful features, like version history and alerts, but its look is not very appealing.

Excel + SharePoint
If you just want a nice looking calendar that summarizes team member activities, you can insert an Excel calendar in a SharePoint page instead of using the SharePoint calendar. In the demo below, I show how to do that, and of course there is also a Tips article on how to insert an Excel calendar in SharePoint.

Calendar Browser for Outlook or SharePoint
Calendar Browser for SharePoint logoOne of my first products was a calendar solution for Outlook, and it is still sold and used. Today, after 17 years, it is of course much enhanced, and there is also a SharePoint edition. Calendar Browser was created to make it easy to book corporate resources, but the product can also be used to show people's Outlook or SharePoint calendars.

TimeCard for Outlook or SharePoint
TimeCard for Outlook has one more calendar product for Outlook or SharePoint: TimeCard. It is intended for time reporting directly from each user's calendar, but also future appointments/events can be reported.

TimeCard is not a team calendar, but it is a good solution for managers or other staff that need to see future planning for many people. The SharePoint edition even has a TimeCard summary web part that can be inserted into any page in the site collection.

By Peter Kalmström
CEO and Systems Designer Business Solutions