Microsoft Office Specialist 2016

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.

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

[ back to top ]

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

[ back to top ]

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

[ back to top ]

MCSEClasses.com is your best choice for MOS 2016, MOS 2016 training, MOS 2016 certification, MOS 2016 certification boot camp, MOS 2016 boot camp, MOS 2016 certification training, MOS 2016 boot camp training, MOS 2016 boot camp certification, MOS 2016 certification course, MOS 2016 course, training MOS 2016, certification MOS 2016, boot camp MOS 2016, certification MOS 2016 boot camp, certification MOS 2016 training, boot camp MOS 2016 training, certification MOS 2016 course.

mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us