Training & Events

Excel: Use Functions & Formulas with Enterprise Data

Additional Course Information

[3.5-hours, hands-on, Windows only] In this course, participants will learn techniques for analyzing, tabulating, and manipulating data using Excel functions, formulas, and other data tools. 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.

We strongly recommend you review Excel: Creating Basic Spreadsheets, or have equivalent knowledge, before taking this class. Our three Excel classes are designed to complement one another but do not have to be completed as a series.

Topics Include

  • subsetting and grouping data
  • summarizing data
  • forecasting and trending
  • combining and merging data from different data sets  ​

Registration

Register for Excel: Use Functions & Formulas with Enterprise Data