Swain Center for Executive Education

Business Analytics: Pivot Tables & Visualization

Dates:October 11, 2019 Other Dates
Meets:1:00 PM to 5:00 PM
Hours:4.00
Location:Computer Information Systems Bldg. 1003
Instructor:Stephen Hill
Fee: $399.00

For inquires contact the Swain Center at 910-962-2728.

Sorry, we are no longer accepting registrations for this course. Please contact our office to find out if it will be rescheduled, or if alternative classes are available.

Email Information to Friend Print

Description

Business Analytics: Pivot Tables & Visualization

Businesses have access to more data than ever before. It can be frustrating to combine data from different sources or to quickly analyze and create charts for decision makers. It doesn't have to be that way.

This course will enable you to understand, analyze, interpret, and present data in easy to understand formats. It is a fast-paced, intensive course that will introduce a range of tools and techniques to help you uncover important information and make better decisions.

Why is knowing how to use Business Analytics important?

It is important to be proficient in business analytics to:
  • automate routine tasks to make data analysis faster and more efficient
  • 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 https://www.fastcompany.com/most-innovative-companies/2016/sectors

Course Objectives:

  • Work faster and more efficiently in Excel.
  • Clean, prepare, and explore data in Excel.
  • Visualize and summarize data using Charts and PivotTables.
  • Identify the right visualization for your data.
  • Avoid common data visualization mistakes.
  • Enhance charts for the right purpose.
  • Integrate Excel with other Microsoft Office programs.