$2,695.00

Ask us about our Best Price Guarantee. We’ll beat any competitor’s price!

ICLIn-Classroom Learning VLTVirtual Live Training GTRGuaranteed to Run
Location Start date End Date Class Times Class Details Action
No class dates currently scheduled. Click here to request a date

Overview

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee as much as $16,000 more in annual salary than uncertified peers.

Earning a Microsoft Office Specialist certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Microsoft Office Specialist certification can also lead to increased job satisfaction. Research indicates that certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients.

For employers, the certification provides skill-verification tools that not only help assess a person’s skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system.

  • Microsoft Word 2016
  • Microsoft PowerPoint 2016
  • Microsoft Excel 2016

A Microsoft Office Specialist (MOS) certification helps validate proficiency in using Microsoft Office 2016 and meets the demand for the most up-to-date skills on the latest Microsoft technologies. Candidates who pass a certification exam show that they can meet globally recognized performance standards.

Description

Microsoft Word 2016

This class is designed for those that have experience working with Word and want to learn Intermediate and Advanced features.

Course Content

Formatting Review
Graphic Objects
Page Appearance
Organizing Content Using Tables and Charts
  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart
Customizing Formats Using Styles and Themes
  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes
Inserting Content Using Quick Parts
  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts
Using Templates to Automate Document Formatting
  • Create a Document Using a Template
  • Create and Modify a Template
  • Manage Templates with the Template Organizer
Controlling the Flow of a Document
  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow
Simplifying and Managing Long Documents
  • Insert Blank and Cover Pages
  • Insert an Index and Table of Contents
  • Insert an Ancillary Table
  • Create a Master Document
Using Mail Merge to Create Letters, Envelopes, and Labels
  • The Mail Merge Feature
  • Merge Envelopes and Labels
Manipulating Images
  • Integrate Pictures and Text
  • Adjust Image Appearance
Graphic Elements
Using Forms to Manage Content
  • Create and Modify Forms
Macros

Microsoft PowerPoint 2016

This class is designed for those that have basic experience working with PowerPoint and want to become very well versed with the many features of PowerPoint.

Course Content

Developing a PowerPoint Presentation
Advanced Text Editing Operations
  • Format Characters, Paragraphs, and Text Boxes
Adding Graphical Elements
  • Insert Images and Shapes
Modifying Objects
  • Format, Group, Arrange, and Animate Objects
Adding Tables to Your Presentation
  • Create and Format a Table
  • Insert a Table from Other Microsoft Office Applications
Adding Charts
  • Create and Format a Chart
  • Insert a Chart from Microsoft Excel
Modifying the PowerPoint Environment
  • Customize the User Interface
  • Set PowerPoint 2016 Options
Customizing Design Templates
  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master
Adding SmartArt and Math Equations to a Presentation
  • Create and Modify SmartArt
  • Write Math Equations
Working with Media and Animations
  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions
Collaborating on a Presentation
Customizing a Slide Show
  • Annotate a Presentation
  • Set Up a Slide Show
  • Create a Custom Slide Show
  • Add Hyperlinks and Action Buttons
  • Record a Presentation
Securing and Distributing a Presentation
  • Secure a Presentation
  • Broadcast a Slide Show
  • Create a Video or a CD

 

Microsoft Excel 2016

This class is designed for those that have experience working with Excel and want to learn Intermediate and Advanced features.

Course Content

Formatting
Managing Workbooks
Named Ranges
Tables
  • Sorting and Filtering Tables
  • Validation
  • Transposing Data
Summarizing Data
  • Consolidation & Subtotals
PivotTables
  • Creating and Formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts
Presentation Features
  • Conditional & Custom Formats
  • Graphics
Advanced Charts
  • Special Chart Types
  • Sparklines
  • Quick Analysis
Collaboration
  • Permissions
  • Shared Workbooks
Logical and Lookup Functions
  • Decision-making Functions
  • Lookup and Reference Functions
Advanced Formulas
  • Formula Options
  • Arrays
Special Functions
  • Date and Time Functions
  • Text and other Functions
Importing and Exporting
  • The Power Pivot Data Model
  • Exporting Data
Analysis
  • What-if Analysis
  • The Analysis Toolpak
Macros and Forms
  • Recording Macros
  • Funning Macros
  • Forms