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

Excel 2016: Data Analysis with PivotTables
Overall Quality of This Course
Based on 14 student surveys.
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
The Pivot Tables tool is one of the most powerful yet intimidating features in Excel. Pivot tables allow you to quickly summarize and analyze large amounts of data in lists and tables--independent of the original data layout in your spreadsheet--by dragging and dropping columns to different rows, columns, or summary positions. In this class students will not only be able to summarize data to analyze, but also organize the data in a way that can be meaningfully presented to others. Students will learn how to Prepare Data and Create PivotTables, Analyze Data Using PivotTables, and Work with PivotCharts.
Course Objectives
  1. Prepare data for PivotTable reporting and create PivotTables from various data sources.
  2. Analyze Data Using PivotTables
  3. Work with PivotCharts
Outline of Instruction
  1. Prepare Data
  2. Create a PivotTable from a Local Data Source
  3. Create a PivotTable from an External Data Source
  4. Summarize PivotTable Data
  5. Organize and Filter PivotTable Data
  6. Format a PivotTable
  7. Create a PivotChart
  8. Manipulate PivotChart Data
  9. Format a PivotChart
Contact Hours
Industry Standard, State, or National Certification
CE to CU Articulation
Excel 2016 Level 3
Text and Supplies Needed
Textbook included with this course. Please bring a USB/Flash Drive to class for student files.
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Requirements for successful completion of a NON-CERTIFICATION CLASS - Demonstrate an understanding of at least 70% of course material taught.
Accreditation/Special Approval Requirements
Intended Audience
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
Course Contact Information
Elizabeth Knocklein