YoVDO

Excel Tutorials

Offered By: YouTube

Tags

Microsoft Excel Courses Data Visualization Courses Data Cleaning Courses Human Resource Management Courses Correlation Courses Bar Charts Courses t-tests Courses Scatterplots Courses

Course Description

Overview

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.

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

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard