IT Connect

Information technology tools and resources at the UW

Tag Archive for: productivity

Posts

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

Description:

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.

Length:

9:17
Read more