Office – Become more productive thanks to this Excel template which analyzes your time

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)


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


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


NOTE you may be asked to trust the autodiscover endpoint found


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


And… you got your calendar dashboard


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.

Leave a Comment

Your email address will not be published. Required fields are marked *

The reCAPTCHA verification period has expired. Please reload the page.