Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map How It Works How It Works About ed2go Externship Programs Financial Assistance Corporate Training Find a School Military Virtual Career Center


(855) 520-6806

See all results for ""

See All Courses

ed2go Business Administrative Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included)
Return to Administrative

Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included)

Microsoft Office 2016 skills are important to have in any profession or workplace. Being able to work with Office programs is a must in today's workplace whether you are preparing for an entry-level position or are an experienced professional. Developing skills and experience working with Microsoft Word, Excel, PowerPoint, Outlook, and Access will allow you to do work independently and be a problem solver at your job. The material in this course is presented in a step-by-step manner, and you will learn by completing readings and hands-on exercises and watching video presentations. The course also includes quizzes and exams so you can test your skills at regular intervals throughout the material.

Through these methods, you will learn about the modern professional workplace, how to maintain your professional image, about time management, workplace behaviors and ethics, effective verbal and written communications, technology basics including working with computers and other workplace tools, record keeping and financial management basics, event planning and business travel basics, and career advancement and job searching skills. You will also learn essential introductory and advanced Office skills across Microsoft Office’s Word, Excel, PowerPoint, and Outlook programs. Upon completion of this program you will be prepared for 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). The registration fee for these exams are included with this program.

6 Months / 455 Course Hrs
Open Enrollment

Offered in Partnership with your Preferred School

George Mason University Why this school? It's been chosen based on your location or if you've visited this school's website.

Financial Assistance Available*

Change School

Bundle and Save

Contact Us

Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included)

Bundle and Save

Contact Us

Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included) Details + Objective

Course Code: GES871

You Will Learn
  • Master the Microsoft Office suite including Excel, Word, PowerPoint, Outlook, and Access
  • Learn the fundamentals of what’s required for an administrative position
  • Understand workplace ethics, communication, and responsibilities
  • Prepare yourself for the Microsoft Office Specialist Certification exams
How the course is taught
  • Self-paced, online course
  • 6 months to complete
  • Open enrollment, begin anytime
  • 455 course hours
How you will benefit
  • Learn how to work effectively in an administrative role while using Microsoft Office suite
  • Set yourself up for a successful career in nearly any office environment
  • Gather knowledge to pass the Microsoft Office Specialist Certification exams, which you can present to potential employers as proof of your dedication to the role
  • Understand how to thrive in any business setting by learning necessary time management, communication, and file management skills
Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included) Outline
Expand All

Learn the fundamentals of Microsoft Excel. You’ll understand how to format worksheets, use formulas, edit worksheets, and more. Throughout the course you’ll move on to intermediate and advanced Excel offerings.


Gather an introduction to the word processing system. Understand the basics of Word before covering advanced formatting, images, collaborating documents, and more.


Learn how to create a compelling PowerPoint presentation. Move from introductory skills to advanced effects and slideshow preparation techniques.


Understand how to work within Microsoft Outlook. You’ll learn how to send messages, use the calendar, and stay organized. Email from multiple accounts, manage an inbox, and more.


Overview the Access User Interface and learn about tables, queries, forms, and reports. Move on to understand advanced Access offerings like relationships, macros, and more.

Administrative Professional

Master the fundamental skills needed to thrive within a professional environment. In the final section of the course, you’ll cover topics like communication, records and financial management, career advancement, customer service, time management, business writing, and how to work with a variety of people.

Program Details

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

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

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

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

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  

Administrative Professional
XVIII. Administrative Professional
    A.    The Dynamic Workplace
    B.    Workplace Behaviors
    C.    Communication Essentials
    D.    Technology Basics
    E.    Records and Financial Management
    F.    Meetings and Travel
    G.    Career Advancement
    H.    Administrative Professional Exam
XIX. Customer Service
    A.    Customer Service Basics
    B.    Developing Responsible Customer Service Skills
    C.    Developing Verbal and Nonverbal Communication
    D.    Customer Service Best Practices
    E.    Attracting Loyal Customers
    F.    Customer Service Exam
XX. Goal Setting and Time Management
    A.    Become an Expert in Time Management
    B.    Understanding the Importance of Goal Setting
    C.    Creating a Strategy to Achieve Smart Goals
    D.    Implementing by Building a Support System
    E.    Sustaining Goal Setting for Success
    F.    Goal Setting and Time Management Exam
XXI. Working with Difficult People
    A.    The Impact of Unhealthy Personalities
    B.    Understanding People
    C.    Communication
    D.    Setting Boundaries
    E.    Handling Conflict
    F.    Working with Difficult People Exam
XXII. Business Writing
    A.    Major Functions and Forms of Business Writing
    B.    Writing and Communication Guidelines
    C.    Email and Instant Messenger
    D.    Letters, Documents, and Proposals
    E.    More Writing Tips
    F.    Business Writing Exam

View All Sections
Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included) Instructors
Tracy Berry

Tracy Berry 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, reporting/productivity applications, Microsoft Office, as well as the creation of online courses with software from leading vendors.

Prerequisites / Requirements

Students should be familiar with using a personal computer, mouse, and keyboard. They should be comfortable in a Windows environment, and have the ability to launch and close activities and navigate to information stored on the computer. They should also have an ability to manage files and folders.

This online program can only be taken on a PC; it is not Mac compatible. It is compatible with Windows XP and later operating systems and you will need the latest version of Internet Explorer, Firefox, Chrome, or Safari. We highly recommend that you use Firefox or Chrome in place of other web browsers. Adobe Acrobat Reader or an alternative software application to open and read PDF files is required. You will also need Microsoft Office Professional 2016 Suite or the Microsoft Office Professional Plus 2016 Suite for this program as there are no free trials. Both can be purchased online directly through Microsoft or other retail outlets. Manuals are included as downloadable PDFs throughout the program.

Administrative Professional with Microsoft Office Specialist 2016 (Vouchers Included) Frequently Asked Questions
Expand All
Can I register for programs if I am an international student?

Yes, since ed2go programs are online, you never have to actually travel to the school. Most schools offer telephone or online registration.

How long does it take to complete a program?
This program is self-paced and open enrollment, so you can start and finish at your own pace. Upon registering, you're given six (6) months to complete this program.
What if I don't have enough time to complete my program within the time frame provided?

The time allotted to complete your program has been calculated based on the number of course hours. If after a concerted effort, you are still unable to complete your program on time, your Student Advisor will help you work out a suitable completion date. Please note that a fee may be charged for an extension.

Do I have to buy additional materials?


Can I get financial assistance?

ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.

What happens when I complete the program?

Upon successful completion of the program, you will be awarded a certificate of completion. In addition, you will receive exam vouchers for 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) after successful completion of the program and financial obligation.

Am I guaranteed a job?

ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don’t provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

Who will be my instructor?
Each student is paired with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.
Can I use a Mac?


How can I get more information about this program?

If you have additional questions, please feel free to contact us via LIVE CHAT or by calling us at (855) 598-3856. If you are visiting us during non-business hours, please feel free to send us a question using the Contact Us form.

When can I start the program?

Our programs are all open enrollment. You can register and start the program as soon as you are ready.

Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

Does this program prepare for a certification?

Yes, you will be prepared for 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) and receive exam vouchers after successful completion of the program and financial obligation. 

Browse All
Talk to an admissions counselor
Got other questions? Get in touch with us via . During non-business hours, please feel free to send us a question using the "Contact Us" button. You can also reach us by phone (855) 520-6806.