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 |
|
|