In this hands-on workshop, participants become familiar with the basic tools for data management in Microsoft Excel. Participants learn how to import, extract, and manipulate spreadsheet data. Participants also use some of Excel’s tools to work more efficiently, including data validation, PivotTables, and PivotCharts. Note: This session uses Excel on the Windows platform. This session is not for Excel Online.
Objectives
Learners will:
- 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
Learning Path
You may also consider reviewing our Excel Learning Path, for self-paced and sequential step-by-step resources.