Executive Assistant with Microsoft Office Specialist (MOS) Expert (Vouchers Included)

Executive assistants possess a broad skill set and provide direct support to executive leadership. This executive assistant course will prepare you for two important certifications in your career: the International Association of Administrative Professionals (IAAP) Certified Administrative Professional (CAP) and the Microsoft Office Specialist (MOS) Expert credentials.

During this CAP and Microsoft Office certification training, you will learn the intricacies of organizational communication,...

18 Months / 570 Course Hrs

Open Enrollment

Offered in partnership with your preferred school

University of Central Florida

Change School

Learning method

Instructor-led

$6,058USD

Self-paced. Study on your own schedule

Enroll Now

for additional information

Details + Objectives

Course code: GES2082

What you will learn

Develop essential practical and managerial skills
Learn the fundamentals of administrative roles, including human resources, financial responsibilities, and event and project management
Apply organizational, project management and records management best practices
Strengthen organizational communication and administrative support skills
Build essential skills needed to effectively use the Microsoft Office suite
Use AI and Microsoft Copilot across Word, Excel, PowerPoint, and Outlook to support writing, editing, spreadsheet analysis, presentation creation, email communication, and meeting workflows

How you will benefit

Develop a high level of understanding of the CAP body of knowledge
Gain communication skills that will allow you to thrive in a professional environment
Set yourself apart from competitors by receiving management training
Explore your abilities as a leader and learn how to masterfully manage people and projects
Set yourself up for success in an administrative career by learning relevant, real-world Microsoft Office and management skills
Prepare for the MOS Expert (Word, Excel, PowerPoint, and Access) and IAAP CAP certification exams
Improved productivity: Increase workplace efficiency by using AI and Microsoft Copilot to streamline document creation, data analysis, presentation development, communication, scheduling, and collaboration tasks
Receive IAAP membership and study Guide upon qualification for the CAP exam

How the course is taught

Self-paced, online course
18 Months to complete
Open enrollment, begin anytime
570 course hours

Outline

Part 1 - Microsoft Office Specialist (MOS) Expert Certification Training

Lesson 1 - Introduction to Microsoft Excel Training

Microsoft Office Basics
Creating a Microsoft Excel Workbook
The Ribbon
The Backstage View (The File Menu)
The Quick Access Toolbar
Entering Data in Microsoft Excel Worksheets
Formatting Microsoft Excel Worksheets
Editing Worksheets
Working with Rows and Columns
Using Formulas in Microsoft Excel
Finalizing Microsoft Excel Worksheets
Using Copilot in Microsoft Excel

Lesson 2 - Intermediate Microsoft Excel Training

Common Functions
Working with Lists
Visualizing Your Data
Working with Tables
Advanced Formatting

Lesson 3 - Advanced Microsoft Excel Training

Using PivotTables
Advanced Functions
Auditing Workbooks
Data Tools
Recording and Using Macros
Working with Others

Lesson 4 - Introduction to Microsoft Word Training

Microsoft Office Basics
Creating a Microsoft Word Document
The Ribbon
The Backstage View (The File Menu)
The Quick Access Toolbar
Formatting Microsoft Word Documents
Editing Documents
Finalizing Microsoft Word Documents
Using Copilot in Microsoft Word

Lesson 5 - Intermediate Microsoft Word Training

Advanced Formatting
Working with Tables
Working with Images
Page Layout
Working with Illustrations
Viewing Your Documents

Lesson 6 - Advanced Microsoft Word Training

Working with Long Documents
Reviewing and Collaborating on Documents
Comparing and Combining Documents
Forms
Managing Mailings
Protecting Documents
Macros

Lesson 7 - Introduction to Microsoft PowerPoint Training

Microsoft Office Basics
Creating a Presentation
The Ribbon
The Quick Access Toolbar
The Backstage View (The File Menu)
Formatting Presentations
Working with Images
Working with Tables and Charts
Preparing and Presenting
Using Copilot in Microsoft PowerPoint

Lesson 8 - Advanced Microsoft PowerPoint Training

Customizing Presentations
Presentation Masters
Working with Special Effects
Using SmartArt
Multimedia
Setting up the Slide Show
Outlines and Slides
Managing Multiple Presentations
Finalizing Presentations

Lesson 9 - Introduction to Microsoft Outlook 365 Training

The Outlook Interface
Working with Messages
Working with the Calendar
Organizing Contacts
Working with Groups
Using Copilot in Microsoft Outlook

Lesson 10 - Advanced Microsoft Outlook 365 Training

Performing Popular Tasks
Working with Tasks and Notes
Using Signature and Themes
Managing Your Inbox
Working with Multiple Email Accounts

Lesson 11 - Introduction to Microsoft Access 365 Training

Databases and Access Terms
Quick Overview Access Interface
Fundamentals
Tables and Their Views
Tables
Queries
Forms
Reports

Lesson 12 - Advanced Microsoft Access 365 Training

Relationships
Advanced Queries
Table Functions
Advanced Forms
Advanced Reports
Macros
Completing the Desktop Application

Part 2 - Certified Administrative Professional

Lesson 1 - Organizational Communication (Part 1)

Understanding the Workplace Team
Interacting with Stakeholders
Communication Essentials

Lesson 2 - Organizational Communication (Part 2)

Networking
Motivation, Leadership, And Change Management
Public Speaking
International Business
Organizational Structures And Systems
Legal And Ethical Issues

Lesson 3 - Business Writing and Document Production

Business Writing
Software Applications
Managing Hardware and Software

Lesson 4 - Technology and Information Distribution

Information Systems
Telephone and Electronic Communication
Copyright Laws and Intellectual Property
Research and Analysis
Managing Remote Meetings
Information Distribution and Storage

Lesson 5 - Office and Records Management

Filing Standards
File Security
Creating Workspaces
Managing Materials and Supplies

Lesson 6 - Event and Project Management

Event Scheduling And Management
Travel Planning
Meeting Coordination
Project Management And Negotiations

Lesson 7 - Human Resources

Human Resources Terminology and Processes
Employee Handbooks, Training, and Standard Operating Procedures
Employee Records and Evaluation
Staffing And Onboarding
Human Resource Law and Harassment

Lesson 8 - Financial Functions

Budgeting Basics
Introduction to Financial Statements
Introduction to Banking and Statement Reconciliation

Lesson 9 - Workplace Behaviors and Activities (Part 1)

Goal Setting and Creativity
Problem Solving and Decision Making
Time Management and Stress Management

Lesson 10 - Workplace Behaviors and Activities (Part 2)

Planning And Controlling
Multitasking
Generational Distinctions
Diversity and Inclusion

Lesson 11 - Workplace Behaviors and Activities (Part 3)

Supply chain management
Purchasing and logistics
Scheduling
Customer service

Lesson 12 - Becoming an Administrative Assistant and Advancing Your Career

Duties and Traits
Position Options
Seeking Employment
Career Planning

Part 3 - Management Training

Lesson 1 - Introduction to Management Principles

Lesson 2 - The Role and Responsibilities of a Manager

Lesson 3 - Building a Personal Development Plan, Your Leadership Blueprint

Lesson 4 - Corporate Culture in the Management Context

Lesson 5 - Ethics and Social Responsibility

Lesson 6 - Diversity, Equity, and Inclusion (DEIB)

Lesson 7 - Strategic vs. Operational Thinking

Lesson 8 - Goal Setting and Prioritization

Lesson 9 - Planning and Execution

Lesson 10 - Decision-Making

Lesson 11 - Time and Project Management Fundamentals

Lesson 12 - Managing Human Talent

Lesson 13 - Managing Change

Lesson 14 - Customer Relationship Management

Lesson 15 - Leadership

Lesson 16 - Motivating Employees

Lesson 17 - Team Building and Collaboration

Lesson 18 - Managing Communication and Conflict

Lesson 19 - Controlling

Lesson 20 - Career Planning

Instructors & Support

Deven Matthews

Deven Matthews is a tenured professor with over a decade of higher education experience and extensive expertise in course design, hybrid instruction, and applied learning. An accomplished author and curriculum developer, he specializes in translating complex management concepts into practical, skill-based learning. Deven is known for mentoring students and creating engaging, career-ready programs that bridge theory and real-world practice.

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.

Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.

Requirements

Prerequisites:

You should have basic keyboarding and computer skills, be comfortable navigating the Internet and using email, and have an understanding of a word-processing program (such as Word). This course is intended for anyone interested in developing their management skills. You should also be comfortable using a personal computer and be familiar with Windows software.

Certification Requirements:

Certified Administrative Professional (CAP)

You must have previous experience as an administrative assistant to be eligible to sit for the Certified Administrative Professional certification exam.

Candidates must meet specific education and administrative office support professional experience, which are:

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

All relevant work experience must have been earned within the last ten years.

Relevant work experience qualifies as office and administrative professionals who engage in some, if not all, of the following:

Communicate within the organization (both verbal and written)
Conduct business writing, including proofreading and editing
Maintain office functions and record keeping
Plan meetings, events, and arrange travel
Manage projects
Engage in or support human relations activities, such as hiring and compliance issues
Maintain budgets and basic accounting functions
Manage time and other resources for themselves and others
Utilize technology, including virtual and mobile, with strong computer and internet research skills
Coordinate communications between internal staff and/or external clients

Please visit https://www.iaap-hq.org/page/Certification for more detailed information on eligibility.

Microsoft Office Specialist (MOS) Expert

To earn a Microsoft Office Specialist: Expert certification, you must complete the following requirements:

Earn a Microsoft Office Specialist Associate certification by passing three of the following Associate exams:

For students using Microsoft Office 2019/2021:
- MO-100: Microsoft Word
- MO-200: Microsoft Excel
- MO-300: Microsoft PowerPoint
- MO-400: Microsoft Outlook
For students using Microsoft Office 365:
- MO-110: Microsoft Word
- MO-210: Microsoft Excel
- MO-310: Microsoft PowerPoint
- MO-400: Microsoft Outlook

And pass any two of the following three Expert exams:

For students using Microsoft Office 2019/2021:
- MO-101: Microsoft Word Expert
- MO-201: Microsoft Excel Expert
- MO-500: Microsoft Access Expert
For students using Microsoft Office 365:
- MO-111: Microsoft Word Expert
- MO-211: Microsoft Excel Expert
- MO-500: Microsoft Access Expert

Requirements:

Hardware Requirements:

This course must be taken on a PC. Macs are not compatible.

Software Requirements:

PC: Windows 10 or later. (Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:

Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. Textbook assignments in each lesson of the CAP course will be linked to the eBook for the designated reading.

The Administrative Professional: Technology and Procedures (eBook)

The following digital textbook for the Management Training course is accessed via links in the course lessons:

Management, 15th Edition, by Richard Daft (eBook)

More About

About Certification: International Association of Administrative Professionals (IAAP)

The International Association of Administrative Professionals (IAAP) is a non-profit organization dedicated to connecting, teaching, and leading administrative professionals so they can excel in an ever-changing business world. IAAP was founded more than 70 years ago as the National Secretaries Association, and has become an internationally-recognized organization for the advancement of administrative professionals.

FAQ

Yes. You will prepare for the International Association of Administrative Professionals (IAAP) Certified Administrative Professional (CAP) exam, as well as Microsoft Office Specialist (MOS) Expert certification exams in Word, Excel, PowerPoint, and Access.

For most administrative professional positions, you will need a high school diploma or equivalent as well as some training which can be obtained in an online course like this one. There is a lot of competition for good administrative professional jobs, so getting formal training and earning a certification will put you ahead of the competition and make you more desirable to employers.

The median salary across all office and administrative support positions according to the Bureau of Labor Statistics is nearly $35,000 per year. Your salary will vary depending on the type of administrative job you choose. For example, a financial clerk earns a median salary of $38,680 while a receptionist earns $28,390 and secretaries earn $37,870. According to a research study conducted by Microsoft, entry-level professionals who obtain a certification can earn almost $16,000 more per year than those without certification.

Yes, administrative professionals are in demand, but there is expected to be little change in the total number of open positions in this field through 2026 according to the Bureau of Labor Statistics. Technology is expected to play a major role in this profession, so your understanding of courses like those in the Microsoft Office Suite will help you land coveted positions.

Administrative professionals typically work full time hours, between 35- 40 hours per week in an office environment, though some do work part time. It is even possible to work from home depending on your duties and your employer. You will spend large amounts of time in front of a computer using various software courses. You will also interact with other people on a daily basis either in person or via the phone.

In order to be a good administrative professional, you will need good communication skills as you will be responsible for working with people at many different levels within the organization. You will also need good organizational skills, a detail-oriented personality, and the ability to keep information you encounter private and confidential. In addition, you'll need to have good time management as well as the ability to prioritize tasks, and you will need to be dependable and reliable no matter what tasks you're assigned. Finally, you'll need to know how to provide good customer service.

You will receive six exam vouchers, one voucher for the CAP exam and five vouchers for the Microsoft MOS exams. This course fully prepares you to sit for the Word, Excel, and Access expert level exam. To earn the Microsoft Office Specialist (MOS) Expert Certification, you must earn the Associate certification by completing the MO-100 (Word), MO-200 (Excel), and MO-300 (PowerPoint) exams, and also complete two of the following expert exams: MO-101 (Word), MO-202 (Excel), or MO-500 (Access).

This course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

After you register, you will receive 18 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.

If you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.

Our courses are designed to accommodate various learning preferences. Depending on the course structure, you may get different forms of support. Self-paced courses are designed to be user-friendly and independent, minimizing the need for external support. In courses with instructors, our direct platform support feature includes opportunities for questions, discussions, and remediation, with email and phone support available for select courses. Our student advising team is available to guide you on program requirements and administrative requests, but they do not provide assistance with course content. Our goal is to provide you with the necessary support for success, whether it's through self-paced exploration, direct communication, or guidance from our advising team.

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

ed2go courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.

ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA, and Pell Grant. In some states, vocational rehab or workforce development boards may provide funding to take our courses. Additionally, you may qualify for financial assistance if you meet certain requirements. Learn more about financial assistance.

If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the "Contact Us."

Executive Assistant with Microsoft Office Specialist (MOS) Expert (Vouchers Included)

University of Central Florida