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

Executive assistants possess a broad skill and provide direct support to executive leadership. This course will prepare you for two important certifications in your career as an executive assistant: Certified Administrative Professional (CAP) and Microsoft Office Specialist (MOS) Expert.

You will learn the intricacies of organizational communication, office and records management, and human resources fundamentals, among other topics. You will then learn to how to use Microsoft Office programs...

SHARE
18 Months / 785 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

George Mason University

Change School
Learning method

for additional information

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

Enroll Now

Course code: GES2082

What you will learn

  • Develop basic practical and managerial skills
  • The fundamentals of administrative roles including human resources, financial responsibilities, and event and project management
  • Prepare for the IAAP Certified Administrative Professional exam
  • Essential skills need to effectively use the Microsoft Office suite

How you will benefit

  • Develop a high level of understanding of the Certified Administrative Professional (CAP) body of knowledge
  • Develop communication skills that will allow you to thrive in a professional environment
  • Set yourself apart from competitors by receiving management training
  • Receive IAAP Membership and Study Guide upon qualification for the CAP exam
  • 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 skills
  • Be prepared for the Microsoft Office Specialist (MOS) Expert Certification exams
  • Gain critical Microsoft Office skills and apply them in the workplace

How the course is taught

  • Self-paced, online course
  • 18 Months to complete
  • Open enrollment, begin anytime
  • 785 course hours
  1. Microsoft Office Specialist (MOS) Expert Certification Training
    1. Microsoft Word
      1. Introduction to Microsoft Word
        1. Creating a Microsoft Word Document
        2. The Ribbon
        3. The File Tab
        4. The Quick Access Toolbar
        5. Formatting Microsoft Word Documents
        6. Editing Documents
        7. Finalizing Microsoft Word Documents
        8. Introduction to Microsoft Word Exam
      2. Intermediate Microsoft Word
        1. Advanced Formatting
        2. Working with Tables
        3. Working with Images
        4. Page Layout
        5. Working with Illustrations
        6. Viewing Your Document(s)
        7. Intermediate Microsoft Word Exam
      3. Advanced Microsoft Word
        1. Working with Long Documents
        2. Reviewing and Collaborating on Documents
        3. Comparing and Combining Documents
        4. Managing Mailings
        5. Protecting Documents
        6. Random Useful Items
        7. Advanced Microsoft Word Exam
      4. Microsoft Word Final Exam
    2. Microsoft Excel
      1. Introduction to Microsoft Excel
        1. Creating a Microsoft Excel Workbook
        2. The Ribbon
        3. The Backstage View (The File Menu)
        4. Entering Data in Microsoft Excel Worksheets
        5. Formatting Microsoft Excel Worksheets
        6. Using Formulas in Microsoft Excel
        7. Working with Rows and Columns
        8. Editing Worksheets
        9. Finalizing Microsoft Excel Worksheets
        10. Introduction to Microsoft Excel Exam
      2. Intermediate Microsoft Excel
        1. Advanced Formulas
        2. Working with Lists
        3. Working with Illustrations
        4. Visualizing Your Data
        5. Working with Tables
        6. Advanced Formatting
        7. Intermediate Microsoft Excel Exam
      3. Advanced Microsoft Excel
        1. Using Pivot Tables
        2. Auditing Worksheets
        3. Data Tools
        4. Working with Others
        5. Recording and Using Macros
        6. Random Useful Items
        7. Advanced Microsoft Excel Exam
      4. Microsoft Excel Final Exam
    3. Microsoft PowerPoint
      1. Introduction to Microsoft PowerPoint
        1. Creating a PowerPoint Presentation
        2. The Ribbon
        3. The Quick Access Toolbar
        4. The Backstage View (The File Menu)
        5. Formatting Microsoft PowerPoint Presentations
        6. Working with Images
        7. Working with Tables and Charts
        8. Finalizing Microsoft PowerPoint Presentations
        9. Introduction to Microsoft PowerPoint Final Exam
      2. Advanced Microsoft PowerPoint
        1. Customizing Presentations
        2. Presentation Masters
        3. Working with Special Effects
        4. Using SmartArt
        5. Multimedia
        6. Setting Up the Slide Show
        7. Outlines and Slides
        8. Managing Multiple Presentations
        9. Sharing and Securing a Presentation
        10. Advanced Microsoft PowerPoint Final Exam
      3. PowerPoint Final Exam
    4. Microsoft Outlook
      1. Introduction to Microsoft Outlook
        1. The Outlook Interface
        2. Performing Popular Tasks in Outlook
        3. Working with Messages
        4. Working with the Calendar
        5. Organizing Contacts
        6. Introduction to Microsoft Outlook Exam
      2. Advanced Microsoft Outlook
        1. Working with Tasks and Notes
        2. Using Signature and Themes
        3. Managing Your Inbox
        4. Working with Multiple Email Accounts
        5. Advanced Microsoft Outlook Exam
      3. Microsoft Outlook Final Exam
    5. Microsoft Access
      1. Introduction to Microsoft Access
        1. Quick Overview of the Access User Interface
        2. Fundamentals
        3. Tables and Their Views
        4. Tables
        5. Queries
        6. Forms
        7. Reports
        8. Introduction to Microsoft Access Final Exam
      2. Advanced Microsoft Access
        1. Relationships
        2. Queries
        3. Table Functions
        4. Forms
        5. Reports
        6. Macros
        7. Completing the Desktop Application
        8. Advanced Microsoft Access Final Exam
      3. Microsoft Access Final Exam
  2. Certified Administrative Professional
    1. Organizational Communication (Part 1)
      1. Communication Essentials
      2. Interacting With Stakeholders
      3. Teams
      4. Quiz
    2. Organizational Communication (Part 2)
      1. Networking
      2. Interpersonal Interactions
      3. Public Speaking
      4. International Business
      5. Organizational Structure and Systems
      6. Legal Issues/Ethics
      7. Quiz
    3. Business Writing and Document Production
      1. Business Writing
      2. Using Personal Computer Software Applications
      3. Publishing Web Documents, Hard-Copy Documents, and Meeting Minutes
      4. Quiz
    4. Technology and Information Distribution
      1. Information in Organizations
      2. Researching, Gathering, Compiling, and Analyzing Data and Information
      3. Networks for Information Distribution and Maintaining, Backing-up, and Storing Data
      4. Quiz
    5. Office and Records Management
      1. Office and Records Management (Introduction)
      2. The Basics of Creating Functioning and Productive Workspaces
      3. Obtaining and Managing Resources for Your Office and Working in a Virtual Office
      4. Quiz
    6. Event and Project Management
      1. Event and Travel Management: Coordinating Virtual Meetings
      2. Project Management, Time Management, and Negotiations
      3. Quiz
    7. Human Resources
      1. Human Resources Functions, Duties, and Processes
      2. Employee Files and Records and Employee Training
      3. Recruitment, Staffing, and Hiring Practices
      4. Diversity, Onboarding/Offboarding, and Human Resource Law
      5. Quiz
    8. Financial Functions
      1. Organizational Finance: Budgeting, Financial Statements, and Financial Transactions
      2. Banking Process and the Bank Statement Reconciliation Process
      3. Basic Statistical Analysis
      4. Quiz
    9. Workplace Behaviors
      1. Goal Setting and Creativity
      2. Problem Solving and Decision Making
      3. Time Management and Stress Management
      4. Quiz
    10. Becoming an Administrative Assistant and Advancing Your Career
      1. Job Duties, Responsibilities, and Personal Characteristics of Administrative Assistants
      2. Administrative Assistant Position Options
      3. Becoming an Administrative Assistant, Making a Career Change, and Career Advancement
      4. Quiz
  3. Management Training
    1. Financial and Accounting Management
    2. Marketing Management
    3. Strategic Management in Operations
    4. Legal Issues in Operations
    5. Legal Aspects of Contracts
    6. Tax Issues
    7. Organizational Development and Change
    8. Negotiating Strategies
    9. Business Best Practices
    10. Organization Leadership and Decision Making
    11. Project Management for Executives
    12. Seven Management Disciplines

Katrina McBride

Katrina McBride's career reflects extensive experience in organizational leadership, marketing strategies, and market development in multinational corporate environments. Her leadership abilities have been utilized to develop new programs and functional areas. In director-level positions for Nortel Networks, she led strategy for competitive intelligence, emerging markets, and lead generation. McBride holds an M.A. in organizational management and a B.S. in psychology.

Katherine Squires Pang

Katherine Squires Pang, J.D., LL.M., M.Ed has practiced law with since 1983. She has served as an adjunct faculty member in the Graduate School of Management at the University of Texas, Dallas, and has been an adjunct faculty member of many universities, including New York University and the University of California, Irvine. She received her B.A. in 1980 from Clark University, her J.D. from the University of Dayton Law School in 1982, her LL.M in Taxation from Georgetown University Law School in 1983, and her M.Ed from the University of Texas in 2001.

Jerry L. Partridge

Jerry L. Partridge is a Certified Project Management Professional with experience as a project and program manager for a major retail organization. He is a certified instructor for IBM project management courses and hosts university seminars for project managers seeking certification. He has worked extensively with the Project Management Institute, previously leading a team that developed a practice standard for Earned Value Management Systems and volunteering as a subject matter expert for an update to the Project Management Body of Knowledge (PMBOK). Partridge holds a Master of Business Administration from Central Michigan University and a Bachelor of Science from Texas A&M University.

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.

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)

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:
    • MO-100: Microsoft Word
    • MO-200: Microsoft Excel
    • MO-300: Microsoft PowerPoint
    • MO-400: Microsoft Outlook
  • And pass any two of the following three Expert exams:
    • MO-101: Microsoft Word Expert
    • MO-201: 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.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 or Microsoft Office 365 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 is ideal, you can download the desktop versions that comes with Microsoft 365. Please note that there may be some differences between your version of these programs 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. The following textbook will be shipped to you approximately 7-10 business days after enrollment:

  • Managing by the Numbers: A Commonsense Guide to Understanding and using your Company's Financials
  • Strategic Planning - A Pragmatic Guide
  • The Administrative Professional, Rankin and Shumack

Please Note: You will receive a digital book if the physical book is on backorder.

Yes. You will be prepared for the Certified Administrative Professional (CAP) certification offered by the International Association of Administrative Professionals (IAAP). You will also be prepared for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Outlook, and Access. 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).

As an administrative professional, you will play an important role in keeping an office organized and functioning efficiently. You will perform routine clerical tasks such as answering phones and drafting messages. Administrative professionals will also organize files, schedule appointments, and support other employees within the office. As an administrative professional, you may also be responsible for greeting guests who visit your organization.

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

Yes, ed2go courses are completely online. However, keep in mind that not all certifying bodies or industry-specific certifications are recognized internationally. Please review your country's regulations prior to enrolling in courses that prepare for certification.

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.

The course instructor will be available by email to answer any questions and provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also receive support from the student 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."

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