Advanced Excel

PT3654
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
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

Related Scheduled Courses