HR & People Analytics Using Excel: HRexcel -HR Analysis

Learn to distinguish quantitative and qualitative human resources data, with numbers and descriptive observations, and see how metrics like retention, salary, and performance appraisals drive Excel analytics.

Identify key sources of HR data such as surveys, attendance, reviews, salary history, demographics, recruitment data, and HRIS systems; use valid, reliable, bias-free data to compute turnover metrics reflecting performance.

Discover the foundations of analytics, from data concepts and sources to descriptive, predictive, and prescriptive maturity stages. Learn how Excel supports analytics with basic and calculated measures and attributes.

Learn to use Microsoft Excel for HR analytics by working with base measures such as headcount and turnover, creating calculated measures like employee age, and exploring attributes and central tendency.

Learn to compute mean, median, and mode in Excel with salary data, format currency, and apply central-tendency concepts to HR analytics.

Inspect and clean employee data in Excel, format columns, convert to a table, and derive calculated measures like age and length of service for insights via the pivot table.

Explore statistics in human resources and use Excel's Analysis ToolPak to obtain descriptive statistics, including mean, median, mode, range, standard deviation, and variance for workforce data.

Activate the Excel Analysis ToolPak by going to File, Options, Add-ins, then selecting Analysis ToolPak and completing the installation to enable data analysis in Excel.

Explore seven strategic HR metrics that track the employee lifecycle from recruitment to assets, using HR analytics with Excel to assess efficiency, effectiveness, and future trends.

Discover key HR metrics in Excel: cost per hire reveals recruitment ROI by dividing recruitment costs by hires, while evaluating recruitment source effectiveness and job offer acceptance rates.

Discover HR analytics using Excel to track revenue per employee, average length of service, turnover and retention, and employee satisfaction for data-driven people management.

Apply practical excel techniques to calculate key HR metrics like new hire turnover rate, offer acceptance rate, and retention rates using templates and simple formulas.

Learn to calculate employee turnover and retention rates in excel with a practical example: 180 initial employees, 10 left, 17 joined, yielding 5.56% turnover and 94.44% retention.

Master calculating the workforce age distribution in Excel by using nested IF formulas to classify ages into baby boomers, generation X, and millennials, then compute the average age.

Practice calculating HR metrics in Excel by computing turnover rate and retention rate, and determine workforce age distribution and average age to sharpen people analytics skills.

Learn how to use Excel charts for HR reports, including column charts for comparisons, line charts for trends like turnover, and pie charts for gender distribution.

Leverage pivot tables in Excel to create HR reports, analyzing workforce age, gender, and length of service distributions from a structured employee data table.

Explore pivot table basics to summarize employee data by dragging fields to rows, columns, and values, creating age, length of service, and gender distributions.