Skip to header Skip to Content Skip to Footer

Business Analytics Series - Pivot Tables

Course Dates Coming Soon!

Think ahead! Register for Predictive Analytics, Power Query, and PivotTables & Visualization and save $198!


Course fee includes:

  • Course slides and handouts
  • Online Access to Course
  • Certificate

$999 for all three courses: Predictive Analytics, Power Query, and PivotTables & Visualization

UNCW Faculty/Staff/Students/Alum receive a 25% discount. Send an email providing your name and desired course and departmental fund to charge to initiate billing to your department with an IDI (internal Invoice). You can not pay with a UNCW Purchasing Card.

Active military members, veterans and spouses receive a 25% discount off of the course fee! Email the Swain Center directly for the discount code.

UNCW Swain Center is recognized by SHRM to offer SHRM-CP or SHRM-SCP Professional Development Credits (PDC). This program is valid for 4 PDCs toward SHRM-CP and SHRM-SCP recertification. For more information about certification or recertification, please visit SHRM Certification website.

Fully Online (Details will be emailed one week prior to start date.)

  • Dataset Exploration and Table Conversion
  • Flash Fill for Patterned Data
  • Constructing PivotTables
  • Flash Fill and PivotTable Basics
  • Filters, Slicers, and Timelines
  • PivotTable Calculations and Pivot Charts
  • Advanced PivotTable Skills
  • Accessing and Manipulating Data in a PivotTable

Note: This course is taught using Excel 2016. Older version users may be fine, but some features taught will not be fully compatible.