Administrative Professional with MS Office Master 2016 (Voucher Included)

Learn to be an integral part of any professional office team, from small businesses to major corporations. This program will teach you the fundamental skills you need to work as an administrative professional.

You will also learn Microsoft Office 2016 software and be prepared to sit 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.

Who Should Attend

Individuals who are interested in careers as:

  • Administrative Assistant
  • Receptionist
  • Executive Assistant
  • Department Secretary
  • Administrative Representative

Certificate Completion

Upon successful completion of the program, you will earn a certificate of completion from California State University, San Bernardino, College of Extended Learning.

What You'll Learn

You will learn essential administrative skills, such as how to work in a modern professional office, personal and professional ethics, communication essentials, records and financial management, event and travel planning, working with different personality types, and business writing.

You will learn an advanced level in Microsoft Word, Excel, PowerPoint, and Outlook 2016.

Delivery Format

  • The entire program is offered online
  • Instructor-facilitated online courses
  • Start anytime during the quarter
  • Learn from the convenience of your home and at your pace

Course Information
Course No. GES 872
Units NC
Fee $2,895


Training Time

365 hours; 6 months


expand I. 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
expand III. 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
expand II. 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
IV. Microsoft Excel Final Exam


expand V. 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
expand 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
expand 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
VIII. Microsoft Word 2016 Final Exam


expand IX. Introduction to Microsoft PowerPoint 2016
  1. Components of a Project
  2. Getting around in Microsoft Project 2016
  3. Calendars
  4. Working with Tables
  5. Creating and Working with Resources
  6. Managing a Project
  7. Introduction to Microsoft Project 2016 Exam
XI. Microsoft PowerPoint 2016 Final Exam
expand X. 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. Microsoft PowerPoint Features that Were New in 2013
  11. Features New in 2016
  12. Advanced Microsoft PowerPoint 2016 Exam


expand XII. 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
XIV. Microsoft Outlook Final Exam
expand XIII. 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

Administrative Professional

expand XV. Administrative Professional
  1. The Dynamic Workplace
  2. Workplace Behaviors
  3. Communication Essentials
  4. Technology Basics
  5. Records and Financial Management
  6. Meetings and Travel
  7. Career Advancement
  8. Administrative Professional Exam
expand XVII. Goal Setting and Time Management
  1. Become an Expert in Time Management
  2. Understanding the Importance of Goal Setting
  3. Creating a Strategy to Achieve Smart Goals
  4. Implementing by Building a Support System
  5. Sustaining Goal Setting for Success
  6. Goal Setting and Time Management Exam
expand XIX. Business Writing
  1. Major Functions and Forms of Business Writing
  2. Writing and Communication Guidelines
  3. Email and Instant Messenger
  4. Letters, Documents, and Proposals
  5. More Writing Tips
  6. Business Writing Exam
expand XVI. Customer Service
  1. Customer Service Basics
  2. Developing Responsible Customer Service Skills
  3. Developing Verbal and Nonverbal Communication
  4. Customer Service Best Practices
  5. Attracting Loyal Customers
  6. Customer Service Exam
expand XVIII. Working with Difficult People
  1. The Impact of Unhealthy Personalities
  2. Understanding People
  3. Communication
  4. Setting Boundaries
  5. Handling Conflict
  6. Working with Difficult People Exam

Skill Sets

  • Ethical behavior in the workplace, business etiquette, written and verbal communication and effective customer service
  • Causes of workplace stress and how to handle them
  • Records Management, different types of meetings, making travel arrangements, and understand the functions of management
  • How to create and edit formulas, audit equations, and present information in charts and tables
  • How to create and format professional business documents, including mail merges, Web pages, and interactive forms
  • How to create and modify slide presentations, including editing graphics, formatting text and text boxes, and animating objects and transitions
  • How to create and edit Outlook objects, such as e-mail, meetings, tasks, and contacts


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 the Microsoft Office 2016 Suite for this program as there are no free trials.

Manuals are included as downloadable PDFs throughout the program.


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