- Work faster and more efficiently in Excel
- Append and merge data files and tables
- Merge multiple data tables, files, and folders
- Combine spreadsheet and text data
- Un-pivot raw data tables
- Import data from the Web
$399
Course fee includes:
$999 for all three courses: Predictive Analytics, Power Query, PivotTables & Visualization
UNCW Faculty/Staff/Students/Alum receive a 25% discount. Email swain@uncw.edu 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.)
Learn to:
This program is designed for people who:
It is important to be proficient in business analytics to:
"I am thankful to have had the opportunity to take this class. The concepts I learned I will definitely be able to use."
"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.""I enjoyed the learning opportunity and the quality of the teaching!"
"This was a high level course touching on the capabilities of Power Query."
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.