IT Connect

Information technology tools and resources at the UW

Tag Archive for: excel


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.


Read more

Free Tableau and Excel Workshops From UW-IT

We have added several free UW-IT workshops! Our workshops teach UW staff and faculty how to visualize their data using Tableau software and do drag and drop analysis using Microsoft Excel PivotTables. Sessions last from one to three hours and no programming skills are required. Learn more and register online for upcoming sessions on the UW Data & Analytics website.