EXCEL FUNCTIONS EVERY HR PROFESSIONAL SHOULD KNOW
[Excel for HR] This video shows you powerful Microsoft excel formula and functions and excel features Human resource (HR) personnel can use to speed up workflow.
This video highlights some of the basic excel functions that are aimed at making the job of HR simpler and exciting!
#excel #hr #functions
00:04 Intro
00:26 Excel for HR - SUM & SUMIF functions
03:05 Excel for HR - DATEDIF and TODAY functions
05:40 Excel for HR - COUNT, COUNTIF, COUNTIFS functions
08:36 Excel for HR - COUNTBLANK, COUNTA
09:48 Excel for HR - MAX and MIN
10:20 Excel for HR - TEXT FUNCTIONS (UPPER,LOWER,PROPER, TRIM)
12:25 Excel for HR - CONCATENATE/ CONCAT FUNCTIONS
15:23 Excel for HR - VLOOKUP function
16:59 Excel for HR - INDEX/MATCH Function
18:20 Watch Next Video - Excel keyboard shortcuts to speed up workflow
People also ask
What does HR use Excel for?
What Excel skills are required for HR?
Is Excel needed for HR?
How can I do HR career in Excel?
WHAT YOU WILL LEARN - HOW TO USE:
Excel for HR: SUM excel functions
Excel for HR: SUMIFS excel functions
Excel for HR: DATEDIF excel functions
Excel for HR: TODAY excel functions
Excel for HR: COUNT excel functions
Excel for HR: COUNTIF(S) excel functions
Excel for HR: COUNTBLANK excel functions
Excel for HR: COUNTA excel functions
Excel for HR: MAX excel functions
Excel for HR: MIN excel functions
Excel for HR: UPPER excel functions
Excel for HR: LOWER excel functions
Excel for HR: PROPER excel functions
Excel for HR: TRIM excel functions
Excel for HR: CONCATENATE/ CONCAT excel functions
Excel for HR: VLOOKUP excel functions
Excel for HR: XLOOKUP excel functions
Excel for HR: INDEX AND MATCH excel functions
===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!
Excel for HR Professionals,
Excel Hacks for HR Professionals,
excel skills for hr and admin professionals,
excel for hr course free,
EXCEL FUNCTIONS FOR HR PROFESSIONALS
Excel Formulas, Top Excel Formulas, Helpful Excel Formulas, HR, Human Resources, Excel Tutorial, HR Formulas for Excel, how to calculate years of service, how to remove year from date, how to calculate percent change in salary, how to use formulas, basic excel formulas for hr, excel formulas for hr executive, excel formulas for hr, excel formulas for years of service, excel formulas for combining names, excel formulas and functions, 10 most used excel formula ☑️
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