University of North Carolina Wilmington
University of North Carolina Wilmington

Swain Center: Executive Education and Economic Development

Business Analytics Course - Using Excel

Power Query

October 16, 2020

1:00 - 5:00PM

UNCW, Wilmington, NC

Register Now

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

Register for all three

Download the course brochure


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 10% discount. Choose the appropriate rate when registering for Swain programs online. If a UNCW department is funding your participation, use the Promo Code “SEAHAWK” to register online and initiate billing to your department with an IDI (internal Invoice). You can not pay with a UNCW Purchasing Card.

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

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

Learn to:

  • Efficiently perform routine tasks to make data analysis faster and more efficient
  • Extract meaningful insights from all available information
  • Quickly update files, folders, and charts with new data
  • Avoid mistakes in transforming and combining data

Businesses have access to more data than ever before, yet one common frustration is the inability to combine and analyze data from diverse data types, sources, and formats. This data variety results in data separation that prevents business managers from using all available information when making decisions. Bringing isolated data together encourages information sharing for more efficient and well-informed business decisions.

Spreadsheet software tools can assist with merging various channels of data.
  • 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

This program is designed for people who:

  • produce tables, charts, and reports in Excel
  • need to combine and analyze data from multiple sources
  • have basic Excel spreadsheet skills 

It is important to be proficient in business analytics to:

  • efficiently perform routine tasks quickly and efficiently 
  • extract meaningful insights from all available information
  • quickly update files, folders, and charts with new data
  • avoid mistakes in transforming and combining data

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

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

Dr. Stephen Hill Stephen 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.