Microsoft Office Specialist 2016 Training in Lexington

Enroll in or hire us to teach our Microsoft Office Specialist 2016 class in Lexington, Kentucky by calling us @303.377.6176. Like all HSG classes, Microsoft Office Specialist 2016 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Specialist 2016 may be taught at one of our local training facilities.

Special Offers, Deals & Discounts

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.

Call for Details: 303.377.6176

We offer private customized training for groups of 3 or more attendees.

Course Description

 
Larning 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.
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.
Course Length: 5 Days
Course Tuition: $1990 (US)

Prerequisites

Some knowledge of MS Office

Course Outline

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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.