Online Microsoft Office Specialist Course

Whether you’re expanding your Microsoft Office skills for personal use, starting a new career, or working towards career advancement, our courses are the training you’re looking for.

Register for this course by November 23 and take 10% off tuition cost.*  

Register

QUICK DETAILS

Towson University Continuing & Professional Studies’ Online Microsoft Office 2019 Specialist Program allows you to get up to speed quickly on the latest version of Microsoft Office with step-by-step instructions.

Upon completion of either course, you will be prepared for the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, Access, and Outlook.

Total Hours: 335

Tuition: $2,899 includes instructional materials as downloadable PDFs as well as five exam vouchers to take the Word, Excel, PowerPoint, Access, and Outlook certification exams.

Location: Online

This course is WIOA approved and is on the Maryland Eligible Training Provider List (ETPL).

This course is delivered by our education partners at ed2go.

Upcoming Date Schedule REGISTER
Open enrollment. Begin anytime. Set your own. Must be completed within six months of registration. Register

We create opportunities for Greater Baltimore’s Workforce. 

Learn More

Have questions? We have answers.

Request Information

More About The Courses

Microsoft Office skills are important to have in any profession or workplace. Being able to work with Office programs is a must in today’s workplace whether you are preparing for an entry-level position or are an experienced professional. The material is presented in a step-by-step manner, and you will learn by completing readings and hands-on exercises, as well as watching video presentations. The course also includes quizzes and exams so you can test your skills at regular intervals throughout the material.

If you’re looking for a way to get up to speed quickly on the newest version of Microsoft Office, this course offers step-by-step instructions to make it easy.

  • Learn essential skills required of the Microsoft Office suite including Word, Excel, PowerPoint, Access, and Outlook.
  • Know how to create and edit a Word document.
  • Present information in a compelling way via Excel or PowerPoint.
  • Manage databases and improve efficiency using Access.
  • Send messages, manage calendars, and collaborate with coworkers across Outlook.

Excel

Module 1. Introduction to Microsoft Excel 2019

  • Creating a Microsoft Excel Workbook
  • The Ribbon
  • The Backstage View (The File Menu)
  • Entering Data in Microsoft Excel Worksheets
  • Formatting Microsoft Excel Worksheets
  • Using Formulas in Microsoft Excel
  • Working with Rows and Columns
  • Editing Worksheets
  • Finalizing Microsoft Excel Worksheets
  • Introduction to Microsoft
  • Excel 2019 Exam

Module 2. Intermediate Microsoft Excel 2019

  • Advanced Formulas
  • Working with Lists
  • Working with Illustrations
  • Visualizing Your Data
  • Working with Tables
  • Advanced Formatting
  • Intermediate Microsoft Excel 2019 Exam

Module 3. Advanced Microsoft Excel 2019

  • Using Pivot Tables
  • Auditing Worksheets
  • Data Tools
  • Working with Others
  • Recording and Using Macros
  • Random Useful Items
  • Advanced Microsoft Excel 2019 Exam

Module 4. Microsoft Excel 2019 Final Exam

Word

Module 5. Introduction to Microsoft Word 2019

  • Creating a Microsoft Word Document
  • The Ribbon
  • The File Tab
  • The Quick Access Toolbar
  • Formatting Microsoft Word Documents
  • Editing Documents
  • Finalizing Microsoft Word Documents
  • Introduction to Microsoft Word 2019 Exam

Module 6. Intermediate Microsoft Word 2019

  • Advanced Formatting
  • Working with Tables
  • Working with Images
  • Page Layout
  • Working with Illustrations
  • Viewing Your Document(s)
  • Intermediate Microsoft Word 2019 Exam 

Module 7. Advanced Microsoft Word 2019

  • Working with Long Documents
  • Reviewing and Collaborating on Documents
  • Comparing and Combining Documents
  • Managing Mailings
  • Protecting Documents
  • Random Useful Items
  • Advanced Microsoft Word 2019 Exam

Module 8. Microsoft Word 2019 Final Exam 

PowerPoint

Module 9. Introduction to Microsoft PowerPoint 2019

  • Creating a PowerPoint Presentation
  • The Ribbon
  • The Quick Access Toolbar
  • The Backstage View (The File Menu)
  • Formatting Microsoft PowerPoint Presentations
  • Working with Images
  • Working with Tables and Charts
  • Finalizing Microsoft PowerPoint Presentations
  • Introduction to Microsoft PowerPoint 2019 Exam

Module 10. Advanced Microsoft PowerPoint 2019

  • Customizing Presentations
  • Presentation Masters
  • Working with Special Effects
  • Using SmartArt
  • Multimedia
  • Setting up the Slide Show
  • Outlines and Slides
  • Managing Multiple Presentations
  • Sharing and Securing a Presentation
  • Advanced Microsoft PowerPoint 2019 Exam

Module 11. Microsoft PowerPoint 2019 Final Exam

Outlook

Module 12. Introduction to Microsoft Outlook 2019

  • The Outlook 2019 Interface
  • Performing Popular Tasks in Outlook 2019
  • Working with Messages
  • Working with the Calendar
  • Organizing Contacts
  • Introduction to Microsoft Outlook 2019 Exam

Module 13. Advanced Microsoft Outlook 2019

  • Working with Tasks and Notes
  • Using Signature and Themes
  • Managing Your Inbox
  • Working with Multiple Email Accounts
  • Advanced Microsoft Outlook 2019 Exam

Module 14. Microsoft Outlook 2019 Final Exam

Access

Module 15. Introduction to Microsoft Access 2019

  • Quick Overview of the Access User Interface
  • Fundamentals
  • Tables and Their Views
  • Tables
  • Queries
  • Forms
  • Reports
  • Introduction to Microsoft Access 2019 Exam  

Module 16. Advanced Microsoft Access 2019

  • Relationships
  • Queries
  • Table Functions
  • Forms
  • Reports
  • Macros
  • Completing the Desktop Application
  • Advanced Microsoft Access 2019 Exam

Module 17. Microsoft Access 2019 Final Exam

Download Course Outline (PDF)

To be successful, you must have familiarity with using a personal computer and in a Windows environment. You must also be able to launch and close programs, navigate to information stored on the computer, and manage files and folders.

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.

To earn the “MOS” status, you must pass three of the exams. Each application requires you to take and pass a separate exam.

Learn more about the Microsoft certification exams for Microsoft Office Specialist.

Hardware Requirements

  • This course must be taken on a PC. A Mac is not compatible.

Software Requirements

  • PC: Windows 10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Windows Media Player.
  • Microsoft Office 2016 or 2019 Suite, depending on enrolled course.
  • Adobe Flash Player. Download the Flash Player.
  • Adobe Acrobat Reader. Download the Acrobat Reader.
  • Software is not included in the cost of tuition. All software must be installed and fully operational before the course begins.

Other

  • Email capabilities and access to a personal email account.

Students are responsible for additional exam fees, including proctor fees, incurred when scheduling exams. 

*NOTE: WIOA, G.I. Bill®, and other specialized workforce assistance programs are not eligible for discounts.