IT Connect

Information technology tools and resources at the UW


Analyze Your Time Spent In Meetings (and Learn Pivot Table Skills)


This video uses familiar Microsoft Outlook calendar data as the basis for learning how to analyze data using Excel pivot tables. Pivot tables are easy to create and provide a powerful way to analyze data. Every analyst, accidental or otherwise, will benefit from this tool.

You’ll learn how to export your Microsoft Outlook calendar to a CSV file, open the CSV file in Microsoft Excel and massage the data, and analyze your data using an Excel pivot table.



Excel formula:

=([@[End Date]]+[@[End Time]])-([@[Start Date]]+[@[Start Time]])