WHAT EXCEL FUNCTIONS DO YOU NEED TO MASTER WHEN WORKING IN HUMAN RESOURCES?

**There is a set of PHP OA source code with complete functions with workflow functions, and there is source code for secondary development, which is fast and safe.

OA system menu structure.

1.My desk.

a) Email.

b) Short messages.

c) Important documents (including meeting minutes)?

d) Schedule (Inquire about other employees' schedules with their own and sub-permissions) e) Work Diary (Inquire about other employees' schedules with their own and sub-permissions) f) Newsletter Book.

Personal address book (with management function).

Public address book (with management functions by permission).

g) File cabinets.

Personal filing cabinets.

Departmental filing cabinets.

h) Hard drive backup.

i) Control Panel.

2.What does document management (archive) look like?

a) Submission management (writing, reviewing?) , submitted, numbered) including meeting minutes?

b) Archiving management (what is the archiving method?) )

3.Project management (work plan).

a) Business.

b) Production.

c) Engineering maintenance.

d) Procurement.

e) Research and Development.

4.Item management.

a) (Consumables) Office Labor Insurance (Warehousing Registration, Inventory Impairment, Warehousing Records, Inquiry) b) (Consumables) Feed Green Feed (Warehousing Registration, Inventory Impairment, Warehousing Records, Inquiry) c) (Consumables) Drugs and Devices (Warehousing Registration, Inventory Impairment, Warehousing Records, Inquiries) D) (Consumables) Hardware and Miscellaneous Products (Warehousing Registration, Inventory Impairment, Warehousing Records, Inquiries) E) Fixed Assets (Company, Kunyan Class II) (Warehousing Registration, Receipt Records, Inquiries) F) ** Business management (i.e., customer relationships).

g) Statistical analysis.

h) Librarianship (for some important materials)?

5.Personnel management.

a) Employee files.

b) Attendance management.

Arrive late and leave early. All kinds of leave.

Business trip. c) Assessment management.

d) Labor management.

6.Business management.

a) Customer Relations.

b) Sales management (sales contract).

c) Customer Surveys.

d) Client Asset Management.

e) Statistical analysis.

7.Quality Management (How to set the menu?) )

a) Management Review.

b) Internal Audit.

c) Work improvement.

8.Logistics.

a) Dining statistics.

b) Housekeeping.

c) Repair Guarantee.

d) Vehicle management.

Vehicle files. Usage Records.

Maintenance records. 9.Resource management.

10.Exchange of information.

a) Announcement and notification (including management functions).

b) Employee voting (including management functions).

c) Employee Forum.

d) Web conferences.

e) Organizational information.

11.Standby function.

a) Workflow.

1. Create a new job.

2. To-do work.

12.Attachment Procedures.

Employee roster, employee entry form, employee resignation form, employee welfare insurance, employee appraisal form, employee recruitment, turnover rate, etc.

Many of them require ECXEL**, such as rosters, employee payroll schedules, and so on.

1. In terms of organizational structure, it is necessary to make a staffing plan, etc.;

2. In terms of recruitment configuration, it is necessary to make recruitment application forms, annual recruitment budget forms, application registration forms, interview record forms, employment confirmation forms, probation period assessment forms, etc.;

3. In terms of training and development, it is necessary to make an annual training plan, a training application form, a training plan implementation form, a training effect questionnaire, a training achievement evaluation form, a training cost budget table, etc.;

4. In terms of salary and benefits, it is necessary to make annual salary budget table, salary schedule, salary structure table, social security payment schedule, etc.;

5. In terms of performance appraisal, monthly, quarterly, and annual performance appraisal forms, reference lists for performance evaluation, and performance summary tables should be made;

6. In terms of labor relations, it is necessary to make a roster of employees, a detailed list of labor contract signing, and a record of labor disputes.

Each company's human resources sector has different weight distribution and information needs, there is no fixed number and format, and each human resources specialist needs to be formulated and implemented according to the actual situation of the company.

Appraisal form. Performance Table. Payroll.

The question is really not clear, but you can roughly guess what you mean.

If you ask about the function of Excel, it is the following:

1. The more frequent is the first design, which needs to use various text and cell typesetting functions;

2. Data statistics and analysis are used for work summary or reporting, so simple function operations, pie charts, and curve charts should be used;

3. If you want to design the organizational structure, it is also to use charts;

4. If human resources are still involved in administrative work, then excel will also use the ** mixed arrangement function to compile a poster or something.

Excel is used for data statistics and tabulation, so the HR department will use the software to compile employee rosters, employee information databases, lists, training demand tables, ......There are too many to list.

if(countif(a$2:a2,a2)>=7,"Absent from work for a day",if(b2<5,"Arriving late",if(b2<=30,"Donate 30 yuan",if(b2<=180,"Absenteeism for half a day","Absent from work for a day")))

Drag the formula down, and the attendance type appears in column C. Hope that helps.

1.Data calculations.

2.Statistics.

3.Chart. 4.Format.

The problem is too unclear, excel can be used, will be used.

Basic operations: setting fonts, cell formatting, column and column height, filtering, searching, copying and pasting, automatic summing, document encryption, etc.

Efficiency improvement: 1) If there is a lot of data, you need to master the application of some formulas.

For example, vlookup (longitudinal search) is useful to match personal information such as employee entry and exit time.

sumif (summing of conditions), summarizing salespeople's performance, rankings, etc. can be used.

countif (conditional count), statistics on the number of people in the group, the status of meeting the standard, etc. can be used.

sumtotal (sub-summary application), payroll by department, labor costs, etc. are available.

2) Some other common operations:

Conditional formatting (conditional filtering) commonly used personnel duplicate filtering, tag rule filtering information;

Filling, commonly used to fill down, quickly supplement the information of personnel in the same department.

Thinking about this for the time being, I hope you

if(countif(a$2:a2,a2)>=7,"Absent from work for a day",if(b2<5,"Arriving late",if(b2<=30,"Donate 30 yuan",if(b2<=180,"Absenteeism for half a day","Absent from work for a day")))

Drag the formula down, and the attendance type appears in column C. Hope that helps.

Single day: CDZT (60 minutes for late arrival and early departure), kg=1day, jk=30rmb

Cell: if (cdzt>3 then kg,if(cdzt>,kg 2,jk)).

End of the month: if(counta(cdzt)>6, counta(cdzt)-6,"")

The above is the idea, you need to go to excel to set the cells and enter the corresponding formula.