Administrative Professional with Microsoft Office Specialist 2019

Smiling man looks up from computer

Administrative Professional with Microsoft Office Specialist 2019

Course Code: GES2047
Course Hours: 425
Allotted Time to Complete Course: 12 Months
Prerequisites: None

IAAP logo

Enroll Now

Why should you become a Certified Administrative Professional with Microsoft Office Specialist 2019?

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.

Certified Administrative Professional FAQ

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

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 2019
Prepare to take and 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 program fit into today’s office and how to best use them

Course Curriculum

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 2019

Learn about best communication practices, expectations and how to make yourself a viable asset to any team.

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.

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.

Develop PowerPoint presentations from start to finish. Understand how to format your presentations, and include advanced elements like effects, illustrations and tables.

Master Microsoft Outlook by learning to work with messages, organize contacts, manage an inbox and work across multiple email accounts.

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.

Enroll Now