Excel for HR Professionals | HR Excel Skills to know | HR meets Excel
Excel made easy for HR. This video shows you how important and powerful excel skills for Human Resource HR professionals.
Excel for HR Professionals | HR Excel Skills to know | HR meets Excel
00:02 Why HR needs excel
00:35 HR Excel Skills to know - Filtering Data
01:27 Shortcut key to activate Data filtering in Excel
02:46 HR Excel Skills to know - TODAY() function
04:22 HR Excel Skills to know - DATEDIF function
07:44 HR Excel Skills to know - COUNTIF function
09:11 HR Excel Skills to know - SUMIF function
11:26 HR Excel Skills to know - Data Validation
13:30 HR Excel Skills to know - VLOOKUP function
15:35 HR Excel Skills to know - PIVOT table
22:02 Watch Next Video -
People also ask
What Excel skills are required for HR?
Is Excel useful for HR?
How can I do HR career in Excel?
How Excel can help in HR Analytics?
#Excel for #HR #Professionals | HR Excel Skills to know | HR meets Excel
===POWER PACK ===
Join over 500 + professionals that Have gone from Zero-to-Hero in our Excel course: https://bit.ly/3vIQOpB
__________
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://paypal.me/touchinglivesent?co...
Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
===========================================================
What you will Learn:
HR meets Excel - #1: Filtering data
Tip: Filtering can be used in other HR areas such as:
Tracking time and attendance in an employee attendance report
Active employees report
New employees onboarding report
Completion status of performance appraisal
=====================================
#2: TODAY
#3: DATEDIF
#4: COUNTIF
#5: SUMIF
#6: Data Validation
#7: VLOOKUP
#8: PivotTables
excel data forms, excel data entry forms, creating data entry forms, creating excel data entry forms, how to create excel forms, how to create excel data entry forms, exel data entry forms, ecxel forms, doing excel data entry, exel data entry, excel data entry, creating excel entry forms for dummies, creating excel forms, data entry in excel, data entry in exel
EXCEL made easy, Excel Tutorials, Leila Gharani, Excel 2016, Excel 2013, Excel 2010, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, how to create data entry form in excel, data entry from without vba, data entry, excel data entry form, excel data entry form with data validation, excel data entry form for table, excel data entry form button, excel hidden features, excel hidden tips