MICROSOFT OFFICE SPECIALIST IN EXCEL
Microsoft  Office Specialist Cert Prep Courses
(Select 6 Levels)
  
PREPARATION FOR THE EXCEL MS OFFICE SPECIALIST CERTIFICATION EXAM (77-420)
Course Overview 
These courses provides trainees with the basic through advance skills to create, manage, edit and maintain spreadsheets using MS Excel. These courses will also prepare trainees for the Excell Microsoft Office Specialist certification exam. 
Excel Basic Level
·    Creating Workbooks,
·    Worksheets, and Data
·    Saving and Printing Data
·    Formatting Cells and Worksheets
·    Formatting Data
·    Create & save customized cell style.
·   Steps to use Auto Fill and Flash Fill
Excel Intermediate Level
· Performing Calculations Using Functions
· Presenting Data in Tables and Charts
· Presenting Data using Conditional  
  Formatting and Spark lines
· Creating and Customizing Visual  
  Elements
Excel Advanced Level
·    Customizing Options and Views
·    Manipulating Data
·    Data Search, Data Validation,
·    Modify work environment
·    Ways to sort and filter data.
·    Apply and modify default settings.
·   Create and apply a macro


REGULAR PRICE FOR ALL COURSES PURCHASED SEPARATLY $1,200.00 
PACKAGE DISCOUNT RATE $999.00