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
03/09/20 - 03/20/20

Info/Enroll

03/23/20 - 04/03/20

Info/Enroll

04/13/20 - 04/24/20

Info/Enroll

04/27/20 - 05/08/20

Info/Enroll

06/08/20 - 06/19/20

Info/Enroll

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

    MCSE certification boot camps and courses are offered in these select cities: Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Portland MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

    MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

    CED Solutions offers MCSE certification boot camps and courses in the United States: MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Oregon, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

    MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.