Vision & Mission
Upcoming Events
MEFA Monthly Calendar
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
SWINBURNE
Certified Programs
UNIMAS
Certified Programs
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7498 7200
 
 
Information & Communication Technology
Human Resource Application Using Microsoft Excel
 
Objectives

  • ​Participants should have working knowledge of basic Excel functions, formulas, and number formatting techniques.

  • Participants will grasp various techniques and methods on analyzing human resources data, summarizing and presenting it a report format.

 
Topics Covered
1. WHY EXCEL IS A HR PERSON’S BEST RESOURCE
  • Uses for Excel in a HR context
  • Key features of Excel you need to know to help organize a spreadsheet
 
2. INCORPORATING AND FORMATTING HR DATA IN EXCEL
  • Importing HR data from text file into Excel and editing it
  • Using AutoFill, AutoFit and AutoComplete
  • Performing calculations using the usage of absolute and relative cell referencing ($ signs within formulas)
  • Validating specific data within column(s) or row(s)
  • Highlighting detailed information based on specific criteria for a range of cells
  • Creation of Headers and Footers
 
3. WORKING WITH ORGANIZATION DATA
  • Formatting Lists, Numbers and Dates
  • Formatting columns of data from text file
  • The Paste Special button
  • Combining data from different columns
  • Performing calculations on Dates
  • How to filter data
  • Removing duplicate data with Advanced Filter
  • Naming ranges
 
4. EXCEL FOR PERFORMANCE MANAGEMENT
  • Comparing different scenarios using logical functions
  • Looking up specific value from a database
  • Checking to see if an employee names exists in database
  • Screening employees by category
 
5. EXCEL FOR COMPENSATION CHANGES
  • Creating a payroll system in Excel
  • Updating a database
  • Selecting employee name by department
 
6. EXCEL FOR PERFORMANCE EVALUATION
  • Applying VLOOKUP and HLOOKUP
  • Highlighting criterias met by employees
  • Understanding Linear Regression
  • Creating Charts
  • Summarizing data with Tables
 
7. EXCEL FOR MARKET ANALYSIS
  • Applying Pivot Tables to summarize large quantities of data (e.g. analyzing large quantities of data quickly by performing sum and average values of specific fields of data and highlighting conditions using Conditional Formatting)
  • Using Goal Seek to perform a what-if analysis
  • Anticipating the number of extra employees needed for future growth (various what-if analysis are shown using Excel’s Goal Seek feature i.e. extra manpower and hours need should production increase)
  • Understanding Statistical Functions for consolidating employee demographics (performing analysis based on employee departments; age group; salary range, etc)
  • Tabulation of data using Frequency tables and histograms
 
8. CASE STUDY USING EXCEL
  • Apply the various functions and features shown to the raw data given
 
 
Target Audience

​Human Resource Personnel/Executives/Managers; anyone with any interest in understanding and utilizing Microsoft Excel in Human Resources Management.

 
Methodology
 
Scheme SBL Fee
Duration 14 Hours Members Less -