Excel 2013 Exam Prep - Specialist Course Outline
*** 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
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