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

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

SHARE
12 Months / 345 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

CSU Channel Islands

Change School
Learning method

for additional information

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

Enroll Now

Course code: GES2048

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

How the course is taught

  • Self-paced, online course
  • 12 Months to complete
  • Open enrollment, begin anytime
  • 345 course hours
  1. Part 1 - Microsoft Office Specialist (MOS) Associate Certification Training
      Unit 1 - Introduction to Microsoft Excel Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Microsoft Excel Workbook - Quizzes: 1, Assignments: 1

      • Starting Microsoft Excel
      • Creating a Workbook
      • Saving a Workbook
      • The Status Bar
      • Adding and Deleting Worksheets
      • Copying and Moving Worksheets
      • View Options for the Worksheet
      • Closing a Workbook

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

      • Introduction to the Backstage View
      • Opening a Workbook
      • New Workbooks and Excel Templates
      • Printing Worksheets
      • Personalizing Microsoft Office

      Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding Additional Commands with the Customize Dialog
      • Adding Ribbon Commands or Groups

      Lesson 6: Entering Data in Microsoft Excel Worksheets - Quizzes: 1, Assignments: 2

      • Entering Text
      • Inserting and Deleting Cells
      • Inserting Hyperlinks
      • Inserting WordArt
      • Using AutoComplete
      • Entering Numbers and Dates
      • Using the Fill Handle

      Lesson 7: Formatting Microsoft Excel Worksheets - Quizzes: 1, Assignments: 4

      • Selecting Ranges of Cells
      • Hiding Worksheets
      • Adding Color to Worksheet Tabs
      • Adding Themes to Workbooks
      • Adding a Watermark
      • The Font Group
      • The Alignment Group
      • The Number Group

      Lesson 8: Editing Worksheets - Quizzes: 1, Assignments: 2

      • Find
      • Find and Replace
      • Using the Clipboard
      • Moving Columns / Rows

      Lesson 9: Working with Rows and Columns - Quizzes: 1, Assignments: 1

      • Inserting and Deleting Rows, Columns, and Cells
      • Transposing Rows and Columns
      • Row Height and Column Width
      • Hiding and Unhiding Rows and Columns
      • Freezing Panes

      Lesson 10: Using Formulas in Microsoft Excel - Quizzes: 1, Assignments: 1

      • Math Operators and the Order of Operations
      • Entering Formulas
      • AutoSum (and Other Common Auto-Formulas)
      • Copying Formulas
      • Relative, Absolute, and Mixed Cell References

      Lesson 11: Finalizing Microsoft Excel Worksheets - Quizzes: 1, Assignments: 1

      • Setting Margins
      • Setting Page Orientation
      • Setting the Print Area
      • Print Scaling (Fit Sheet on One Page)
      • Repeating Headings
      • Headers and Footers

      Lesson 12: Using Copilot in Microsoft Excel - Quizzes: 1, Assignments: 1

      • Copilot in Microsoft 365 Excel
      • Creating Columns
      • Analyzing Your Data
      • Importing and Framing Data

      Introduction to Microsoft Excel Exam

      Unit 2 - Intermediate Microsoft Excel Training

      Lesson 1: Common Functions - Quizzes: 1, Assignments: 7

      • Using Named Ranges in Formulas
      • Using Formulas That Span Multiple Worksheets
      • Functions: IF and IFS
      • Functions: AND and OR
      • Functions: NOT
      • Functions: SWITCH
      • Functions: COUNTIF, AVERAGEIF, and SUMIF
      • Functions: PMT and NPER
      • Functions: TEXTJOIN and CONCAT
      • Text Functions
      • Date and Time Functions

      Lesson 2: Working with Lists - Quizzes: 1, Assignments: 4

      • What is a List of Data?
      • Removing Duplicates from a List
      • Sorting Data in a List
      • Filtering Data in a List
      • Adding Subtotals to a List

      Lesson 3: Visualizing Your Data - Quizzes: 1, Assignments: 2

      • Chart Basics
      • Tools for Editing Charts
      • The Format Tool Tab
      • Using the Three Chart Buttons
      • The Format Task Pane
      • Useful Charts
      • Line and Area Charts
      • Hierarchy Charts
      • Statistic Charts
      • Other Charts
      • Combo Charts
      • Using Recommended Charts
      • Sparklines
      • Add and Format Objects
      • Working with Shapes
      • Working with Icons
      • Working with SmartArt
      • Using the Quick Analysis Tool

      Lesson 4: Working with Tables - Quizzes: 1, Assignments: 1

      • Format Data as a Table
      • Table Design Tool Tab
      • Formatting Individual Cells
      • Selecting Table Rows and Columns
      • Structured References
      • Convert a Table to a Range

      Lesson 5: Advanced Formatting - Quizzes: 1, Assignments: 2

      • Cell Styles
      • Conditional Formatting
      • Conditional Formatting: Highlight Cells Rules
      • Conditional Formatting: Top/Bottom Rules
      • Conditional Formatting: Data Bars, Color Scales, and Icon Sets
      • Conditional Formatting: Create a New Rule
      • Removing Conditional Formatting

      Intermediate Microsoft Excel Exam

      Unit 3 - Advanced Microsoft Excel Training

      Lesson 1: Using PivotTables - Quizzes: 1, Assignments: 1

      • How PivotTables Work
      • Timeline Filters
      • Inserting Slicers
      • Grouping Data
      • Calculated Fields
      • PivotCharts

      Lesson 2: Advanced Functions - Quizzes: 1, Assignments: 2

      • Function Syntax
      • ROWS, COLUMNS, INDEX, and XMATCH
      • Arrays and Array Formulas
      • SORT, FILTER, and SORTBY
      • Lookup Functions
      • The LET Function
      • The TRANSPOSE Function

      Lesson 3: Auditing Workbooks - Quizzes: 1, Assignments: 1

      • Inspecting a Workbook
      • Tracing Precedents and Dependents
      • Watch Window
      • Evaluating Formulas
      • Error Checking

      Lesson 4: Data Tools - Quizzes: 1, Assignments: 5

      • Importing Data from Online Source
      • Converting Text to Columns
      • Importing Files
      • Linking to External Data
      • Controlling Calculation Options
      • Data Validation
      • Consolidating Data
      • What-If Analysis

      Lesson 5: Recording and Using Macros - Quizzes: 1, Assignments: 2

      • Recording Macros
      • Running Macros
      • Editing Macros
      • Adding Macros to the Quick Access Toolbar

      Lesson 6: Working with Others - Quizzes: 1, Assignments: 1

      • Comments and Notes
      • Protecting Worksheets and Workbooks
      • Marking a Workbook as Final
      • Other Sharing Concerns

      Advanced Microsoft Excel Exam, Final Microsoft Excel Exam

      Unit 4 - Introduction to Microsoft Word Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Microsoft Word Document - Quizzes: 1, Assignments: 1

      • Starting Microsoft Word
      • Creating a Document
      • Saving a Document
      • The Status Bar
      • Closing a Document
      • Opening Documents

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

      • Introduction to the Backstage View
      • Opening a Document
      • New Documents and Word Templates
      • Configuring Documents to Print
      • Adding Your Name to Microsoft Word
      • Adding Values to Document Properties

      Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding Additional Commands with the Customize Dialog
      • Adding Ribbon Commands or Groups

      Lesson 6: Formatting Microsoft Word Documents - Quizzes: 1, Assignments: 7

      • Selecting Text
      • Fonts
      • Working with Lists
      • Inserting a Hyperlink in a Document
      • Using Styles
      • Using Themes
      • Using the Ruler
      • Indentation
      • Setting Margins
      • Special Characters
      • WordArt
      • Page Background Elements

      Lesson 7: Editing Documents - Quizzes: 1, Assignments: 2

      • Find
      • Find and Replace
      • Using the Clipboard
      • Search Options
      • Inserting Text from Another File

      Lesson 8: Finalizing Microsoft Word Documents - Quizzes: 1, Assignments: 3

      • Adding Page Numbers
      • Headers and Footers
      • Microsoft Editor
      • Checking Spelling and Grammar
      • Internationalization and Accessibility

      Lesson 9: Using Copilot in Microsoft Word

      • Copilot in Microsoft 365 Word
      • Highlighting Existing Text
      • Copilot Sidecar
      • Temporary Chat
      • Practical ways to use Copilot

      Introduction to Microsoft Word Exam

      Unit 5 - Intermediate Microsoft Word Training

      Lesson 1: Advanced Formatting - Quizzes: 1, Assignments: 3

      • Shading and Borders
      • Setting Line and Paragraph Spacing
      • Changing Styles
      • Paragraph Marks and Other Formatting Symbols
      • Character Space Options
      • Changing the Default Font
      • Custom Design Elements
      • Editing PDF Documents in Microsoft Word

      Lesson 2: Working with Tables - Quizzes: 1, Assignments: 3

      • Inserting a Table
      • Converting Tables to Text
      • Sorting Table Data
      • Setting Cell Margins
      • Modifying Table Dimensions
      • Merging and Splitting Cells
      • Applying Formulas to a Table
      • Table Styles
      • Manipulating Rows, Columns, and Cells

      Lesson 3: Working with Images - Quizzes: 1, Assignments: 3

      • Inserting Images
      • Placing and Sizing Images
      • Wrapping Text around an Image
      • Adjusting Images
      • Borders and Effects
      • Using Live Layout and Alignment Guides

      Lesson 4: Page Layout - Quizzes: 1, Assignments: 2

      • Orientation and Paper Size
      • Working with Columns
      • Page and Section Breaks
      • Adding Titles to Sections
      • Hyphenation
      • Line Numbers

      Lesson 5: Working with Illustrations - Quizzes: 1, Assignments: 5

      • Adding and Editing Charts
      • Inserting Images
      • Using Shapes
      • Working with Icons
      • 3D Models
      • Working with SmartArt
      • Using Building Blocks

      Lesson 6: Viewing Your Documents - Quizzes: 1, Assignments: 2

      • Document Views
      • Using the Navigation Pane
      • Multiple Windows
      • Object Zoom Feature

      Intermediate Microsoft Word Exam

      Unit 6 - Advanced Microsoft Word Training

      Lesson 1: Working with Long Documents - Quizzes: 1, Assignments: 4

      • Adding a Table of Contents
      • Updating the Table of Contents
      • Deleting the Table of Contents
      • Cross References
      • Footnotes and Endnotes
      • Inserting Citations and a Bibliography
      • Adding an Index
      • Inserting a Table of Figures
      • Inserting and Updating a Table of Authorities
      • Using Bookmarks
      • Go To Feature

      Lesson 2: Reviewing and Collaborating on Documents - Quizzes: 1, Assignments: 4

      • Adding Comments
      • Tracking Changes
      • Viewing Changes
      • Accepting and Rejecting Changes
      • Sharing

      Lesson 3: Comparing and Combining Documents - Quizzes: 1, Assignments: 2

      • Comparing Documents
      • Combining Documents

      Lesson 4: Forms - Quizzes: 1, Assignments: 6

      • Showing the Developer Tab

      Lesson 5: Managing Mailings - Quizzes: 1, Assignments: 2

      • Creating Envelopes and Labels
      • Using Mail Merge

      Lesson 6: Protecting Documents - Quizzes: 1, Assignments: 2

      • Marking Documents Final
      • Password Protect Word Documents
      • Removing Metadata from Files
      • Restrict Formatting and Editing
      • Adding Watermarks

      Lesson 7: Macros - Quizzes: 0, Assignments: 1

      • Using Macros

      Advanced Microsoft Word Exam, Final Microsoft Word Exam

      Unit 7 - Introduction to Microsoft PowerPoint Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Presentation - Quizzes: 1, Assignments: 1

      • Starting Microsoft PowerPoint
      • Creating a Presentation
      • Saving a Presentation
      • The Status Bar
      • Closing a Presentation

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding More Commands with the Customize Dialog Box
      • Adding Ribbon Commands or Groups

      Lesson 5: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 2

      • Introduction to the Backstage View
      • Opening a Presentation
      • New Presentations and Presentation Templates
      • Adding Your Name to Microsoft PowerPoint

      Lesson 6: Formatting Presentations - Quizzes: 1, Assignments: 1

      • Selecting a Slide Layout
      • Adding and Editing Text
      • Adding Text from a Text File or Word Outline
      • Formatting Text
      • Text Effects and WordArt
      • Bulleted and Numbered Lists
      • Columns
      • Adding Slides to a Presentation
      • Arranging Slides

      Lesson 7: Working with Images - Quizzes: 1, Assignments: 1

      • Adding Images to a Slide
      • Removing an Image Background
      • Picture Format Tools Tab
      • Grouping and Ungrouping Images
      • Arranging Images
      • Adding Shapes
      • Working with Icons
      • 3D Models
      • Using Digital Ink

      Lesson 8: Working with Tables and Charts - Quizzes: 1, Assignments: 2

      • Inserting a Table
      • Formatting Tables
      • Importing Tables from External Sources
      • Inserting a Chart
      • Formatting a Chart
      • Importing Charts from External Sources

      Lesson 9: Preparing and Presenting - Quizzes: 1, Assignments: 2

      • Checking Spelling
      • Accessing Different Views of a Presentation
      • Running the Slide Show
      • Organizing a Presentation in Sections
      • Adding Transitions to Slides
      • Adding Speaker Notes
      • Printing a Presentation

      Lesson 10: Using Copilot in Microsoft PowerPoint - Quizzes: 1, Assignments: 1

      • Copilot in Microsoft 365 PowerPoint
      • Creating a New Presentation
      • Creating New Slides
      • Summarizing Large Amounts of Content
      • Branding a Deck

      Introduction to Microsoft PowerPoint Exam

      Unit 8 - Advanced Microsoft PowerPoint Training

      Lesson 1: Customizing Presentations - Quizzes: 1, Assignments: 1

      • Applying a Theme
      • Formatting Backgrounds
      • Headers and Footers
      • Adding a Background Image

      Lesson 2: Presentation Masters - Quizzes: 1, Assignments: 1

      • Working with the Slide Master
      • Slide Layouts
      • Formatting Slide Masters and Layouts
      • Adding a Watermark to Your Presentation
      • Adding Slide Numbers Using the Slide Master
      • Inserting a New Slide Master
      • Removing Unused Slide Masters and Layouts
      • Modifying the Notes Master
      • Modifying the Handout Master

      Lesson 3: Working with Special Effects - Quizzes: 1, Assignments: 1

      • Animating Bullets
      • Working with the Animation Painter
      • Motion Paths
      • Animating a Chart
      • Slide Transitions

      Lesson 4: Using SmartArt - Quizzes: 1, Assignments: 1

      • Inserting SmartArt Graphics
      • Modifying SmartArt Graphics
      • Resizing/Repositioning a SmartArt Object
      • Inserting Text into a SmartArt Object
      • Adding Shapes to a SmartArt Object
      • Ungrouping SmartArt Objects

      Lesson 5: Multimedia - Quizzes: 1, Assignments: 2

      • Creating a Photo Album
      • Editing a Photo Album
      • Inserting Sounds and Video
      • Editing Media Clips

      Lesson 6: Setting up the Slide Show - Quizzes: 1, Assignments: 2

      • Setting up a Custom Slide Show
      • Creating a Hyperlink
      • Adding an Action Button
      • Zoom
      • Using Rehearse Timings
      • Navigating within a Slide Show
      • Annotating a Presentation
      • Recording a Slide Show

      Lesson 7: Outlines and Slides - Quizzes: 1, Assignments: 1

      • Exporting Handouts to Word
      • Exporting an Outline to Word
      • Saving a Presentation as an Outline
      • Saving a Slide as a Graphic

      Lesson 8: Managing Multiple Presentations - Quizzes: 1, Assignments: 1

      • Merging Multiple Presentations
      • Viewing Multiple Presentations
      • Tracking Changes in PowerPoint
      • Adding Comments

      Lesson 9: Finalizing Presentations - Quizzes: 1, Assignments: 0

      • Inspecting a Presentation
      • Encrypting a Presentation
      • Embedding the Fonts in a Presentation
      • Saving a Presentation in PDF Format
      • Compressing Pictures
      • Marking a Presentation as Final

      Advanced Microsoft PowerPoint Exam, Final Microsoft PowerPoint Exam

      Unit 9 - Introduction to Microsoft Outlook 365 Training

      Lesson 1: The Outlook Interface - Quizzes: 1, Assignments: 0

      • Overview of the Outlook Interface
      • The Ribbon
      • Review of Differences Between Classic and New Layouts

      Lesson 2: Working with Messages - Quizzes: 1, Assignments: 1

      • Compose a Message
      • Add an Attachment
      • Add Polling Options
      • Check Spelling and Grammar
      • Format Text
      • Insert a Hyperlink or Image in a Message
      • Send a Message

      Lesson 3: Working with the Calendar - Quizzes: 1, Assignments: 2

      • Change Your Calendar View
      • Set Up Availability Status
      • Print Your Schedule
      • Share Your Calendar
      • Schedule a Meeting
      • Make Updates to Meetings
      • Cancel a Meeting
      • View Others’ Calendars
      • Delete a Calendar
      • Work with Calendar Items
      • Create and Add Calendars

      Lesson 4: Organizing Contacts - Quizzes: 1, Assignments: 1

      • Add, Delete, and Import/Export a Contact
      • Update a Contact
      • Locate a Contact
      • Sort Contacts
      • Work with Contact Lists
      • Manage Multiple Address Books

      Lesson 5: Working with Groups - Quizzes: 1, Assignments: 1

      • Search for a Group
      • Create a Group
      • Add or Remove Members
      • Send Email to a Group

      Lesson 6: Using Copilot in Microsoft Outlook

      • Copilot in Microsoft 365 Outlook
      • Emails
      • Meetings

      Introduction to Microsoft Outlook 365 Exam

      Unit 10 - Advanced Microsoft Outlook 365 Training

      Lesson 1: Performing Popular Tasks - Quizzes: 1, Assignments: 3

      • Open Email Messages
      • Reply to and Forward Email Messages
      • Preview and Save an Attachment
      • Print a Message
      • Delete a Message
      • Save a Message in an Alternate Format
      • Customize the Navigation Pane

      Lesson 2: Working with Tasks and Notes - Quizzes: 1, Assignments: 1

      • Create a Task
      • Print a Task
      • Add Steps to a Task
      • Update a Task
      • Search for Tasks
      • Change Your Task View

      Lesson 3: Using Signature and Themes - Quizzes: 1, Assignments: 1

      • Create a Signature
      • Automatically Add a Signature to Messages
      • Modify a Signature
      • Format Outgoing Messages

      Lesson 4: Managing Your Inbox - Quizzes: 1, Assignments: 2

      • Search for Messages
      • Sort Messages
      • Add New Local Folders
      • Move Messages between Folders
      • Group Your Mailbox Items
      • Filter Messages
      • Organize Messages
      • Create and Manage Rules
      • Manage Your Junk Email
      • Archive Your Messages
      • Create a Quick Step
      • Create Auto-Replies

      Lesson 5: Working with Multiple Email Accounts - Quizzes: 1, Assignments: 1

      • Setting Up Multiple Accounts in Outlook
      • Send Emails from Different Accounts
      • POP vs. IMAP Email Protocols

      Advanced Microsoft Outlook 365 Exam, Microsoft Outlook 365 Final Exam

  2. Part 2 - Certified Administrative Professional
    1. Certified Administrative Professional
    2. Organizational Communication (Part 1)
    3. Organizational Communication (Part 2)
    4. Business Writing and Document Production
    5. Technology and Information Distribution
    6. Office and Records Management
    7. Event and Project Management
    8. Human Resources
    9. Financial Functions
    10. Workplace Behaviors and Activities (Part 1)
    11. Workplace Behaviors and Activities (Part 2)
    12. Workplace Behaviors and Activities (Part 3)
    13. Becoming an Administrative Assistant and Advancing Your Career

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.

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:

While there are no prerequisites to take this course bundle, you should be familiar with using a personal computer, mouse, and keyboard. You should be comfortable in a Windows environment and have the ability to launch and close activities and navigate to information stored on the computer. You should also have an ability to manage files and folders.

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. CAP certification is designed for office and administrative professionals who engage in 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
  • 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

Microsoft Office Specialist (MOS) Associate

To earn the Microsoft Office Specialist: Associate certification, pass three of the following exams:

  • MO-100: Microsoft Word
  • MO-200: Microsoft Excel
  • MO-300: Microsoft PowerPoint
  • MO-400: Microsoft Outlook

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)

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.

About Certification: Microsoft

Microsoft is a global leader in software development and technology solutions. Microsoft programs such as Excel, Word, Outlook, and PowerPoint are used both at home and at work. Microsoft provides certifications in these programs that range from beginner to expert level, helping professionals realize their full potential. Whether you want to learn a single program or the entire Office Suite, completing a Microsoft-certified course is the first step.

Secretaries and administrative assistants help an organization run efficiently. They use computer software to create spreadsheets, manage databases, and prepare presentations, reports, and documents. They also may negotiate with vendors, buy supplies, and manage stockrooms or corporate libraries. Secretaries and administrative assistants also set up appointments and use videoconferencing and other office equipment. Specific job duties vary by experience, job title, and specialty, but they work in almost every sector of the economy, including schools, government, and private corporations.

According to ZipRecruiter, the average salary for a Certified Administrative Professional in the U.S. is $44,338. Administrative professional salaries typically range between $24,500 and $68,500 a year. The average hourly rate for administrative professionals is $21 per hour.

Yes, you will be prepared for the Certified Administrative Professional (CAP) certification offered by the International Association of Administrative Professionals (IAAP). Please visit IAAP for more detailed information on eligibility and applying for the exam.

You will also be prepared for the Microsoft Office Specialist (MOS) certification exams for PowerPoint, Outlook, Word and Excel. Upon successful completions of 3 Associate level (MOS) exams of your choosing you will earn your Microsoft Office Specialist (MOS) Associate Certification.

You will receive four exam vouchers, one exam voucher for the CAP exam and three exam vouchers for the Microsoft MOS exams.

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