CIS101 - PPT
•Download as PPTX, PDF•
0 likes•109 views
Human resource management involves recruiting, hiring, deploying, and managing employees. It includes functions like recruiting, compensation, training, labor relations, and organizational development. Traditionally, HRM involved time wasted on lengthy and unproductive tasks with vast amounts of data. Microsoft Excel can help simplify HRM tasks through functions like VLOOKUP, SUMIF, SUM, and pivot tables which allow arrangement of employee data, maintenance of salary sheets, creation of understandable summaries, and analysis of employee distribution and origins.
![Help of Microsoft Excel
Excel function used to simplify Human Resource Management
#1: Vlookup #2: SUMIF
#3: SUMTOTAL
Pivot
Chart
=SUMIF (range, crit
eria, [sum_range])
=SUM (number1, [
number2], [numbe
r3], ...)](https://image.slidesharecdn.com/jahirulislamcisppt-200811181051/85/CIS101-PPT-7-320.jpg)
CIS101 - PPT
- 2. 01 Introduction Human Resource Management 02 What Is Human Resource ? 03 Problem Statement 04 Solution With Microsoft Excel
- 3. Introduction
- 4. What Is HRM? Human resource management (HRM) is the practice of recruiting, hiring, deploying and managing an organization's employees.
- 5. Division Of HRM ï‚· Recruiting and staffing ï‚· Compensation and benefits ï‚· Training and learning ï‚· Labor and employee relations ï‚· Organization development
- 6. Problem Statement Time WasteLengthy Unproductive Vast Data
- 7. Help of Microsoft Excel Excel function used to simplify Human Resource Management #1: Vlookup #2: SUMIF #3: SUMTOTAL Pivot Chart =SUMIF (range, crit eria, [sum_range]) =SUM (number1, [ number2], [numbe r3], ...)
- 8. Benefits Arrangement of data according to age, employee id, name and date of birth etc. Arrangement of recruitments process Maintaining the salary sheet of all the employee’s through the use of lookup function.
- 12. Pivot Table Creating easy and understandable date. To summarize, sort, reorganize, group, count, total or average data stored in a database.
- 13. Distribution 16% Financial Control 17% Human Relations 17% Operations 33% Sales 17% Intake Of Recruits Distribution Financial Control Human Relations Operations Sales
- 15. Thank You