Administrative Professional with MS Office Specialist 2016

Administrative professionals are the backbone of a professional organization, helping keep the team organized and operating efficiently.

In this program, you will learn the skills you need to support an organization, manage stressful situations that may arise, and excel in an administrative career.

This program will also prepare you to sit for the Microsoft Office Specialist Certification 77-727 and 77-728 (Excel), 77-725 and 77-726 (Word), 77-729 (PowerPoint), 77-731 (Outlook), and 77-731 (Access).

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

In this program, you will learn how to work in a modern professional office. Some of the topics covered include how to maintain a professional image, personal and professional ethics, communication and technology essentials, records and financial management, event planning and travel, how to manage one’s own career advancement, goal setting and time management, working with different personality types, and business writing.

You will also learn an advanced level of Microsoft Word, Excel, PowerPoint, Outlook, and Access 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 862
Units NC
Fee $2,395


Training Time

455 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
  • Orientation to the Dental Profession: Dental Basics


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


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


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


expandXV. 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
XVII. Microsoft Access Final Exam
expandXVI. 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

Administrative Professional

expandXVIII. Administrative Professional2016
  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
expandXX. 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
expandXXII. 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
expandXIX. 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
expandXXI. 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
  • How to create and Manage databases, including creating tables, forms, reports and strategies for archiving data with Action Queries


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