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.