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



Microsoft Office Specialist 2013 (MOS) Certification Training Course

Microsoft Office Specialist 2013 (MOS)

Course Number: #CED-1195
Course Length: 12 days
Number of Exams: 4
Certifications: MOS - Microsoft Office Specialist 2013 Certification

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

Upcoming Dates Class Times Class Format Quote
12/4 - 12/15, 2017 8:00 AM - 5:00 PM Instructor-Led Quote
3/12 - 3/23, 2018 8:00 AM - 5:00 PM Instructor-Led Quote
5/14 - 5/25, 2018 8:00 AM - 5:00 PM Instructor-Led Quote

Instructor-Led

  • Roundtrip Airfare & Lodging
    (Atlanta boot camps only)
  • Hands-on instruction by a certified instructor
  • Includes all course materials
  • On-site Testing
  • Lunch & Snacks provided each day
  • Practice Exam
  • Certification Exam

$500 Gift Card for the Holidays!

Purchase your class now and choose your $500 Gift Card.

Expires December 25, 2017.


Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Like us on Facebook and SAVE $100 on your next course

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 Office Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions. This boot camp covers certification for Word 2013, PowerPoint 2013, Excel 2013, and Access 2013.  The course begins with Word training, exam prep, and the certification exam.  It is followed by Excel 2013, Access 2013, and PowerPoint 2013.

A Microsoft Office Specialist (MOS) certification helps validate proficiency in using Microsoft Office 2013 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 2013 - Level 1

Course Content

Lesson 1: Getting Started with Word
Lesson 2: Editing a Document
  • Select and Modify Text
  • Find and Replace Text
Lesson 3: Formatting Text and Paragraphs
  • Apply Character Formatting
  • Align Text Using Tabs
  • Display Text as List Items
  • Control Paragraph Layout
  • Apply Borders and Shading
  • Apply Styles and Manage Formatting
Lesson 4: Adding Tables
  • Insert, Modify, and Format a Table
  • Convert Text to a Table
Lesson 5: Managing Lists
  • Sort, Renumber, and Customize a List
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 a Watermark
  • Add Headers and Footers
  • Control Page Layout
Lesson 8: Proofing a Document
  • Check Spelling and Grammar
  • Check Accessibility
Lesson 9: Customizing the Word Environment
  • Customize the Word Interface
  • Additional Save Options

[ back to top ]

Microsoft Word 2013 - Level 2

Course Content

Lesson 1: Working with Tables and Charts
  • Sort Table Data and Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart
Lesson 2: Customizing Formats Using Styles and Themes
  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes
Lesson 3: Using Images in a Document
  • Resize and Adjust an Image Appearance
  • Integrate Pictures and Text
  • Insert and Format Screenshots and Video
Lesson 4: Creating Custom Graphic Elements
  • Create Text Boxes and Pull Quotes
  • Draw Shapes
  • Add WordArt and Other Text Effects
  • Create Complex Illustrations with SmartArt
Lesson 5: Inserting Content Using Quick Parts
  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts
Lesson 6: Controlling Text Flow
  • Control Paragraph Flow
  • Insert Section Breaks and Columns
  • Link Text Boxes to Control Text Flow
Lesson 7: Using Templates
  • Create a Document Using a Template
  • Create a Template
Lesson 8: Using Mail Merge
Lesson 9: Using Macros

[ back to top ]

Microsoft Word 2013 - Level 3

Course Content

Lesson 1: Collaborating on Documents
  • Modify User Information
  • Share a Document
  • Compare Document Changes
  • Review a Document
  • Merge Document Changes
  • Review Tracked Changes
  • Coauthor Documents
Lesson 2: Adding Reference Marks and Notes
  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography
Lesson 3: 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 4: Securing a Document
  • Suppress Information
  • Set Formatting and Editing Restrictions
  • Add a Digital Signature to a Document
  • Restrict Document Access
Lesson 5: Forms
  • Create Forms
  • Manipulate Forms

[ back to top ]

Microsoft PowerPoint 2013 - Level 1

Course Content

Lesson 1: Getting Started with PowerPoint
Lesson 2: Developing a PowerPoint Presentation
  • Select a Presentation Type
  • View and Navigate a Presentation
  • Edit Text and Build a Presentation
Lesson 3: Performing Advanced Text Editing
  • Format Characters
  • Format Paragraphs
  • Format Text Boxes
Lesson 4: Adding Graphical Elements to Your Presentation
  • Insert Clip Art and Images
  • Insert Shapes
Lesson 5: Modifying Objects in Your Presentation
  • Edit Objects
  • 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 2013 - Level 2

Course Content

Lesson 1: Modifying the PowerPoint Environment
  • Customize the User Interface
  • Set PowerPoint 2013 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 to a Presentation
  • Create SmartArt
  • Modify SmartArt
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 2013 - Level 1

Upon successful completion of this course, students will be able to:

  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel 2013
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
Lesson 2: Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas
Lesson 3: Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
Lesson 5: Printing Workbooks
  • Preview and Print a Workbook
  • Define the Page Layout
Lesson 6: Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

[ back to top ]

Microsoft Excel 2013 - Level 2

Upon successful completion of this course, students will be able to:

  • use advanced formulas.
  • organize worksheet and table data using various techniques.
  • create and modify charts.
  • analyze data using PivotTables, Slicers, and PivotCharts.
  • insert and modify graphic objects in a worksheet.
  • customize and enhance workbooks

Course Content

Lesson 1: Calculating Data with Advanced Formulas
  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

[ back to top ]

Microsoft Excel 2013 - Level 3

Upon successful completion of this course, students will be able to:

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets and analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.

Course Content

Lesson 1: Streamlining Workflow
  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
Lesson 3: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
Lesson 4: Analyzing Data
  • Create a Trendline, Sparklines, and Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
Lesson 6: Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File
  • Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

[ back to top ]

Microsoft Access 2013 - Level 1

Course Content

Lesson 1: Getting Started with Access
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access
Lesson 2: Working with Table Data
  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups
Lesson 3: Querying a Database
  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data
Lesson 5: Generating Reports
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
Lesson 6: Customizing the Access Environment
  • The Access Options Dialog Box

[ back to top ]

Microsoft Access 2013 - Level 2

Course Content

Lesson 1: Designing a Relational Database
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
Lesson 2: Joining Tables
  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries
Lesson 3: Organizing a Database for Efficiency
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
Lesson 4: Sharing Data Across Applications
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge
Lesson 5: Advanced Reporting
  • Organize Report Information
  • Format Reports
  • 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 2013 training, MOS 2013 training training, MOS 2013 training certification, MOS 2013 training boot camp, MOS 2013 training certification training, MOS 2013 training certification course, MOS 2013 training course, MOS 2013 training class.



MOS 2013 training space
Search classes by keyword:
Search classes by category:


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