Excel for HR Beginner Tutorial
Exercise Files: https://learnitanytime.com/p/exercise-files-excel-for-hr-beginner-tutorial
Who it's for: HR professionals seeking to improve their data management skills in Excel, particularly in data cleaning, calculations, chart creation, and consolidation techniques tailored for HR tasks.
What it is: Microsoft’s spreadsheet application used to organize and analyze data.
What you'll learn: Students will learn foundational Excel skills tailored to HR data management. This course covers essential text functions like text-to-columns and Flash Fill for organizing employee data, along with the TODAY function to calculate service length. Students will explore formulas for calculating metrics like gross pay and remaining time off, while gaining an understanding of absolute references. Additionally, they will learn advanced tools such as XLOOKUP for searching employee records, COUNTIF for counting instances, and SUMIF and AVERAGEIF for analyzing program costs by employee or department. The course also demonstrates data consolidation from multiple sheets and creating dynamic visuals with charts and sparklines to enhance data interpretation. Through these skills, HR professionals will become proficient in organizing, calculating, and visualizing workforce data in Excel.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 00:09
Text to Columns Tool 01:32
Flash Fill 05:30
Calculate Length of Service with Today Function 08:47
Calculate Gross Pay and Days Remaining 13:25
Using a Form to Manage Records 19:13
Overview of the IF Function 23:48
Programs Completed by Employee with Countif 28:37
Cost of Training by Employee with Sumif 32:24
Naming Ranges for Reuse 35:48
Average Cost per Program with Averageif 40:27
Overview of Xlookup 44:25
Return Employee Details Based on Employee Number 50:31
Consolidate Sheets into a Single Report 57:02
Inserting a Chart 1:02:43
Managing an Inserted Chart 1:09:36
Capture Trend Analysis with Sparklines 1:14:39
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.