Microsoft Excel For HR Professionals: 9 Essential Functions You Must know
Recruitment, training & development, compensation & benefits, payroll, employee relations, staff retention, etc. HR professionals are often seemed to have the easiest jobs in the company.Or is it?In reality, what goes behind the scenes is the endless amount of human resource information system (H.R.I.S.) inputs, preparing reports for the management, and spending face-time with employees just to get the day-to-day work done.Here’s some Excel magic to help you cut your day-to-day HR work from days and hours to just MINUTES. Areas Covered #1: TODAY#2: DATEDIF#3: EDATE#4: NETWORKDAYS.INTL#5: WORKDAY.INTL#6: COUNTIF#7: SUMIF#8: Vlookup#9: ChartsCourse Level - Basic/IntermediateWho Should Attend Business owners CEO’s/CFO’s/CTO’sBank Managers and Bank TellersManagers of all levelsFinancial ProfessionalsAccountantsCPAsControllersFinancial ConsultantsIT ProfessionalsAuditorsHuman Resource PersonnelBookkeepersMarketersAnybody who uses Excel on a regular basis, and want to be more efficient and productive
Single
Recruitment, training & development, compensation & benefits, payroll, employee relations, staff retention, etc.
HR professionals are often seemed to have the easiest jobs in the company.
Or is it?
In reality, what goes behind the scenes is the endless amount of human resource information system (H.R.I.S.) inputs, preparing reports for the management, and spending face-time with employees just to get the day-to-day work done.
Here’s some Excel magic to help you cut your day-to-day HR work from days and hours to just MINUTES.
Areas Covered
- #1: TODAY
- #2: DATEDIF
- #3: EDATE
- #4: NETWORKDAYS.INTL
- #5: WORKDAY.INTL
- #6: COUNTIF
- #7: SUMIF
- #8: Vlookup
- #9: Charts
Course Level - Basic/Intermediate
Who Should Attend
- Business owners
- CEO’s/CFO’s/CTO’s
- Bank Managers and Bank Tellers
- Managers of all levels
- Financial Professionals
- Accountants
- CPAs
- Controllers
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive