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

Course
Mastering Data Analysis with Excel 2016
Name
SEF-3001IW2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone interested in using Excel to analyze, visualize, and store data.
Description
Around the world, Microsoft Excel has become an integral part of business. It’s used in organizations, academia, and personal settings to analyze, visualize, and store data. In this course, you’ll use data analysis, auditing, Sparklines and forecasting. And you’ll understand how to graphically display the relationship between formulas and cells, quickly find data, visually represent data, show trends, and use data mapping to help resolve problems.
Course Objectives
  1. Know how to make workbook edits with multiple users
  2. Understand how to analyze data
  3. Use Excel features to structure and visualize data
Outline of Instruction
  1. Working with Multiple Worksheets and Workbooks
  2. Using Lookup Functions and Formula Auditing
  3. Sharing and Protecting Workbooks
  4. Automating Workbook Functionality
  5. Creating Sparklines and Mapping Data
  6. Forecasting Data
Contact Hours
8
CEU's
0.8
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
Excel 2016 Essentials
Text and Supplies Needed
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Demonstrate an understanding of at least 70% of course material taught.
Accreditation/Special Approval Requirements
Intended Audience
Anyone interested in using Excel to analyze, visualize, and store data.
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
Course Contact Information
Elizabeth Knocklein
919-866-7209