Skip Navigation or Skip to Content
Center for Career Education & Exploration

Master Catalog

Certified Administrative Professional with Microsoft Office Specialist (MOS) Associate (Vouchers Included)   

Train for a career as an administrative assistant and master the Microsoft Office suite. This course bundle will prepare you for the Certified Administrative Professional exam (CAP) exam offered by the International Association of Administrative Professionals (IAAP) and the Microsoft Office Specialist (MOS) Associate certification. The IAAP membership, CAP exam study guide, and vouchers included.



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 is 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. Reading assignments in each lesson will be linked to the eBook for the designated reading.

  • The Administrative Professional: Technology and Procedures (eBook)

The Certified Administrative Professional (CAP) certification is one of the most valuable credentials an administrative professional can hold. When held with a Microsoft Office Specialist Associate certification, you demonstrate that you can perform all administrative assistant duties and responsibilities at the highest level.

This course will prepare you for the CAP exam, offered by the International Association of Administrative Professionals (IAAP), and Microsoft Office Specialist certification at the Associate level. You will learn the fundamentals of workplace administration, including organizational communication, records management, and human resources. You will then learn advanced skills for using programs in the Microsoft Office suite.

By the completion of your CAP and Microsoft Office Specialist training, you will be fully prepared to take the CAP exam and the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level (MOS) exams of your choosing.

This course offers enrollment with vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.


Part 1 - Microsoft Office Specialist (MOS) Associate 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

Introduction to Microsoft Excel Exam

Lesson 2 - Intermediate Microsoft Excel Training

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

Intermediate Microsoft Excel Exam

Lesson 3 - Advanced Microsoft Excel Training

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

Advanced Microsoft Excel Exam

Final Microsoft Excel Exam

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

Introduction to Microsoft Word Exam

Lesson 5 - Intermediate Microsoft Word Training

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

Intermediate Microsoft Word Exam

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

Advanced Microsoft Word Exam

Final Microsoft Word Exam

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

Introduction to Microsoft PowerPoint Exam

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

Advanced Microsoft PowerPoint Exam

Final Microsoft PowerPoint Exam

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

Introduction to Microsoft Outlook 365 Exam

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

Advanced Microsoft Outlook 365 Exam

Microsoft Outlook 365 Final Exam

Part 2 - Certified Administrative Professional

Lesson 1 - Certified Administrative Professional

Lesson 2 - Organizational Communication (Part 1)

Lesson 3 - Organizational Communication (Part 2)

Lesson 4 - Business Writing and Document Production

Lesson 5 - Technology and Information Distribution

Lesson 6 - Office and Records Management

Lesson 7 - Event and Project Management

Lesson 8 - Human Resources

Lesson 9 - Financial Functions

Lesson 10 - Workplace Behaviors and Activities (Part 1)

Lesson 11 - Workplace Behaviors and Activities (Part 2)

Lesson 12 - Workplace Behaviors and Activities (Part 3)

Lesson 13 - Becoming an Administrative Assistant and Advancing Your Career


What you will learn

  • To perform the key duties and responsibilities of an administrative assistant
  • To effectively use Microsoft Office applications, including Word, Excel, PowerPoint, and Outlook, at their most advanced level
  • Use AI and Microsoft Copilot in Excel to create columns, analyze data, and import or frame data more efficiently

How you will benefit

  • Develop a high level of understanding of the Certified Administrative Professional (CAP) body of knowledge
  • Set yourself up for success in an administrative career by learning relevant real-world skills
  • Gain the knowledge necessary to pass the CAP exam
  • You will receive IAAP Membership and a study guide upon qualification for the CAP exam
  • Be prepared to sit for the Microsoft Office Specialist (MOS) Associate Certification Exams
  • Improve spreadsheet productivity by using AI and Microsoft Copilot to speed up data analysis, support content creation, and streamline common Excel tasks

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 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many 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, and reporting/productivity applications.


Some Title



Your Cart

×