Microsoft Office Online Certification & Training Program — MedCerts

ATTN Employers: Sign up for our Career Fair on 5/18 & fill your openings! Sign up here.

Is Short-Term Online Career Training Right for You?

Take Free Quiz
Blog Search Apply

$2,000

Tuition
Ready to begin your career journey or have more questions? Connect with an Education Consultant today!

7 Weeks

Program Length

MOS

Certifications

$30,000

Avg. Starting Salary1
Issuing Authority

Is Microsoft Office Specialist Training Right for You?Take the MedCerts Online Career Training Readiness Quiz

Get Your Career Training Readiness Report
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.

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 Available In The US
According to Burning Glass jobs data, Microsoft Office Specialist will not see available jobs grow over the next ten years
1All available job and salary information is from Burning Glass Labor Insights and is updated annually to reflect industry changes.

Microsoft Office SpecialistMedCerts Tuition Options

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.

Pay in Full

$2,000
One Time Payment

Pay in full, up front.

Get the most value out of your education and focus on your studies instead of making monthly payments.

Monthly Payments

$173
12-MONTH PLAN

Starting with just $200 down!

Pick the payments that fit your life (or budget). Plans range from 4 to 12 months with 0% interest rates available!
Icon checkmark wavy encircled navy

No Credit Check

Discover your eligibility without a credit check.

Final pricing is given at time of purchase and may vary from the example pricing given above.

MyCAA, Army Credentialing Assistance and Workforce Grants

MedCerts offers financial aid options through MyCAA, WIOA and Army CA. You must be a Military spouse, active duty Army, Reserves, or National Guard member or WIOA eligible job seeker to receive aid.

Selecting the Right Training Option Program Comparisons

MedCerts training programs are some of the most competitively price ways to start a new career.

MedCerts Community College Online College
Program & Tuition Cost $4,000 average Up to $20,000 $3,000 average
Exam Fees, Books & Materials Included Up to $750 Up to $750
Job Ready In 3–6 months 24–48 months 3–6 months
Schedule Flexibility On-demand 24/7 Set class schedule On-demand 24/7
Travel Requirements None: 100% online On-campus classrooms None: 100% online
Student Support Personal Advisors: text, call, and email access Professors: scheduled office hours Support inbox
Career Coaching Exam-tailor + soft-skill training to build well-rounded careers Exam-based + prerequisites and electives to meet credit hour requirements Exam-specific only
Content Delivery 3D animations, immersive environments, interactive activities, game-based learning Professor lectures Varies: typically videos and presentations

This table is provided for reference only. Actual pricing may vary or change without notice. Pricing is based on an estimated full-cost tuition with fees for a Medical Assistant program or similar program before financial aid or other assistance. Data sampled from MedCerts, Oakland Community College, and Kaplan University.

Loved by students

Over 1000 Student Reviews

Rating by

Best Place To Get Certified

“I loved taking my courses with Medcerts. I like the fact I'm not set with a specific time and day to do my course work. Courses are easy to navigate and get through. I love working with my Students advisor, she was awesome always reaching out to encourage me as well as check up on me to see if i was having any issues. Over a great play to get your certification and know you will know what your doing when your done.”

Tara S

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.

skills gained

  • Prepare, edit and enhance documents in Microsoft Word
  • Apply methods to organize, calculate and analyze information using Microsoft Excel
  • Utilize multiple options for exchanging information and managing activities using Microsoft Outlook
  • Create professional-level presentations that are engaging and exciting using PowerPoint
  • Apply methods to store, organize and maintain data using Access database
Enrollment Requirements
  • High School Diploma or GED
  • Web browser with internet connection
  • Course registration & payment
  • A working version of Microsoft Office 2019 or Microsoft Office 365
  • WINDOWS Operating System
Materials Included
  • Expert-led video based training
  • Digital Cousrebooks
  • Competency assessments
  • National Certification exam fee
Student Services
  • Dedicated Student Success Advisors
  • Tailored support based on performance & behavior
  • Exam preparation process
  • Career Services Advisor

courses taken

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)
COURSES DURATION
MS 7000 1
MS 7000 2
MS 7000 1
MS 7000 1
MS 7000 2
Total Program Duration 7 Week

Eligible Certifications

Loved by students

4.3+ Rating

Rating by

MedCerts Is a Miracle.

“I am beyond to have found a program that not only help further your education, but the program is also flexible to accommodate your schedule. You don’t have to get your prerequisites out of the way and the program dives straight into the field you wish to build a career in.”

Shapri from Trustpilot

Microsoft Office SpecialistJob Opportunities

Office Administrator

$26000 – $50000
Estimated Salary

Entry-Level

Office / Administrative Assistant

$25000 – $43000
Estimated Salary

Career Potential

Executive Assistant

$34000 – $65000
Estimated Salary
Go to Top
Video iframe here
Chat Online 800-734-1175