In this hands-on workshop, participants will be introduced to basic tools for data management in Microsoft Excel 2016. Participants will learn how to import, extract, and manipulate data. Additional features covered in this session are Excel’s table-related features, the Auto Fill feature, specifying data validation criteria, sorting and filtering data, and creating a simple Pivot Table. Participants will also use some of Excel’s tools to help manage multiple worksheets and to visually compare workbooks. The focus will be learning how to work more efficiently in Excel.

Objectives
• Create built-in and custom lists
• Explore workbook and worksheet protection
• Import, sort, filter and validate data
• Create tables and pivot tables


Training for: 
Faculty
Staff
Students
Type of Training: 
live training in person iconLive Training: In-Person
Training Topic: 
Data
Service or Technology: 
Microsoft Excel