Chat with us, powered by LiveChat

Certified Administrative Professional with Microsoft Office Specialist 2016

Woman with a laptop

Prepare for the Certified Administrative Professional (CAP) and Microsoft Office Specialist (MOS) Exams

As business and office culture evolve, so do the responsibilities of administrative assistants. Many of these professionals give themselves a competitive edge by earning nationally-recognized CAP and MOS certifications. This 100% online course will help you gain the technical skills and knowledge needed to gain these valuable industry credentials.

Enroll Now

Job Outlook for Administrative Professionals

The Bureau of Labor Statistics states that the most recent median annual wage for secretaries and administrative assistants was $39,850. 

The Centers of Excellence (COE) for Labor Market Research’s “Top 100 Middle-Skills Jobs” listed Administrative Assistant as the #2 in-demand job in the Los Angeles and Inland Empire regions.

Among the Office and Administrative Support Occupations listed by the US Bureau of Labor Statistics (BLS), those that require MOS skills offer the highest levels of pay and future opportunities. For example, desktop publishers earn on average $45,390 per year. Computer support specialists earn an average of $54,760 per year in a category that is growing faster than the average for all jobs.

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.

Certified Administrative Professional FAQs

Do Administrative Professionals Need Certification?

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

How valuable is the CAP for administrative professionals?

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.

How many exams are required for the CAP certification?

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

  • No College Degree - 4 years of relevant work experience
  • Associates Degree - 3 years of relevant work experience
  • Bachelor's Degree - 2 years of relevant work experience

What is 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

How valuable is the MOS for administrative professionals?

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.

How many exams are required for the MOS certification?

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 Certified Administrative Professional (CAP)
  • Master the CAP body of knowledge
  • Understand administrative fundamentals including financial responsibilities and project management

Microsoft Office Specialist 2016

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

Enroll Now


There are no prerequisites to take this course.


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 Documentation 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.

Course Hours
: 425    Tuition: $4,395    Credits: 43

You may qualify for WIOA grant funding. Find out more.

IAAP logo


Becky Swaim

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

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.

Request Information