With Excel 2016, Microsoft has introduced a new template called Calendar Insights.

The template surfaces how much time you spend in meetings, whom you meet with the most (and whom you ignore), which part of the day you usually meet with people. You can see your calendar as a dashboard, and interact with it to drill into specific time periods, or types of meetings, you’re interested in

Open Excel and look for the Calendar Insights template (or Business Analysis Feature Tour which is the real name)

image

Then hit the Let’s get started button to import your calendar

image

You will be asked to sign-in to your Exchange mailbox (which can be hosted either on premises or on Exchange Online)

image

NOTE you may be asked to trust the autodiscover endpoint found

image

Then you should see in the Excel taskbar the template is retrieving your calendar’s data

imageimage

And… you got your calendar dashboard

image

Now it’s up to you to drill down and analyze these results Smile

You can save this workbook as Excel Macro-Enabled Workbook to be able to refresh the data anytime you want.