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.


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


  • 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.