Excel for HR Full Course Tutorial

Exercise Files: https://learnitanytime.com/p/exercise-files-excel-for-hr-full-course-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 can expect to learn a comprehensive range of Excel functionalities tailored for human resources applications. Key topics include the use of text functions to clean and organize data, formulas and functions like XLOOKUP and TODAY for calculations, and tools like charts for data visualization. The course also delves into advanced features such as consolidating worksheets into cohesive reports, conditional functions like COUNTIF, SUMIF, and AVERAGEIF for data analysis, and implementing dashboards for interactive data summaries. Additional modules cover formatting tables, filtering data using slicers, and creating dynamic charts and sparklines for trend analysis. Through practical exercises, students gain hands-on experience with real-world HR datasets, enhancing their ability to efficiently manage and analyze HR 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 01:02:43
Managing an Inserted Chart 01:09:36
Capture Trend Analysis with Sparklines 01:14:39
Introduction to Module 2 01:19:13
Filtering a Converted Table 01:19:49
Table Slicer Tool 01:24:45
Total Row 01:28:32
Conditional Formatting 01:31:23
Subtotal Tool 01:35:59
Restrict Cell Input with Data Validation 01:40:11
Import Data From Other Source 01:44:04
Inserting a Recommended Pivot Table 01:46:56
Show Value as Percent of Grand Total 01:50:59
Drill Down Reports 01:54:16
Report Filter Pages 01:56:43
Inserting a Pivot Chart 02:00:21
Conclusion 02:02:57

#excel #exceltutorial #exceltips #exceltricks

(C) 2024 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.