MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


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

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

Class Schedule
04/13/20 - 04/24/20

Info/Enroll

04/27/20 - 05/08/20

Info/Enroll

06/08/20 - 06/19/20

Info/Enroll


  • Includes roundtrip airfare and lodging (for boot camps held in Georgia and Florida only)
  • Hands-on instruction by a certified instructor
  • Includes all course materials
  • On-site Testing
  • Lunch & Snacks provided each day

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 ]


MCSEClasses.com is your best choice for MOS Complete 2016, MOS Complete 2016 training, MOS Complete 2016 certification, MOS Complete 2016 certification boot camp, MOS Complete 2016 boot camp, MOS Complete 2016 certification training, MOS Complete 2016 boot camp training, MOS Complete 2016 boot camp certification, MOS Complete 2016 certification course, MOS Complete 2016 course, training MOS Complete 2016, certification MOS Complete 2016, boot camp MOS Complete 2016, certification MOS Complete 2016 boot camp, certification MOS Complete 2016 training, boot camp MOS Complete 2016 training, certification MOS Complete 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





Search classes by keyword:


Search classes by category:

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