Facebook Pixel
Microsoft Certification Training
Search classes by keyword:
Search classes by category:
Microsoft Certification and Microsoft Training, Cisco Certification and MCSE Certification
MOS Complete 2016 space



Microsoft Office Specialist 2016 Complete Certification Training

Microsoft Office Specialist 2016 (Access/Excel/PowerPoint/Word)

Course Number: #CED-1596
Course Length: 10 days
Number of Exams: 4
Certifications: MOS - Microsoft Office Specialist 2016 Certification

Grants (discounts) are available for multiple students for the same or different courses.

Upcoming Dates Class Times Class Format Quote
Call (800) 611-1840 for Class Schedule


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.

MOS certification is for those looking to demonstrate proficiency in using one or more Microsoft Office programs and in deploying Microsoft Office cloud and hybrid solutions. Differentiate yourself with this competency as a proven expert in Office skills.

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

This course is intended for students who want to learn Word 2016 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.

Course Content

Lesson 1: Getting Started with Word
  • Create, Edit and Save Word Documents
  • Preview and Print Documents
  • Customize the Word Environment
Lesson 2: Formatting Text and Paragraphs
  • Apply Character Formatting
  • Control Paragraph Layout
  • Align Text Using Tabs
  • Display Text in Bulleted or Numbered Lists
  • Apply Borders and Shading
Lesson 3: Working More Efficiently
  • Make and Apply Repetitive Edits
  • Use Styles to Streamline Repetitive Formatting Tasks
Lesson 4: Managing Lists
  • Sort and Format a List
Lesson 5: Adding Tables
  • Insert a Table
  • Modify and Format a Table
  • Convert Text to a Table
Lesson 6: Inserting Graphic Objects
  • Insert Symbols and Special Characters
  • Add Images to a Document
Lesson 7: Controlling Page Appearance
  • Apply a Page Border and Color
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark
Lesson 8: Preparing to Publish a Document
  • Check Spelling, Grammar, and Readability
  • Use Research Tools
  • Check Accessibility
  • Save a Document to Other Formats

[ back to top ]

Microsoft Word 2016 - Level 2

This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.

Course Content

Lesson 1: Organizing Content Using Tables and Charts
  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart
  • Add an Excel Table to a Word Document (Optional)
Lesson 2: Customizing Formats Using Styles and Themes
  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes
Lesson 3: Inserting Content Using Quick Parts
  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts
Lesson 4: Using Templates to Automate Document Formatting
  • Create a Document Using a Template
  • Create and Modify a Template
  • Manage Templates with the Template Organizer
Lesson 5: Controlling the Flow of a Document
  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow
Lesson 6: Simplifying and Managing Long Documents
  • Insert Blank and Cover Pages
  • Insert an Index
  • Insert a Table of Contents
  • Insert an Ancillary Table
  • Manage Outlines
  • Create a Master Document
Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels
  • The Mail Merge Feature
  • Merge Envelopes and Labels

[ back to top ]

Microsoft Word 2016 - Level 3

This course is intended for students who want to use advanced capabilities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.

Course Content

Lesson 1: Manipulating Images
  • Integrate Pictures and Text
  • Adjust Image Appearance
  • Insert Other Media Elements
Lesson 2: Using Custom Graphic Elements
  • Create Text Boxes and Pull Quotes
  • Add WordArt and Other Text Effects
  • Draw Shapes
  • Create Complex Illustrations with SmartArt
Lesson 3: Collaborating on Documents
  • Prepare a Document for Collaboration
  • Mark Up a Document
  • Review Markups
  • Merge Changes from Other Documents
Lesson 4: Adding Document References and Links
  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography
Lesson 5: Securing a Document
  • Suppress Information
  • Set Formatting and Editing Restrictions
  • Restrict Document Access
  • Add a Digital Signature to a Document
Lesson 6: Using Forms to Manage Content
  • Create Forms
  • Modify Forms
Lesson 7: Automating Repetitive Tasks with Macros
  • Automate Tasks by Using Macros
  • Create a Macro

[ back to top ]

Microsoft PowerPoint 2016 - Level 1

This course is designed for students who wish to gain a good understanding of Microsoft PowerPoint 2016 that is necessary to create and develop engaging multimedia presentations.

Course Content

Lesson 1: Getting Started with PowerPoint
  • Create and Save a PowerPoint Presentation
  • Use PowerPoint Help
Lesson 2: Developing a PowerPoint Presentation
  • Select a Presentation Type
  • Edit Text
  • Build a Presentation
Lesson 3: Performing Advanced Text Editing Operations
  • Format Characters
  • Format Paragraphs
  • Format Text Boxes
Lesson 4: Adding Graphical Elements to Your Presentation
  • Insert Images
  • Insert Shapes
Lesson 5: Modifying Objects in Your Presentation
  • Edit and Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects
Lesson 6: Adding Tables to Your Presentation
  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications
Lesson 7: Adding Charts to Your Presentation
  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel
Lesson 8: Preparing to Deliver Your Presentation
  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation

[ back to top ]

Microsoft PowerPoint 2016 - Level 2

This course is intended for students who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality.

Course Content

Lesson 1: Modifying the PowerPoint Environment
  • Customize the User Interface
  • Set PowerPoint 2016 Options
Lesson 2: Customizing Design Templates
  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master
Lesson 3: Adding SmartArt and Math Equations to a Presentation
  • Create SmartArt
  • Modify SmartArt
  • Write Math Equations
Lesson 4: Working with Media and Animations
  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions
Lesson 5: Collaborating on a Presentation
  • Review a Presentation
  • Store and Share Presentations on the Web
Lesson 6: 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
Lesson 7: Securing and Distributing a Presentation
  • Secure a Presentation
  • Broadcast a Slide Show
  • Create a Video or a CD

[ back to top ]

Microsoft Excel 2016 - Level 1

In this course, you will become familiar with introductory features and functionality of Microsoft Excel 2016.

Course Content

Lesson 1: Fundamentals
  • Getting around
  • Workbook basics
Lesson 2: Creating worksheets
  • Entering data
  • Formulas
  • Functions
  • Moving and copying data
  • Reference types
Lesson 3: Formatting
  • Text formatting
  • Number formatting
  • Alignment
  • Borders and highlighting
  • Styles and themes
Lesson 4: Manipulating data
  • Data entry shortcuts
  • Paste options
  • Inserting, deleting, and hiding
Lesson 5: Charts
  • Creating charts
  • Chart types and elements
Lesson 6: Output
  • Managing worksheet windows
  • Printing worksheets
  • Sharing workbooks
Lesson 7: Settings and templates
  • Workbook options and properties
  • Templates

[ back to top ]

Microsoft Excel 2016 - Level 2

In this course, you will become familiar with intermediate features and functionality of Microsoft Excel 2016.

Course Content

Lesson 1: Managing workbooks
  • Managing worksheets
  • Customizing Excel
Lesson 2: Named ranges
  • Using names in formulas
Lesson 3: Tables
  • Sorting
  • Filtering tables
  • Structured references
  • Validation
  • Transposing data
Lesson 4: Summarizing data
  • Consolidation
  • Subtotals
Lesson 5: PivotTables
  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts
Lesson 6: Presentation features
  • Conditional formats
  • Custom Formats
  • Graphics
Lesson 7: Advanced charts
  • Special chart types
  • Sparklines
  • Quick Analysis
Lesson 8: Collaboration
  • Permissions
  • Shared workbooks

[ back to top ]

Microsoft Excel 2016 - Level 3

In this course, you will become familiar with advanced features and functionality of Microsoft Excel 2016.

Course Content

Lesson 1: Logical and Lookup Functions
  • Decision-making functions
  • Lookup and reference functions
Lesson 2: Advanced Formulas
  • Auditing and error-trapping
  • Formula options
  • Arrays
Lesson 3: Special functions
  • Date and time functions
  • Text functions
  • Other functions
Lesson 4: Importing and Exporting
  • The Power Pivot Data Model
  • Exporting data
Lesson 5: Analysis
  • What-if analysis
  • The Analysis Toolpak
Lesson 6: Macros and Forms
  • Recording macros
  • Running macros
  • Forms

[ back to top ]

Microsoft Access 2016 - Level 1

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Course Content

Lesson 1: Getting Started with Access
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
Lesson 2: Working with Table Data
  • Modify Table Data
  • Sort and Filter Records
Lesson 3: Querying a Database
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
Lesson 4: Using Forms
  • Create Basic Access Forms
  • Work with Data on Access Forms
Lesson 5: Generating Reports
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

[ back to top ]

Microsoft Access 2016 - Level 2

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

Course Content

Lesson 1: Designing a Relational Database
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
Lesson 2: Joining Tables
  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets
Lesson 3: Using Data Validation
  • Use Field Validation
  • Use Form and Record Validation
Lesson 4: Creating Advanced Queries
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
Lesson 5: Organizing a Database for Efficiency
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
Lesson 6: Using Advanced Reporting Techniques
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

[ back to top ]


CED Solutions is your best choice for MOS Complete 2016, MOS Complete 2016 training, MOS Complete 2016 certification, MOS Complete 2016 boot camp, MOS Complete 2016 certification training, MOS Complete 2016 certification course, MOS Complete 2016 course, MOS Complete 2016 class.



MOS Complete 2016 space
Search classes by keyword:
Search classes by category:


Copyright © 2020 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.