Welcome to ONLC Training Centers
Welcome to ONLC Training Centers

Excel 2013 Exam Prep - Specialist Course Outline

 (1 day)
Version 2013

*** This Class is for Experienced Excel Users Seeking Excel Specialist Certification ***
This live, instructor-led course is delivered by having the class complete a series of practice exams which mirror the format that you will see when taking the actual exams. In addition, exam preparation techniques will be reviewed.

Instructor-Guided Exam Review
The concepts covered in the exams will not be "taught" in this class. This class focuses on what to expect during the real exams and strategies to prepare you for the exams.

GMetrix Exam Prep Software
Participants will work through a series of exam simulations using Excel and exam prep software by GMetrix, the industry's leading provider of Microsoft Office Specialist exams. (After the class, you will have continued access to the test prep software.)

MOS 2013 Study Guide
In addition, you will receive a copy of the best selling paperback, the "MOS 2013 Study Guide for Microsoft Excel" that will help you review any areas where you feel you need additional study after the class.

This course is for individuals who have taken the first two levels of our Excel training or who have significant work experience with Excel spanning all topics required for certification. While a limited number of Excel concepts will be reviewed, the course will focus on preparation and studying techniques as well as how to use the GMetrix Exam Prep software.

What You Get With the Class
One Day of Instructor Guided Exam Preparation
GMetrix Practice Tests After the Class
MOS 2013 Study Guide Paperback

Excel 2013 Specialist Exam Objectives (77-420)
The topics shown below are represent the objectives for exam 77-420. Only a very limited number of these topics will be reviewed in class. The topics are listed to help participants review area needed for further independent study.

Create and manage worksheets and workbooks
Navigate through worksheets and workbooks
Format worksheets and workbooks
Customize options and views for worksheets and workbooks
Configure worksheets and workbooks to print or save

Create cells and ranges
Insert data in cells and ranges
Format cells and ranges
Order and group cells and ranges

Creating tables
Create a table
Modify a table
Filter and sort a table

Apply formulas and functions
Utilize cell ranges and references in formulas and functions
Summarize data with functions
Utilize conditional logic in functions
Format and modify text with functions

Create charts and objects
Create a chart
Format a chart
Insert and format an object

View outline in Word


Attend hands-on, instructor-led Excel 2013 Exam Prep - Specialist training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $295

Savings options:

 CEA Apps Saver
 Office 5 for 4
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name