Google Sheets: Use Functions & Formulas with Enterprise Data
[3.5-hours, hands-on] In this course, participants will learn techniques for analyzing, tabulating, and manipulating data using functions, formulas, and other data tools in Google Sheets. This course will focus on practical examples using real-world scenarios so participants can easily translate skills to their own situation. We will work with a variety of HR, Financial and Student data spreadsheets extracted directly from the University of Minnesota Reporting Center.
Overview
[3.5-hours, hands-on] In this course, participants will learn techniques for analyzing, tabulating, and manipulating data using functions, formulas, and other data tools in Google Sheets. This course will focus on practical examples using real-world scenarios so participants can easily translate skills to their own situation. We will work with a variety of HR, Financial and Student data spreadsheets extracted directly from the University of Minnesota Reporting Center.
This course was developed from use-cases identified by the Analytics and Data Integration FCoP.
Topics
- Subsetting and grouping data
- Summarizing data
- Forecasting and trending
- Combining and merging data from different data sets
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.
Related Courses
Registration
Current Term Sessions
-
Various