logo
Find a Training Center x

Certificate in Excel- HUMAN RESOURCE

  • No Rating
  • (0 Reviews)
  • 0 User Enrolled

Certificate in Excel- HUMAN RESOURCE

EXCEL FOR HUMAN RESOURCE HAS A TOTAL OF 8 MODULES AND DETAILED EXPLANATION OF ALL THE TOPICS OF HR LIKE HR REPORT, CHART & ANALYSIS, FORMATTING, PIVOT CHART, AND TABLE, HR DASHBOARD, PAYROLL MANAGEMENT, ATTENDANCE SHEET ETC.

  • No Rating
  • (0 Reviews)
  • 0 User Enrolled
  • 349
  • 999
  • Course Includes
  • Valuable demand videos
  • Downloadable Resources
  • Certificate


Course Content

8 sections • 22 lectures • 04h 07m total length
M-1 V-1 OVERVIEW OF THE SCREEN AND NAVIGATION
18:31min
M-1 V-2 WORKBOOK AND WORKSHEET CONCEPT
19:24min
M-1 V-3 VARIOUS SELECTION AND TECHNIQUE IN EXCEL
28:33min
M 5 V 2 VLOOKUP IN EXCEL FOR HR
16:24min
M-2 V-1 CUSTOMIZATION RIBBON TAB COMMAND IN EXCEL
7:46min
M-2 V-2 CUSTOMIZATION QUICK ACCESS TOOLBAR IN EXCEL
5:46min
M-2 V-3 CUSTOMIZATION LIST SERIES IN EXCEL
preview min
M-3 V-1 SUMIF() AND SUMIFS() IN EXCEL
11:08min
M-3 V-2 COUNTIF() AND COUNTIFS() IN EXCEL
5:56min
M-3 V-3 AVERAGEIF() AND AVERAGEIFS() IN EXCEL
8:43min
M-4 V-1 TEXT FUNCTIONS UPPER LOWER PROPER IN EXCEL FOR HR
5:46min
M-4 V-2 TEXT FUNCTIONS TRIM() CONCATENATE() IN EXCEL FOR HR
6:19min
M-4 V-3 LOGICAL FUNCTION IF() | IF(AND() | IF(OR)) IN EXCEL FOR HR
13:00min
M 5 V 1 DATABASE CREATION IN EXCEL FOR HR
16:08min
M 5 V 3 INTERACTIVE DATABASE IN EXCEL FOR HR
12:17min
M 6 V 1 EMPLOYEE DATABASE FOR PAYROLL IN EXCEL FOR H
10:45min
M 6 V 2 ATTENDANCE AND OVERTIME SHEET FOR PAYROLL IN EXCEL FOR HR
10:02min
M 6 V 3 SALARY SLIP FOR PAYROLL IN EXCEL FOR HR
5min
M 7 V 1 CONCEPT OF CHART AND GRAPH IN EXCEL FOR HR
3:22min
M 7 V 2 COLUMN AND BAR CHART AND GRAPH IN EXCEL FOR HR
7:43min
M 7 V 3 LIE AND PIE CHART/GRAPH IN EXCEL FOR HR
12:27min