Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Excel 2013 Exam Prep - Expert Course

Excel 2013 Exam Prep - Expert Training Course


Course Description: The Microsoft Excel 2013 Exam Prep -Expert course is geared for experienced Excel users, who want to prepare for the Excel Expert Certification Exams (77-427 & 77-428). Exam topics will not be taught during the class, rather the students with complete a series of practice exams that emulate the actual 77-427 & 77-428 certification exams.

Upon completion of the course, student will be able to complete the following tasks in Excel 2013:

  • Excel 2013 New Features
  • Excel 2013 Fundamentals
  • Entering Data
  • Using Formulas
  • Using Constant Values and Formulas
  • Formatting Worksheets
  • Modify Columns and Rows
  • Edit Workbooks
  • Printing Worksheets

Training Dates
Course Syllabus

Course Outline and Prerequisites

Instructor-Guided Exam Review
The topics covered in the certification exams will not be taught to the students in this class. The class focuses on what to expect during the real exams, and techniques to prepare the student for the exams.

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

MOS 2013 Study Guide
Students will also receive a Copying of the "MOS 2013 Study Guide for Microsoft Excel Expert" whcih will help the student to review any areas where they feel they need additional study after the class.

Prerequisites
This class is for students who have already taken all three levels of our Excel training, or who have significant work experience with Excel covering all topics required for certification. While a limited number of Excel concepts will be reviewed, the course will focus on preparation and studying strategies as well as usage the GMetrix Exam Prep software.

What is provided 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 (Exams 77-427 & 77-428)
The subjects shown below represent the objectives for exams 77-427 and 77-428. Only a very limited number of these topics will be reviewed in class. The topics are listed to help students review areas needed for further independent study.

Managing and sharing workbooks
Tracking changes
Managing comments
Identifying errors
Troubleshooting with tracing
Displaying all changes
retain all changes

Managing multiple workbooks
Modifying existing templates
Merging multiple workbooks
Managing versions of a workbook
Copying styles from template to template
Copying macros from workbook to workbook
Linking to external data

Applying custom formats and layouts
Applying advanced conditional formatting and filtering
Writing custom conditional formats
Using functions to format cells
Creating advanced filters
Managing conditional formatting rules

Prepare a workbook for internationalization and accessibility
Modify tab order among workbook elements and objects
Displaying data in multiple international formats
modify worksheets for use with accessibility tools
Utilizing international symbols
Managing multiple options for +Body and +Heading fonts

Apply custom data formats
Creating custom formats (Number, Time, Date)
Creating custom accounting formats
use advanced Fill Series options

Apply custom styles and templates
Creating custom color formats
Creating and modify cell styles
Creating and modify custom templates
Creating form fields

Look up data with functions
Utilizing the LOOKUP function
Utilizing the VLOOKUP function
Utilizing the HLOOKUP function
Utilizing the TRANSPOSE function

Apply advanced date and time functions
Utilizing the NOW and TODAY functions
Using functions to serialize dates and times

Apply functions in formulas
Utilizing the IF function in conjunction with other functions
Utilizing AND/OR functions
Utilizing nested functions
Utilizing SUMIFS, AVERAGEIFS, and COUNTIFS functions

Creating scenarios
Utilizing the watch window
Consolidating data
Enable iterative calculations
Utilizing What If analysis tools (including Goal Seek)
Utilizing the Scenario Managingr
Using financial functions

Creating advanced chart elements
Add trendlines to charts
Creating dual axis charts
Creating custom chart templates
View chart animations

Creating and Managing PivotTables
Creating new PivotTables
Modify field selections and options
Creating a slicer
Group records
Utilizing calculated fields
Formatting data
Utilizing PowerPivot
Managing relationships
Manipulate options in existing PivotCharts
Applying styles to PivotCharts

Onsite excel Training
Small Group Package (up to 6 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1600 (over 10% off our Individual Training rates)
  • Additional students can be added for $150/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1600 (Flat Rate)

Medium Group Package (up to 12 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2400 (over 33% off our Individual Training rates)
  • Additional students can be added for $125/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2400 (Flat Rate)

Large Group Package (up to 18 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 42% off our Individual Training rates)
  • Additional students can be added for $100/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100 (Flat Rate)





Alabama
Birmingham
Huntsville
Mobile
Montgomery

Arizona
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Orange
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Commerce City
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Frederick
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Pontiac
Traverse City
Troy

Minnesota
Bloomington
Minneapolis
Minneapolis downtown
Rochester MN
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Carson City
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua

New Jersey
Bridgewater
Jersey City
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Charlotte
Charlotte Downtown
Charlotte North
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Canton
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Morgantown
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills, Computers - Training, Arlington Heights, IL