Loading Course Schedule...
PT3654
Training Summary
This module introduces the skills necessary for using worksheets as a database and for working with PivotTables. It includes tasks to work with databases, the data form, and advanced filters; use AutoFilter; and import and export data. Students will also learn how to create and revise PivotTables.
Prerequisites
Students should take ProTech's Introduction and Intermediate Excel classes.
Duration
1 Day/Lecture & Lab
Course Topics
- Work with databases
- Work with the data form
- Use AutoFilter
- Work with advanced filters
- Import and export data
- Create/Revise PivotTables
- Working with Databases
- Working with the Data Form
- Using AutoFilter
- Working with Advanced Filters
- Importing and Exporting Data
- Creating/Revising PivotTables