Skip to main content

Microsoft Office Specialist 2019 (MOS) Certification Training (SE)

ID : 63831   
« back to classes page

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) certification demonstrates your knowledge of the Office and proves that you're ready to make an immediate impact at your organization.

This course prepares you for the Microsoft Office Specialist (MOS) 2019 certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MOS Certification Exams MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access) exams. This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

Class Outlines

  1. Microsoft Word 2019
    1. Introduction to Microsoft Word 2019
      1. Creating a Microsoft Word Document
      2. The Ribbon
      3. The File Tab
      4. The Quick Access Toolbar
      5. Formatting Microsoft Word Documents
      6. Editing Documents
      7. Finalizing Microsoft Word Documents
      8. Introduction to Microsoft Word 2019 Exam
    2. Intermediate Microsoft Word 2019
      1. Advanced Formatting
      2. Working with Tables
      3. Working with Images
      4. Page Layout
      5. Working with Illustrations
      6. Viewing Your Document(s)
      7. Intermediate Microsoft Word 2019 Exam
    3. Advanced Microsoft Word 2019
      1. Working with Long Documents
      2. Reviewing and Collaborating on Documents
      3. Comparing and Combining Documents
      4. Managing Mailings
      5. Protecting Documents
      6. Random Useful Items
      7. Advanced Microsoft Word 2019 Exam
    4. Microsoft Word Final Exam
  2. Microsoft Excel 2019
    1. Introduction to Microsoft Excel 2019
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel 2019 Exam
    2. Intermediate Microsoft Excel 2019
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel 2019 Exam
    3. Advanced Microsoft Excel 2019
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel 2019 Exam
    4. Microsoft Excel 2019 Final Exam
  3. Microsoft PowerPoint 2019
    1. Introduction to Microsoft PowerPoint 2019
      1. Creating a PowerPoint Presentation
      2. The Ribbon
      3. The Quick Access Toolbar
      4. The Backstage View (The File Menu)
      5. Formatting Microsoft PowerPoint Presentations
      6. Working with Images
      7. Working with Tables and Charts
      8. Finalizing Microsoft PowerPoint Presentations
      9. Introduction to Microsoft PowerPoint 2019 Final Exam
    2. Advanced Microsoft PowerPoint 2019
      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. Sharing and Securing a Presentation
      10. Advanced Microsoft PowerPoint 2019 Final Exam
    3. Microsoft PowerPoint 2019 Final Exam
  4. Microsoft Outlook 2019
    1. Introduction to Microsoft Outlook 2019
      1. The Outlook 2019 Interface
      2. Performing Popular Tasks in Outlook 2019
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook 2019 Exam
    2. Advanced Microsoft Outlook 2019
      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 2019 Exam
      6. Advanced Microsoft PowerPoint 2019 Final Exam
    3. Microsoft Outlook Final Exam
  5. Microsoft Access 2019
    1. Introduction to Microsoft Access 2019
      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 Microsoft Access 2019 Final Exam
    2. Advanced Microsoft Access 2019
      1. Relationships
      2. Queries
      3. Table Functions
      4. Forms
      5. Reports
      6. Macros
      7. Completing the Desktop Application
      8. Advanced Microsoft Access 2019 Final Exam
    3. Microsoft Access Final Exam
Requirements:
  • Hardware Requirements: This course must be taken on a PC. Macs are not compatible.

  • Software Requirements:

    • Windows 10 or later.
    • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
    • Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 is ideal, you can use the versions that comes with Office 365. Please note that there may be some differences between your version of these programs and what you see in the course.
    • Adobe Flash Player. Click here to download the Flash Player.
    • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
    • Software must be installed and fully operational before the course begins.
    • Other: Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and available online.

Class Details

0 Sessions

Location
Online

Instructor

CEUs : 33.5

Start Date:upon registration

 

Notice

Please read:  This course is self-paced so you can start when you want and finish at your own pace. When you register, you'll receive six (6) months to complete the course.

Tuition: 

$2,599.00


Registration Closes On
Sunday, August 23, 2020 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
N/A - Online

Contact Us!

ncal@normandale.edu - 952.358.8343
Normandale Community College - Continuing Education

9700 France Avenue South, Bloomington, MN 55431

A member of the Minnesota State Colleges & Universities System