Become a Certified Administrative Professional and Microsoft Office Specialist

To keep up with the fast-paced business world, many administrative assistants are earning their Certified Administrative Professional (CAP) and Microsoft Office Specialist (MOS) credentials. This 100% online course will help you gain the technical skills and knowledge needed to gain these valuable industry certifications.

Job Outlook for Administrative Professionals

The Bureau of Labor Statistics (BLS) reports that the median annual wage for administrative assistants is over $39,000.

The BLS also found that office and administrative support occupations that require MOS skills offer the highest levels of pay. For example, desktop publishers earn on average $45,390 per year.

According to, holders of the MOS certification earn an average of $54,000 per year. With skills in a specific domain such as legal or financial, the pay can increase to $67,000 or higher.

FAQs about Social Media Marketing

No. However, as the modern office shifts to becoming more technology driven, having formal training is key to advancing your skill set and staying ahead of the curve. Employers want candidates that can hit the ground running in their organization without further training, which certification proves.

CAP is an assessment-based certification for office and administrative professionals. As an industry-recognized certification, it designates that you understand the duties, responsibilities and knowledge required of an administrative professional in the today’s workplace.

To be eligible for the CAP exam, candidates must meet the following requirements:

  • No college degree: 4 years of relevant work experience
  • Associate degree: 3 years of relevant work experience
  • Bachelor’s degree: 2 years of relevant work experience

Relevant work experience includes typical duties for office and administrative professionals including:

  • Conducting business communication, including emails and memos
  • Overseeing office functions and record keeping
  • Managing projects, budgets and meeting schedules
  • Coordinating between staff and clients

MOS is the most well-known computer skills certification for administrative professionals. Globally, Microsoft Office is the leading office software with many organizations heavily invested in Microsoft technology. Having MOS certification on your professional profile shows employers that you are proficient in widely-used Office programs.

To earn your MOS certification, you must pass the following exams: MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access).

Course Objectives

Certified Administrative Professional

  • Prepare to take the CAP exam.
  • Master the CAP body of knowledge.
  • Understand administrative fundamentals including financial responsibilities and project management.

Microsoft Office Specialist 2019

  • Prepare to take and the MOS certification exams for Word, Excel, PowerPoint, Outlook, and Access.
  • Learn essential skills required of the Microsoft Office 2019 suite.
  • Understand how these program fit into today’s office and how to best use them.


Certified Administrative Professional

  • Organizational Communication (Part 1): Communication essentials; interacting with stakeholders and teams
  • Organizational Communication (Part 2): Organizational structure and systems; networking, interpersonal interactions and public speaking
  • Business Writing And Document Production: Business writing; publishing web documents, hard-copy documents, and meeting minutes
  • Technology and Information Distribution: Researching, gathering, compiling, and analyzing data and information; networks for information distribution and maintaining, backing-up, and storing data
  • Office and Records Management: The basics of creating functioning and productive workspaces; obtaining and managing resources for your office and working in a virtual office
  • Event and Project Management: Event and travel management: coordinating virtual meetings; project management, time management and negotiations
  • Human Resources: Human resources functions, duties, and processes; employee files, records and training
  • Financial Functions: Organizational finance: budgeting, financial statements, and financial transactions; banking process and the bank statement reconciliation process
  • Workplace Behaviors: Goal-setting and creativity; problem solving, decision making and time management
  • Becoming An Administrative Assistant And Advancing Your Career: Job duties, responsibilities and personal characteristics of administrative assistants

Microsoft Office Specialist 2016

  • Introduction: Learn about best communication practices, expectations and how to make yourself a viable asset to any team.
  • Excel: Understand how to work within Microsoft Excel. Enter data and create worksheets, cover advanced topics like using formulas, visualizing data and how to collaborate with other Excel users.
  • Word: Create and edit Word documents. Learn to use tables, images, illustrations, and change page layout. Additionally, you’ll cover how to review and collaborate on documents, manage mailings and protect documents.
  • Powerpoint: Develop PowerPoint presentations from start to finish. Understand how to format your presentations, and include advanced elements like effects, illustrations and tables.
  • Outlook: Master Microsoft Outlook by learning to work with messages, organize contacts, manage an inbox and work across multiple email accounts.
  • Access: Complete the course by developing an understanding of Access. Receive an overview of the user interface before moving on to covering tables, queries, forms, reports and macros.


Becky Swaim has taught since 2000, focusing on Administrative Assistant Fundamentals, Administrative Assistant Applications, and Individual Excellence. She holds a Bachelor of Arts in Speech Communication from California State University, Long Beach. Her experience includes managing large staff in medical billing and collections and as a program manager to various medical practices.


Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993. She helps organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, reporting/productivity applications, Microsoft Office, as well as the creation of online courses with software from leading vendors.   

Registration and Enrollment

This course is 100% online. Start anytime.