利用EXCEL进行工资核算和工资条的制作

The Excel Software is Used to Dispose the Work of Counting the Wages and Making Pay Slips

利用EXCEL电子表格软件来处理工资核算和工资条的制作,主要利用EXCEL的函数功能计算非原始型工资项目的计算,解决了不同单位不同标准下工资项的计算问题,极大地方便了财务部门的工资核算,在此基础上对工资表制作利用"分类汇总"和"筛选"功能制作了工资条,还可以直接按部门"筛选"发放工资.

In this article,the Excel software is used to dispose the work of counting wages and making pay slips.It mainly makes use of parameter function of Excel to calculate the unoriginal pay items.This method can solve the problems on accounting the wage items of all kinds of standards.It is convenient for Financial Sections to calculate the wages.In addition,this method of making pay slips,through utilizing the function of classifying,collecting and filtrating,can be also used to provide wages directly on the base of the section.