In this hands-on workshop, participants will become familiar with the basic tools for data management in Microsoft Excel. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to work more efficiently, including data validation, PivotTables, and PivotCharts. 

Objectives

  • Explore ways to import data from external sources into Excel for analysis 
  • Specify criteria to control data entered into a worksheet 
  • Create pivot tables to explore, analyze, and summarize data sets

Training for: 
Faculty
Staff
Students
Type of Training: 
Live Training: Online
Training Topic: 
Data
Service or Technology: 
Microsoft Excel
Microsoft O365