Find Training

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