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

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent