Excel for HR Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Excel for HR Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Data Analysis Data Visualization HR Analytics Excel Excel formulas
Free
15 minutes
English

Provided by

Youtube is a video-sharing platform that offers a wide variety of educational content, including lectures, tutorials, and courses on a wide range of subjects....

Description

The content discusses the process of benchmarking market pay for multiple jobs within an organization, using specific examples from IT management and data analytics roles. It highlights the importance of analyzing job descriptions and market data to determine fair salaries. The presenter uses market data services such as Mercer or Aon Hewitt to gather information on minimum, median, and maximum salaries for different job levels. They then demonstrate how to use Excel to create a floating bar chart that visualizes this data, allowing HR professionals to present findings in an easily understandable format. This content assumes some basic knowledge of HR practices and Excel skills. The presenter also emphasizes the need to analyze market trends and make data-driven decisions when adjusting salaries. By using a visual representation of market data, HR professionals can effectively communicate salary adjustments to management and stakeholders. learn more

Professions

Talent Acquisition Manager Payroll Specialist Human Resources Manager HRIS Manager HR Generalist HR Business Partner Excel Developer Data Analyst Compensation Analyst Business Intelligence Developer

More courses by YouTube

Cookie preferences

This website uses the following types of cookies: strictly necessary, functional, and visitor statistics cookies.