Training Programs Microsoft Microsoft Office Specialist (MOS) Expert Certification Training (Vouchers Included)
cart-icn

You already have a course in your cart

You can only add one course to your cart at a time! By adding this course, you will replace the existing course from your cart. How would you like to proceed?

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

Prepare for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Outlook, and Access and earn your Microsoft Office Specialist (MOS) Expert Certification. Exam fees included for five exams.

microsoft-office-specialist-2019-cert-training-w-voucher
$2,745.00 (USD)

Have a question?We're here to help

Overview

Objective

Outline

  1. Introduction to Excel
    1. Microsoft Office Basics
    2. Creating a Microsoft Excel Workbook
    3. The Ribbon
    4. The Backstage View (The File Menu)
    5. The Quick Access Toolbar
    6. Entering Data in Microsoft Excel Worksheets
    7. Formatting Microsoft Excel Worksheets
    8. Editing Worksheets
    9. Working with Rows and Columns
    10. Using Formulas in Microsoft Excel
    11. Finalizing Microsoft Excel Worksheets
    12. Introduction to Excel Exam
  2. Intermediate Excel
    1. Common Functions
    2. Working with Lists
    3. Visualizing Your Data
    4. Working with Tables
    5. Advanced Formatting
    6. Intermediate Excel Exam
  3. Advanced Excel
    1. Using PivotTables
    2. Advanced Functions
    3. Auditing Workbooks
    4. Data Tools
    5. Working with Others
    6. Recording and Using Macros
    7. Advanced Excel Exam
    8. Final Excel Exam
  4. Introduction to Word
    1. Microsoft Office Basics
    2. Creating a Microsoft Word Document
    3. The Ribbon
    4. The Quick Access Toolbar
    5. Formatting Microsoft Word Documents
    6. Editing Documents
    7. Finalizing Microsoft Word Documents
    8. Introduction to Word Exam
  5. Intermediate Word
    1. Advanced Formatting
    2. Working with Tables
    3. Working with Images
    4. Page Layout
    5. Working with Illustrations
    6. Viewing Your Documents
    7. Intermediate Word Exam
  6. Advanced Word
    1. Working with Long Documents
    2. Reviewing and Collaborating on Documents
    3. Comparing and Combining Documents
    4. Forms
    5. Managing Mailings
    6. Protecting Documents
    7. Macros
    8. Advanced Word Exam
    9. Final Word Exam
  7. Introduction to PowerPoint
    1. Microsoft Office Basics
    2. Creating a Presentation
    3. The Ribbon
    4. The Quick Access Toolbar
    5. Formatting Presentations
    6. Working with Images
    7. Working with Tables and Charts
    8. Preparing and Presenting
    9. Introduction to PowerPoint Exam
  8. Advanced PowerPoint
    1. Customizing Presentations
    2. Presentation Masters
    3. Working with Special Effects
    4. Using SmartArt
    5. Multimedia
    6. Setting up the Slide Show
    7. Outlines and Slides
    8. Managing Multiple Presentations
    9. Finalizing Presentations
    10. Advanced PowerPoint Exam
    11. Final PowerPoint Exam
  9. Introduction to Microsoft Outlook
    1. The Outlook Interface
    2. Performing Popular Tasks in Outlook
    3. Working with Messages
    4. Working with the Calendar
    5. Organizing Contacts
    6. Introduction to Microsoft Outlook Exam
  10. Advanced Microsoft Outlook
    1. Working with Tasks and Notes
    2. Using Signature and Themes
    3. Managing Your Inbox
    4. Working with Multiple Email Accounts
    5. Advanced Microsoft Outlook Exam
    6. Final Outlook Exam
  11. Introduction to Access
    1. Quick Overview of the Access User Interface
    2. Fundamentals
    3. Tables and Their Views
    4. Tables
    5. Queries
    6. Forms
    7. Reports
    8. Introduction to Access Final Exam
  12. Advanced Access
    1. Relationships
    2. Queries
    3. Table Functions
    4. Form
    5. Reports
    6. Macros
    7. Completing the Desktop Application
    8. Advanced Access Final Exam
    9. Access Final Access Exam

Requirements

Prerequisites

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

Reviews

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO
Mercer County Community College

1200 Old Trenton Road
Trenton, NJ 08690 US
MAIN CONTENT

Copyright © 1997 - 2024 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Cengage Learning. Privacy Policy