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 ===
__________
__________

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