摘要
目的:利用数据透视表将工资表中当月新增、减少人员以及人员不增不减但金额和工作科室有变动的数据信息快速提取。方法:利用数据透视表寻找差异,通过增加辅助列标识(1、-1)解决人员工资中存在不同。结果:动态了解医院员工的流入和流出情况,以便掌握医院人力资源成本的变化情况。结论:数据透视表辅助功能可节约人力资源成本,方便快捷,提高工作效率和准确率。
Objective： To use pivot tables will pay the most valuable information in the table, add, reduce staff this month, and does not increase don＇t decreases but the amount of personnel data extract and work department is changed. Methods： Use pivot table to find differences, by adding auxiliary column identifier （1,-1） to solve the existing in the personnel salary is different. Results： Dynamic understanding of the inflows and outflows of hospital employees, in order to grasp the change situation of hospital human resource cost. Conclusion： It saves the human, fast and convenient, improves the work efficiency and accuracy.
出处
《中国医学装备》
2014年第11期70-72,共3页
China Medical Equipment
关键词
人力资源
管理系统
数据透视表
差异
Manpower resource
Management system
Pivot table
Difference
