Certified Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included)

To be a successful administrative professional, you must possess skills to handle a wide variety of workplace tasks and scenarios. The Certified Administrative Professional (CAP) course serves two purposes. First, it prepares you to take the CAP exam offered by the International Association of Administrative Professionals (IAAP). Second, it provides you with a broad selection of essential skills and knowledge to effectively work as an administrative assistant in fields including education,...

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

Association of Executive and Administrative Professionals

Change School
Learning method
for additional information

Certified Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included)

Enroll Now

Course code: GES2012

What you will learn

  • Learn essential skills required of the Microsoft Office suite including Word, Excel, PowerPoint, Access, and Outlook
  • Manage databases and improve efficiency using Access
  • Send messages, manage calendars, and collaborate with coworkers across Outlook.
  • Effective organizational communication
  • The fundamentals of administrative roles including human resources, financial responsibilities, and event and project management
  • How to write for business and the Internet
  • Essential workplace skills
  • Prepare for the IAAP Certified Administrative Professional exam

How you will benefit

  • You will have reached a proficient level of competency with the most commonly used Microsoft Office products.
  • 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
  • Prepare to take the Microsoft Office Specialist Certification exams 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), 77-731 (Outlook), and 77-730 (Access)

How the course is taught

  • Self-paced, online course
  • 12 Months to complete
  • Open enrollment, begin anytime
  • 425 course hours
  1. 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. Financially Accounting for Charitable Activities
      5. 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
  2. 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. Microsoft Excel Features that Were New in 2013
      11. Features New in 2016
      12. Introduction to Microsoft Excel 2016 Exam
    2. Intermediate Microsoft Excel 2016
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Microsoft Excel Features that Were New in 2013
      8. Features New in 2016
      9. Intermediate Microsoft Excel 2016 Exam
    3. Advanced Microsoft Excel 2016
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Microsoft Excel Features that Were New in 2013
      8. Features New in 2016
      9. Advanced Microsoft Excel 2016 Exam
    4. Microsoft Excel Final Exam
  3. Word
    1. Introduction to Microsoft Word 2016
      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 2016 Exam
    2. VI. Intermediate Microsoft Word 2016
      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 2016 Exam
    3. VII. Advanced Microsoft Word 2016
      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 2016 Exam
    4. Microsoft Word 2016 Final Exam
  4. PowerPoint
    1. Introduction to Microsoft PowerPoint 2016
      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 2016 Exam
    2. Advanced Microsoft PowerPoint 2016
      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. Features New in 2016
      11. Advanced Microsoft PowerPoint 2016 Exam
    3. Microsoft PowerPoint 2016 Final Exam
  5. Outlook
    1. Introduction to Microsoft Outlook 2016
      1. The Outlook 2016 Interface
      2. Performing Popular Tasks in Outlook 2016
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook 2016 Exam
    2. Advanced Microsoft Outlook 2016
      1. Working with Tasks and Notes
      2. Using Signature and Themes
      3. Managing Your Inbox
      4. Working with Multiple Email Accounts
      5. New Features in 2016
      6. Advanced Microsoft Outlook 2016 Exam
    3. Microsoft Outlook Final Exam
  6. Access
    1. Introduction to Microsoft Access 2016
      1. Quick Overview of the Access User Interface
      2. Fundamentals
      3. Tables and Their Views
      4. Tables
      5. Queries
      6. Forms
      7. Reports
      8. Databases and Access Terms
      9. Introduction to Microsoft Access 2016 Exam
    2. Advanced Microsoft Access 2016
      1. Relationships
      2. Queries
      3. Table Functions
      4. Forms
      5. Reports
      6. Macros
      7. Completing the Desktop Application
      8. Advanced Microsoft Access 2016 Exam
    3. Microsoft Access Final Exam

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

Certification Eligibility Requirements

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.

What is relevant work experience? CAP certification is designed for 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.

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 2016 (not included in enrollment).
  • 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 and will be available online. Manuals are included as downloadable PDFs throughout the course. The following textbook will be shipped to you approximately 7-10 business days after enrollment in the Certified Administrative Professional portion of the bundle:

  • The Administrative Professional, Rankin and Shumack

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.

Yes. Certified Administrative Professional (CAP) offered by the International Association of Administrative Professionals (IAAP). Certification exams are given twice a year. If you qualify to apply for the exam the deadlines to apply for the exam using your ed2go voucher are:

  • February 1st for Spring Exams
  • July 15th for Fall 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.

The course instructor will be available by email to answer any questions you may have and to provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also be assigned a Student Advisor for academic support.

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