📄️ Excelendar's Column Management System
Excelendar's column management system is very robust and flexible, allowing for personalization without hiccups. You can rename columns by directly changing the value in the header cells, hide them and move them around without breaking any of the add-in's functionality. If there is an event property that you would like to edit, but doesn't appear in the sheet as a column upon importing, you can add it by ticking its corresponding checkbox in the add-in Settings, and re-importing the calendar.
📄️ How Excelendar manages datetimes and timezones
Excelendar has a very robust system in place for managing datetimes and timezones. When importing a calendar in a sheet, there are five essential columns that are displayed: Display Start Date, Display Start Time, Display End Date, Display End Time, Event Start Date, Event Start Time, Event End Date, Event End Time, Event Start Timezone and Event End Timezone. While this may seem confusing at first, this system allows for maximum flexibility when it comes to managing datetimes and timezones.
📄️ Recurrence patterns, RRules and the RRule Editor
Outlook Calendar stores recurrence patterns using Microsoft's own format for specifying recurrences.
📄️ Deleting an event: Learning about the Update and Delete columns
Understanding the Update flag
📄️ Excelendar vs Power Automate
Microsoft's Power Automate is a powerful tool when it comes to integrating Microsoft apps into each other. However, in the case of Excel and Outlook Calendar integration, it is very limited. In the overwhelming majority of cases, Excelendar is the more efficient and reliable tool to use.