Advanced Microsoft Excel


This Advanced Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.


Who Should Attend 

Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills

or students who want to learn the topics covered in this course in the Microsoft Excel interface.

Course Objectives

  • Create pivot tables and charts.

  • Learn to trace precedents and dependents.

  • Convert text and validate and consolidate data.

  • Collaborate with others by protecting worksheets and workbooks.

  • Create, use, edit, and manage macros.

  • Import and export data.

Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Basic and Intermediate Excel experience.

Upcoming Dates: