Microsoft Excel 2013 Certification Training

Career Training Program
Program Code: GES383
Hours: 70

Overview

Procert Exam Ready

The Microsoft Excel 2013 Certification Training program teaches students skills in Microsoft Excel 2013 and prepares them for the Microsoft Office Specialist (MOS) Certification Exam 77-420.

Students learn essential Excel skills, including creating and editing basic worksheets and workbooks, working with advanced formulas, using lists and illustrations, adding charts and advanced formatting, managing pivot tables, and auditing and analyzing worksheet data. Students will also utilize complex data tools and collaborate with other students at various points in the program. As students advance into the program, they will learn to create and manage macros.

Objectives

Upon program completion, you will be able to perform the following tasks in Excel:

  • Create and modify basic worksheets and perform calculations
  • Modify the appearance of data within a worksheet
  • Use the print features, formulas, and functions
  • Create and modify charts
  • Convert, sort, filter, and manage lists
  • Insert and modify illustrations and tables

You will additionally be able to perform the following advanced Excel functions:

  • Use conditional formatting, styles, and pivot tables
  • Trace precedents and dependents
  • Convert text and validate/ consolidate data
  • Collaborate with others by protecting worksheets and workbooks
  • Create, use, edit, and manage macros
  • Import and export data