Skip to Main Content

Administrative Professional with Microsoft Office Specialist 2019

Administrative Professional with Microsoft Office Specialist 2019

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

Enroll Now


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.

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

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 who 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 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
  • Associate's 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)

Continuing Education

Global Initiatives' Continuing Education offers and administers a variety of credit and non-credit programs that broaden the traditional Miami classroom experience for learners of all ages.