MS 7000

Microsoft Office Specialist

Online Certification Training

This program teaches basic computer competency, business communication, business etiquette, problem-solving and more.

Connect with an Education Consultant today!

7  Weeks
Program Length
MOS
Certification
$30,000
Avg. Starting Salary*
Microsoft Logo
Issuing Authority

Is Microsoft Office Specialist Training Right For You? Take The MedCerts Online Career Training Readiness Quiz

This fun, online quiz takes just 3 minutes to complete and provides you with a personalized report to find out if short-term online career training is right for you. The report identifies your strengths and social style, plus the training and positions you’re best suited for.

Get Your Career Training Readiness Report

Microsoft Office Specialist Online Training

MedCerts Tuition Advantage

We believe everyone should have access to higher education. With the option to pay in full, break down payments or utilize government grant funding, we help expand that access.

Monthly Payment Options Starting at $116 Payment Plans for Every Student

Talk with an Education Consultant to pick the perfect payment plan, from paying in full to installments with interest rates from 0-12%.

Total Tuition $2,000 Pay in Full

The total tuition can be paid immediately or through a number of grant-funded or monthly payment plan options

Request Information
Checkmark

No Credit Check

Discover your eligibility without a credit check.

The pricing listed above for a monthly payment plan is an estimate for the cost of an 18-month payment plan including down payment. Final pricing is given at time of purchase and may vary from both pricing examples above.

MyCAA, Department of Defense Credentialing Assistance/COOL and Workforce Grants

MedCerts offers financial aid options through these government grant-funded programs – MyCAA, Workforce Funding (including WIOA), and Department of Defense Credentialing Assistance or COOL funding for the Army, Air Force and Coast Guard. Those eligible include Military Spouses; active duty Army, Reserves, and National Guard members; active duty Air Force, Air Force Reserve, Air Force National Guard, and US Space Force; active duty Coast Guard and SELRES members (enlisted and officers); or workforce-funded qualifying job seekers. Speak to an Education Consultant to see if you qualify.

Trustpilot

What Does a Microsoft Office Specialist Do?

Whether entering the workplace or advancing your career, expertise with Microsoft Office applications is essential for office administrators and clerical support staff. Microsoft Office is a popular suite of software used to create memos, spreadsheets and presentations, manage calendars, organize contacts and to store and manage data.

366,766
Entry Level Jobs in the US
Microsoft Office Specialists will not see available jobs growth over the next ten years.
All available job and salary information is from Burning Glass Labor Insights and is updated annually to reflect industry changes.

What You’ll Learn
MS 7000
Microsoft Office Specialist

Our comprehensive Microsoft Office certification online courses provide training that starts at the fundamental level to ensure the basics are covered – which is perfect for a beginner or those in need of a basic refresher. The curriculum gradually builds into intermediate and advanced topics, but only after you’ve demonstrated mastery of the preceding subject matter.

This set of courses will provide the range of skills needed to create professional-quality documents while teaching to store, transmit, and modify data using a variety of Microsoft Office applications. You’ll learn to effectively communicate and collaborate within an office environment using these tools. The content covered includes how to create, edit and enhance documents in Microsoft Word, how to organize, calculate and analyze information in Microsoft Excel, how to exchange information and manage your activities in Microsoft Outlook, and how to create effective and robust presentations in Microsoft PowerPoint. Additional skills include gaining an understanding of basic database design principles and maintaining basic Microsoft Access database objects, including tables, relationships and data entry forms.

Graduating from this program makes you eligible for five (5) Microsoft certification exams, administered by Certiport – which has testing sites located across the United States. Passing any one of these exams results in certification as a Microsoft Office Specialist (MOS). MedCerts will cover the cost of ONE (1) exam of the student’s choosing, in addition to the corresponding practice test.

Prerequisites:

Students must have a working version of Microsoft Office installed on their computer throughout the term of their enrollment. Because the MedCerts training is aligned with Microsoft Office 2019 and Microsoft Office 365, it is required that students have either version installed on a computer with a WINDOWS Operating System. Upon program completion, students will be eligible for a hands-on practice test (paid for by MedCerts) that mimics the format of the actual certification exam. Please note: the version of the practice test ordered must match the version of the certification exam taken.

Show More
Hide
  1. Prepare, edit and enhance documents in Microsoft Word
  2. Apply methods to organize, calculate and analyze information using Microsoft Excel
  3. Utilize multiple options for exchanging information and managing activities using Microsoft Outlook
  4. Create professional-level presentations that are engaging and exciting using PowerPoint
  5. Apply methods to store, organize, and maintain data using Access database
Microsoft Office Specialist Hero

Enrollment Requirements

  1. High School Diploma or GED
  2. Web browser with internet connection
  3. Course registration & payment
  4. A working version of Microsoft Office 2019 or Microsoft Office 365.
  5. A WINDOWS Operating System

MedCerts-Covered Materials*

  1. Expert-led video based training
  2. Competency assessments
  3. National Certification exam fee

Student Services

  1. Dedicated Student Success Advisors
  2. Tailored support based on performance & behavior
  3. Exam preparation process
  4. 1 yr. post-program access to Career Center & Career Coaches

*The cost of all materials needed for this program are covered by MedCerts. They are not included in the tuition costs and the student is not liable for any costs or fees related to the above materials.

Required Courses
MS 7000

Microsoft Word - Levels 1-3

16 hours
Length
1 Week
Duration

Microsoft Word Level 1: This course is designed to introduce students to the basic functionality and user interface of Microsoft Word 2019. In this course, students will learn the basics of saving and opening documents and review the interface. Students will practice text navigation, selection, entry, and various other text formatting and editing commands and features. Additionally, students will work with bulleted and numbered lists, tables, and their various features and options. Students will also work with graphics and the various tools available in Word 2019 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare document for distribution and publication. 

Microsoft Word Level 2:  This is the intermediate course in the Microsoft Word 2019 series. This course expands upon the topics covered in the Word 2019 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.

Microsoft Word Level 3:  In this advanced course, students will automate with Microsoft Word through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms. 

    • Learn the basics of saving and opening documents
    • Work with, create, manage, and customize Styles, Templates, and Themes
    • Automate with Microsoft Word through the use of building blocks, Quick Parts, fields, and Macros
    • Work with Outline View and master documents, Mail Merge, and forms
MS 7000

Microsoft Excel - Levels 1-3

32 hours
Length
2 Weeks
Duration

Microsoft Excel Level 1:  Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. 

Microsoft Excel Level 2: This course is designed to be the intermediate level of Excel 2019. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

Microsoft Excel Level 3: This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

    • Understand how to create, save, enter data, and print spreadsheets
    • Create formulas and use functions to calculate in Excel
    • Learn functions such as SUMIF, AVERAGEIF, and COUNTIF
    • Advanced use of PivotTables and PowerPivot add-in
    • Work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks
MS 7000

Microsoft Outlook - Levels 1-2

16 hours
Length
1 Week
Duration

Microsoft Outlook Level 1:  This course is designed to teach students the basics of Microsoft Outlook 2019 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.   

Microsoft Outlook Level 2:  In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2019. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review advanced calendar and task usage, rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data. 

    • Understand the basics of email, how to use the Help feature, how to create and send messages
    • Learn organizational techniques through the use of folders, views, categories, flags, and searching
    • Review advanced calendar and task usage, rules and automation, cleanup commands
    • Utilize advanced graphic options, junk mail options, import and export features
MS 7000

Microsoft PowerPoint - Levels 1-2

16 hours
Length
1 Week
Duration

Microsoft PowerPoint Level 1:  In this course, students will get started with PowerPoint 2019 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, various graphic options and insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options.   

Microsoft PowerPoint Level 2:  In this course, students will learn the various collaboration tools in Microsoft PowerPoint 2019 such as reusing slides, creating slides from Word, and working with Excel. Students will learn to utilize the power of Slide Masters, create custom themes, and design custom templates. In addition, students will learn to create exciting presentations by animating text and objects, add slide transitions, and use advanced graphic features including SmartArt, and audio and video. Finally, students will present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, timings, recordings, and creating videos, and review additional advanced slideshow options.

    • Become familiar with the Ribbon, interface, and navigation options
    • Review presentation editing options, text formatting options, various graphic options and insertion methods
    • Learn the various collaboration tools such as reusing slides, creating slides from Word, and working with Excel
    • Present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, and more
MS 7000

Microsoft Access - Levels 1-3

32 hours
Length
2 Weeks
Duration

Microsoft Access Level 1:  This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.

Microsoft Access Level 2: This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course. 

Microsoft Access Level 3: Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events. 

    • Become familiar with various database components, concepts, and terminology
    • Create databases, create objects, perform calculations, navigate and work with tables
    • Learn how to automate processes with Macros, advanced form techniques, and advanced report techniques
    • Review how to improve the structure of an Access database
    • Configure security and multi-user environments and automate processes with VBA  (Visual Basic for Applications)
Code Course Duration
MS 7000 1 Week
MS 7000 2 Weeks
MS 7000 1 Week
MS 7000 1 Week
MS 7000 2 Weeks
Total Program Duration 7 Weeks

Eligible Certifications

MOS Online Microsoft Office Specialist Certification Course

Microsoft Office Specialist

Job Opportunities

Office Administrator

$26,000 – $50,000*
Estimated Salary
Entry Level

Office / Administrative Assistant

$25,000 – $43,000*
Estimated Salary
Career Potential

Executive Assistant

$34,000 – $65,000*
Estimated Salary

Disclaimers

  1. Prerequisites: Students must have a working version of Microsoft Office installed on their computer throughout the term of their enrollment. Because the MedCerts training is aligned with Microsoft Office 2019 and Microsoft Office 365, it is required that students have either version installed on a computer with a WINDOWS Operating System. Upon program completion, students will be eligible for a hands-on practice test (paid for by MedCerts) that mimics the format of the actual certification exam. Please note: the version of the practice test ordered must match the version of the certification exam taken.