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 2016 Master (Vouchers Included)
Return to Administrative

Administrative Professional with Microsoft Office 2016 Master (Vouchers Included)

To be a successful administrative professional, you must possess skills to handle a wide variety of workplace tasks and situations. The job of an administrative professional is a widely varied one and this course teaches across that variety of needed skills. Being able to work with Microsoft Office 2016 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, and Outlook will allow you to do work independently and be a problem solver at your job. The material 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 Certification Exams 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), and 77-731 (Outlook). The registration fee for these exams are included with this program. This program is entirely online and is completed at your own pace. When you register, you receive six (6) months to complete this program.

6 Months / 365 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

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

Administrative Professional with Microsoft Office 2016 Master (Vouchers Included)

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

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

Course Code: GES872

You Will Learn
  • Learn Microsoft Office 2016, including Excel, Word, PowerPoint, and Outlook
  • Understand how to maintain a professional image and adhere to common workplace ethics
  • Master an understanding of time, resource, and stress management
  • Prepare yourself to take Microsoft Certification Exams
How the course is taught
  • Self-paced, online course
  • 6 months to complete
  • Open enrollment, begin anytime
  • 365 course hours
How you will benefit
  • Become prepared to take the Microsoft Certification Exams 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), and 77-731 (Outlook)
  • Communicate effectively in the professional world
  • Jump-start your career as an administrative professional
  • Gain confidence in your computer-using abilities
Administrative Professional with Microsoft Office 2016 Master (Vouchers Included) Outline
Expand All
Microsoft Excel

Learn the fundamentals of Excel. From an introduction to advanced topics, you’ll cover everything from data entry and creating worksheets to advanced formulas and visualizations.

Microsoft Word

Understand how to create a Word document, enter text and illustrations, and edit and finalize documents.

Microsoft PowerPoint

Master Microsoft PowerPoint from basic functionalities to advanced offerings. Learn how to work with standard images and texts, as well as using special effects and multimedia input.

Microsoft Outlook

Explore Outlook and its many uses. You’ll understand how to send mail, organize contacts and calendars, and cover the program’s latest features.

Introduction to Becoming an Administrative Professional

Learn about common workplace dynamics and vital communication skills needed to succeed in a professional environment. Understand what office technology to familiarize yourself with as well as how to seek career advancement opportunities.

Customer Service, Goals, and Office Skills

Master what it takes to thrive in a business setting. In this section of the course, you’ll learn how to efficiently and positively interact with customers, employers, and peers. You’ll also cover how to set and achieve goals and meet dealdlines, how to handle difficult personalities in the workplace, and everything you need to know about business writing.

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

Administrative Professional
XV. 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
XVI. 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
XVII. 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
XVIII. 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
XIX. 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 2016 Master (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 2016 Master (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 what 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 Certification Exams 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), and 77-731 (Outlook). 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 Master Certification Exams 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), and 77-731 (Outlook) and you will 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.