University of North Carolina Wilmington
University of North Carolina Wilmington

Swain Center

Data Analytics Course - Using Excel

PivotTables & Visualization

Fall: September 15, 2017
8:30 am - 12:30 pm
UNCW, Wilmington, NC
$399

Register for Fall

Spring: February 9, 2018
8:30 am - 12:30 pm
UNCW, Wilmington, NC
$399

Register for Spring

Register for BOTH PivotTables & Visualization and Power Query and save $99!

Register for Both: Fall
Register for Both: Spring

$399

$699 for both PivotTables & Visualization and Power Query

FREE WEBINAR:
August 22 | 12 - 1 p.m.: Importing data from the Web; un-pivoting raw data files

Register Now

Receive a $50 coupon code to use towards any fall or spring Data Analytics course offering when you attend the webinar!

UNCW Campus

Computer Information Systems Building, Room 1003

Parking Information

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.

Course fee includes:

  • Course slides and handouts
  • Parking
  • Certificate

February 9, 2018 - Workshop 1: PivotTables & Visualization

Register

February 16, 2018 - Workshop 2: Power Query

Register

Register for BOTH workshops and save $99!

Businesses have access to more data than ever before. It can be frustrating to clean and prepare data from different sources and then quickly analyze and create impressive visualizations for decision makers. It doesn’t have to be that way.

This course will enable you to understand, prepare, analyze, interpret and present data using Excel. This is a fast-paced, hands-on course that will introduce a range of tools, techniques, tips, and tricks to help you make better decisions using data. The course will feature an in-depth exploration of PivotTables. PivotTables are primarily used to easily and efficiently summarize, explore, and present data.

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

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
  • to avoid mistakes in combining data
  • extract meaningful insights from data

Check out the 'Data Science' sector of Fast Company's Most Innovative Companies of 2016!

This course is best for people who:

  • are responsible for producing reports in Excel and wish to be more efficient
  • have basic exposure to Excel
  • need to perform analyze data in Excel to enhance decision-making and/or reporting 
  • 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

"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!"

Dr. Stephen Hill is the instructor of the Data Analytics Using Excel CourseStephen Hill, PhD is an Assistant Professor of Analytics in the Analytics, Information Systems & Supply Chain Department in the Cameron School of Business at the University of North Carolina Wilmington (UNCW). 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.