My Calendar Insights in Excel 2016

This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016:

  • Power Query (Excel 2016 new get-data and transformation features that are available in the Get & Transform section of the Data tab).
  • Power Pivot measures.

You are welcome to try out the new templates and examine their queries and DAX formulas. The templates are available in File –> New section of Excel 2016.


If you can’t find the template in File –> New, you can download it from TechNet Gallery here.

In this series we will walk through the Calendar Insight template that I created using the Exchange connector in Power Query. 

To learn how to use the template go here.

In this coming series we will discuss the following topics:

  • Use Data –> New Query –> From Other Sources –> From Exchange Server to import your calendar data. 
  • Tips and tricks to handle recurring meetings.
  • Use DAX to calculate the percentage of time spent on meetings.
  • Take the template to its next level and create new dimensions like meeting categories.
  • Import the data to Power BI and use custom visuals to create cool data visualizations.

Looking forward to seeing you here for the next blogposts of this series.


  1. Pingback: My Calendar Insights In Excel 2016 - Get & Transform Data in Excel 2016 - Site Home - TechNet Blogs

  2. Pingback: Welcome Gil Raviv! (And a Nifty Slicer Trick) - PowerPivotPro

  3. Markus Wangler Reply

    Hey Gil, I just stumbled upon your sight in search of a new ‘calendar analytics’ version back from outlook2010.
    I found your tool, after some trouble downloading it. (had to use edge browser) / chrome didnt work. i wanted to sign in. After 5 failed attempts I figured i just write you. Error message: authentication was not possibile. try it again.
    (freely translated from german)

    Thanks in advance.
    Greetings Markus

  4. Markus Wangler Reply

    Hello Gil, after reading a bit more i found out that I do not have that many options to import data from. Here is my list:
    from a table, from web, from microsoft query, from OData-Datafeed, from ODBC, from OLEDB.

    Do you have any hints for me how i can include the microsoft exchange querry?
    Thanks in advance. Markus

    • Gil Raviv Post authorReply

      Which license do you have? With Office Pro Plus you should get all the connectors.

    • Gil Raviv Post authorReply

      Which error do you have? I suggest you contact Microsoft support for help.

Leave a Reply