NPTEL
FreeExcel for HR Full Course Tutorial
No ratings yetADVANCEDEnglish
YouTubeYouTubePrice
This course is free to watch on its platform.
Watch free on YouTube →Mark your own learning status. Opening a course link does not establish enrollment.
Loading saved status…
This full course focuses on the spreadsheet tasks HR teams handle every week: cleaning messy records, calculating length of service and pay, and summarizing training costs and programs by employee. The lessons use HR-style datasets, so each formula is taught in the context where it will be used.
HR professionals who want to handle their own data without waiting on analysts will benefit most. The course is marked advanced, so the dashboard and consolidation sections are where most of the new material sits.
Excel for HR Full Course Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/2t632m6r
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.
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
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Advertisement
No Korshub reviews yet.
