HCM Data Analysis Using Excel

Microsoft Excel is one of the most basic yet effective tools for data collection, visualization, and analysis. It doesn’t require any IT programming knowledge, yet it enables smart analytical solutions for all professions. The course will cover advanced Excel concepts for applying analytics to human capital management (HCM) data. Learn to communicate using data, be it for descriptive or advanced predictive analytics. The course will cover key statistical concepts like hypotheses testing, data distribution modeling, regression, and data clustering. Through practical examples and hands-on classroom exercises, gain the skills to analyze large data sets and learn how to apply the techniques to real-world business problems. By the end of the course, create an interactive HR dashboard from scratch to display data using power query and power pivot tools.

More details

You'll Walk Away with

  • The skills to analyze large data sets with the help of pivot tables and charts
  • The ability to apply key statistical concepts, including hypothesis testing, regression, and data clustering
  • The knowledge to create interactive HR dashboards to analyze HCM data and build reports

Ideal for

  • Human capital management professionals
  • Those interested in entering or furthering their career in the field of human resources
NO open sections available for this course at the moment. Please check back next semester.

    • Section

    • Semester

      Spring 2023
    • Date

      Jan 24 - Jan 31
    • Day

    • Time

      • Online
    • Format

      • Online
    • Sessions

    • Location

      Instructor Led
    Tuition $400