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!

$399

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.

  • Objectives

    By the end of this hands-on course, you will be able to:

    • Work faster and more efficiently in Excel
    • Visualize and summarize data using PivotTables, vlookup, flash fill, and charts
    • Identify the right chart for your data
    • Enhance charts for the right purpose
    • Data preparation, cleaning, and exploration
  • This program is designed for people who:

    • need to more efficiently prepare reports in Excel
    • have basic exposure to Excel
    • need to analyze data in Excel to enhance decision-making and/or reporting
  • It is important to be proficient in data analytics to:

    • efficiently perform routine data analysis tasks
    • make better decisions on how to allocate resources to improve your organization
    • quickly produce charts and tables that are easily understood by others
    • avoid mistakes in combining data
    • extract meaningful insights from data

    Why Business Analytics?

    Read About the Importance of Business Analytics

  • "I am thankful to have had the opportunity to take this class. The concepts I learned I will definitely be able to use."

    "I learned a vast amount of information. Analytics is unlike any other class I've taken thus far. It provided a challenge, but proved very interesting. I would definitely recommend this class."

    "Enjoyed the class and found it very interesting. Professor Hill was very helpful when I needed help."

    "I enjoyed the learning opportunity and the quality of the teaching!"

    "This course was efficient and presented with the audience in mind."

    "Instructor was very helpful and willing to assist outside of the training class."

  • Stephen Hill, PhD

    Assistant Professor of Analytics in the Analytics, Information Systems & Supply Chain Department
    Cameron School of Business at the University of North Carolina Wilmington

    A native of Alabama, Dr. Hill received his doctorate in Operations Management from the University of Alabama in 2008. At UNCW Dr. Hill teaches courses in analytics, operations management, and supply chain management. He has received several awards in recognition of his teaching.

    Dr. Hill's research focuses on application of analytics techniques in a variety of areas such as: supply chains, sports, and healthcare. He is also interested in research related to innovative approaches to education.