Dean College
Home > Training Programs > Microsoft > Microsoft Office Specialist 2016 (MOS) Certification Training (Vouchers Included)


Fill out the form below

By continuing you are agreeing to have ed2go contact you.
Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Microsoft Office Specialist 2016 (MOS) Certification Training (Vouchers Included)

$2,895.00 (USD)




I. Introduction to Microsoft Excel
    A.    Creating a Microsoft Excel Workbook
    B.    The Ribbon
    C.    The Backstage View (The File Menu)
    D.    Entering Data in Microsoft Excel Worksheets
    E.    Formatting Microsoft Excel Worksheets
    F.    Using Formulas in Microsoft Excel
    G.    Working with Rows and Columns
    H.    Editing Worksheets
    I.    Finalizing Microsoft Excel Worksheets
    J.    Microsoft Excel Features that Were New in 2013
    K.    Features New in 2016
    L.    Introduction to Microsoft Excel 2016 Exam
II. Intermediate Microsoft Excel 2016
    A.    Advanced Formulas
    B.    Working with Lists
    C.    Working with Illustrations
    D.    Visualizing Your Data
    E.    Working with Tables
    F.    Advanced Formatting
    G.    Microsoft Excel Features that Were New in 2013
    H.    Features New in 2016
    I.    Intermediate Microsoft Excel 2016 Exam
III. Advanced Microsoft Excel 2016
    A.    Using Pivot Tables
    B.    Auditing Worksheets
    C.    Data Tools
    D.    Working with Others
    E.    Recording and Using Macros
    F.    Random Useful Items
    G.    Microsoft Excel Features that Were New in 2013
    H.    Features New in 2016
    I.    Advanced Microsoft Excel 2016 Exam
IV. Microsoft Excel Final Exam

V. Introduction to Microsoft Word 2016
    A.    Creating a Microsoft Word Document
    B.    The Ribbon
    C.    The File Tab
    D.    The Quick Access Toolbar
    E.    Formatting Microsoft Word Documents
    F.    Editing Documents
    G.    Finalizing Microsoft Word Documents
    H.    Introduction to Microsoft Word 2016 Exam
VI. Intermediate Microsoft Word 2016
    A.    Advanced Formatting  
    B.    Working with Tables
    C.    Working with Images
    D.    Page Layout
    E.    Working with Illustrations
    F.    Viewing Your Document(s)
    G.    Intermediate Microsoft Word 2016 Exam
VII. Advanced Microsoft Word 2016
    A.    Working with Long Documents
    B.    Reviewing and Collaborating on Documents
    C.    Comparing and Combining Documents
    D.    Managing Mailings
    E.    Protecting Documents
    F.    Random Useful Items
    G.    Advanced Microsoft Word 2016 Exam
VIII. Microsoft Word 2016 Final Exam

IX. Introduction to Microsoft PowerPoint 2016
    A.    Creating a PowerPoint Presentation
    B.    The Ribbon
    C.    The Quick Access Toolbar
    D.    The Backstage View (The File Menu)
    E.    Formatting Microsoft PowerPoint Presentations
    F.    Working with Images
    G.   Working with Tables and Charts
    H.    Finalizing Microsoft PowerPoint Presentations
    I.      Introduction to Microsoft PowerPoint 2016 Exam
X. Advanced Microsoft PowerPoint 2016
    A.    Customizing Presentations
    B.    Presentation Masters
    C.    Working with Special Effects
    D.    Using SmartArt
    E.    Multimedia
    F.    Setting up the Slide Show
    G.    Outlines and Slides
    H.    Managing Multiple Presentations
    I.    Sharing and Securing a Presentation
    J.    Features New in 2016
    K.   Advanced Microsoft PowerPoint 2016 Exam
XI. Microsoft PowerPoint 2016 Final Exam

XII. Introduction to Microsoft Outlook 2016
    A.    The Outlook 2016 Interface
    B.    Performing Popular Tasks in Outlook 2016
    C.    Working with Messages
    D.    Working with the Calendar
    E.    Organizing Contacts
    F.    Introduction to Microsoft Outlook 2016 Exam
XIII. Advanced Microsoft Outlook 2016
    A.    Working with Tasks and Notes
    B.    Using Signature and Themes
    C.    Managing Your Inbox
    D.    Working with Multiple Email Accounts
    E.    New Features in 2016
    F.    Advanced Microsoft Outlook 2016 Exam
XIV. Microsoft Outlook Final Exam

XV. Introduction to Microsoft Access 2016
    A.    Quick Overview of the Access User Interface  
    B.    Fundamentals  
    C.    Tables and Their Views  
    D.    Tables  
    E.    Queries  
    F.    Forms  
    G.    Reports  
    H.    Databases and Access Terms  
    I.    Introduction to Microsoft Access 2016 Exam  
XVI. Advanced Microsoft Access 2016
    A.    Relationships  
    B.    Queries  
    C.    Table Functions  
    D.    Forms  
    E.    Reports  
    F.    Macros  
    G.    Completing the Desktop Application  
    H.    Advanced Microsoft Access 2016 Exam  
XVII. Microsoft Access Final Exam 






Dean College
School of Professional and Continuing Studies
99 Main Street
Franklin, MA 02038-1994 US

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.