Google Sheets: Quickly Visualize and Analyze Data | Undergraduate Academic Advising

EUS241 Administered by: OIT End User Support Services

[3.5-hours, hands-on] In this course, participants will learn how to use pivot tables and pivot charts in Google Sheets to quickly and easily summarize large sets of data for analysis, forecasting, and high-level reporting. We will work with a variety of HR, Financial and Student data spreadsheets extracted directly from the University of Minnesota Reporting Center. Note: This course was formerly titled "Google Sheets: Use Pivot Tables with Enterprise Data."

Overview

This course was developed from use-cases identified by the Analytics and Data Integration FCoP.

Topics

creating and modifying pivot tables to quickly summarize, group and filter data
using calculated fields formatting for legibility and ease of use
creating “dashboards” to give others a high-level view of data

Who should attend

We strongly recommend you review Google Sheets Essential Training, or have equivalent knowledge, before taking this class. Our in person Google Sheets classes are designed to complement one another but do not have to be completed as a series.

Wait List Guidelines

People on the waitlist are encouraged to attend the first day of class to see if a seat has opened for them.

This training is administered by OIT End User Support Services, Technology Training

See Advising Training & Events Google Calendar

Contact

Email [email protected].

To request an update, change, or addition to any part of this website, please fill out the form below.

Change Request Form