IT Connect

Information technology tools and resources at the UW

Archive for category: Featured Videos

Videos that go in the carousel / are featured at the top of the page

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