Professional Skills & Development

Wake Tech's professional development courses are specifically designed to enhance your resume. These courses give you skills such as how to compose executive reports and organizational procedures; how to communicate between generations and cultures; and more. 

Need help writing your resume or preparing for job interviews?
Explore our skills training for job seekers courses.

Course Details & Registration Information

Microsoft Excel 2016 Certification Core 77-727
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
This course is intended for students that want to pass the Microsoft Office Specialist Excel Certification Exam.
Excel is Microsoft’s popular spreadsheet program that allows users to enter and manipulate data. When you successfully pass the Microsoft Office Excel 2016 Core credential, you can evidence a fundamental understanding of the Excel environment. This course will cover all exam topics to create and manage worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions, and create charts and objects.
Course Objectives
  1. Upon successful completion of this course, students will be prepared to pass the Microsoft Office Specialist Excel 2016 Exam.
Outline of Instruction
  1. Tracking Customer Data
  2. Recording Students Grades
  3. Data Visualization and Images
  4. Organizing Large Amounts of Data
  5. Advanced Workbook Formatting
  6. Date Functions and Conditional Formatting
  7. Advanced Functions for Text and Analysis
  8. Lookup Functions and Outlines
  9. Working with Tables
  10. Financial Functions and What-If Analysis
  11. PivotTables and PivotCharts
  12. Workbook Completion
Contact Hours
Industry Standard, State, or National Certification
Microsoft Office Specialist Excel 2016
Website URL
Certification Learning Outcomes/Requirements
  1. Create Worksheets and Workbooks
  2. Manage Data Cells and Ranges
  3. Create Tables
  4. Perform Operations with Formulas and Functions
  5. Create Charts and Objects
CE to CU Articulation
File Management or a working knowledge of Windows File Management
Text and Supplies Needed
USB Flash drive
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Requirements for successful completion of CERTIFICATION CLASSES - Students are required to take AND pass the official course certification exam before the class program ends AND provide visual evidence of successfully passing the official course certification exam to the course teaching faculty. Students who do not pass the official course certification exam, will not receive a class certificate AND will receive a grade of NG (no grade).
Accreditation/Special Approval Requirements
Intended Audience
This course is intended for students that want to pass the Microsoft Office Specialist Excel Certification Exam.
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
Course Contact Information
Jennifer Simmons-Bage