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, technology, government, and medicine.

In this bundled course of Certified Administrative Professional, and Microsoft Office 2016 Specialist Certification Training, you will learn the basics of workplace administration as well as how to begin and grow a successful career as an administrative professional. The course covers the intricacies of organizational communication, office and records management, and human resources fundamentals, among other topics. You will also learn to effectively write for business, produce documents, and utilize informational technology. You'll gain event and project management skills, which includes virtual meeting coordination. As technology develops, this skill has become increasingly useful. Each course module concludes with a quiz, helping you to effectively track your progress and test your skills.

This program will also prepare you to sit for the Microsoft Office Specialist Certification Exams, which cover Word, Excel, PowerPoint, Outlook, and Access. This course offers enrollment with vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

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)

Certified Administrative Professional

I. Organizational Communication (Part 1)


A. Communication Essentials


B. Interacting With Stakeholders


C. Teams


D. Quiz


II. Organizational Communication (Part 2)


A. Networking


B. Interpersonal Interactions


C. Public Speaking


D. International Business


E. Organizational Structure and Systems


F. Legal Issues/Ethics


G. Quiz


III. Business Writing and Document Production


A. Business Writing


B. Using Personal Computer Software Applications


C. Publishing Web Documents, Hard-Copy Documents, and Meeting Minutes


D. Quiz


IV. Technology and Information Distribution


A. Information in Organizations


B. Researching, Gathering, Compiling, and Analyzing Data and Information


C. Networks for Information Distribution and Maintaining, Backing-up, and Storing Data


D. Quiz


V. Office and Records Management


A. Office and Records Management (Introduction)


B. The Basics of Creating Functioning and Productive Workspaces


C. Obtaining and Managing Resources for Your Office and Working in a Virtual Office


D. Quiz


VI. Event and Project Management


A. Event and Travel Management: Coordinating Virtual Meetings


B. Project Management, Time Management, and Negotiations


C. Quiz


VII. Human Resources


A. Human Resources Functions, Duties, and Processes


B. Employee Files and Records and Employee Training


C. Recruitment, Staffing, and Hiring Practices


D. Diversity, Onboarding/Offboarding, and Human Resource Law


E. Quiz


VIII. Financial Functions


A. Organizational Finance: Budgeting, Financial Statements, and Financial Transactions


B. Banking Process and the Bank Statement Reconciliation Process


C. Basic Statistical Analysis


D. Financially Accounting for Charitable Activities


E. Quiz


IX. Workplace Behaviors


A. Goal Setting and Creativity


B. Problem Solving and Decision Making


C. Time Management and Stress Management


D. Quiz


X. Becoming an Administrative Assistant and Advancing Your Career

A. Job Duties, Responsibilities, and Personal Characteristics of Administrative Assistants

B. Administrative Assistant Position Options

C. Becoming an Administrative Assistant, Making a Career Change, and Career Advancemen

D. Quiz



Excel

I. Introduction to Microsoft Excel

A. Creating a Microsoft Excel Workbook

B. The Ribbon

C. The Backstage View (The File Menu)

D. Entering Data in Microsoft Excel Worksheets

E. Formatting Microsoft Excel Worksheets

F. Using Formulas in Microsoft Excel

G. Working with Rows and Columns

H. Editing Worksheets

I. Finalizing Microsoft Excel Worksheets

J. Microsoft Excel Features that Were New in 2013

K. Features New in 2016

L. Introduction to Microsoft Excel 2016 Exam

II. Intermediate Microsoft Excel 2016

A. Advanced Formulas

B. Working with Lists

C. Working with Illustrations

D. Visualizing Your Data

E. Working with Tables

F. Advanced Formatting

G. Microsoft Excel Features that Were New in 2013

H. Features New in 2016

I. Intermediate Microsoft Excel 2016 Exam

III. Advanced Microsoft Excel 2016

A. Using Pivot Tables

B. Auditing Worksheets

C. Data Tools

D. Working with Others

E. Recording and Using Macros

F. Random Useful Items

G. Microsoft Excel Features that Were New in 2013

H. Features New in 2016

I. Advanced Microsoft Excel 2016 Exam

IV. Microsoft Excel Final Exam

Word

V. Introduction to Microsoft Word 2016

A. Creating a Microsoft Word Document

B. The Ribbon

C. The File Tab

D. The Quick Access Toolbar

E. Formatting Microsoft Word Documents

F. Editing Documents

G. Finalizing Microsoft Word Documents

H. Introduction to Microsoft Word 2016 Exam

VI. Intermediate Microsoft Word 2016

A. Advanced Formatting

B. Working with Tables

C. Working with Images

D. Page Layout

E. Working with Illustrations

F. Viewing Your Document(s)

G. Intermediate Microsoft Word 2016 Exam

VII. Advanced Microsoft Word 2016

A. Working with Long Documents

B. Reviewing and Collaborating on Documents

C. Comparing and Combining Documents

D. Managing Mailings

E. Protecting Documents

F. Random Useful Items

G. Advanced Microsoft Word 2016 Exam

VIII. Microsoft Word 2016 Final Exam

PowerPoint

IX. Introduction to Microsoft PowerPoint 2016

A. Creating a PowerPoint Presentation

B. The Ribbon

C. The Quick Access Toolbar

D. The Backstage View (The File Menu)

E. Formatting Microsoft PowerPoint Presentations

F. Working with Images

G. Working with Tables and Charts

H. Finalizing Microsoft PowerPoint Presentations

I. Introduction to Microsoft PowerPoint 2016 Exam

X. Advanced Microsoft PowerPoint 2016

A. Customizing Presentations

B. Presentation Masters

C. Working with Special Effects

D. Using SmartArt

E. Multimedia

F. Setting up the Slide Show

G. Outlines and Slides

H. Managing Multiple Presentations

I. Sharing and Securing a Presentation

J. Features New in 2016

K. Advanced Microsoft PowerPoint 2016 Exam

XI. Microsoft PowerPoint 2016 Final Exam

Outlook

XII. Introduction to Microsoft Outlook 2016

A. The Outlook 2016 Interface

B. Performing Popular Tasks in Outlook 2016

C. Working with Messages

D. Working with the Calendar

E. Organizing Contacts

F. Introduction to Microsoft Outlook 2016 Exam

XIII. Advanced Microsoft Outlook 2016

A. Working with Tasks and Notes

B. Using Signature and Themes

C. Managing Your Inbox

D. Working with Multiple Email Accounts

E. New Features in 2016

F. Advanced Microsoft Outlook 2016 Exam

XIV. Microsoft Outlook Final Exam

Access

XV. Introduction to Microsoft Access 2016

A. Quick Overview of the Access User Interface

B. Fundamentals

C. Tables and Their Views

D. Tables

E. Queries

F. Forms

G. Reports

H. Databases and Access Terms

I. Introduction to Microsoft Access 2016 Exam

XVI. Advanced Microsoft Access 2016

A. Relationships

B. Queries

C. Table Functions

D. Forms

E. Reports

F. Macros

G. Completing the Desktop Application

H. Advanced Microsoft Access 2016 Exam

XVII. Microsoft Access Final Exam

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

Can I register for courses if I am an international student?

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.

Does this course prepare for a 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

When can I start this course?

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.

How long does it take to complete this course?

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.

What if I don't have enough time to complete the course within the time frame provided?

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.

What kind of support will I receive?

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.

What happens when I complete the course?

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

Am I guaranteed a job?

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.

Can I get financial assistance?

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.

How can I get more information about this course?

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