Learn essential Excel skills for human resource management through a comprehensive series of tutorials. Master data cleaning techniques, apply the 4/5ths rule, evaluate disparate impact, calculate means and standard deviations, perform correlation analysis, conduct independent-samples t-tests, and create scatterplots and bar charts for data visualization. Gain practical knowledge to effectively analyze and present HR-related data using Excel's powerful features.
Overview
Syllabus
Cleaning Data in Excel.
Applying the 4/5ths Rule in Excel.
Evaluating Disparate (Adverse) Impact in Excel.
Means & Standard Deviations in Excel.
Correlation in Excel.
Independent-Samples t-test in Excel.
Scatterplot Data Visualization in Excel.
Visualizing Disparate (Adverse) Impact Using Bar Charts in Excel.
Taught by
David Caughlin
