| 利用EXCEL进行工资核算和工资条的制作 |
| |
| 引用本文： | 白额尔敦.利用EXCEL进行工资核算和工资条的制作[J].内蒙古民族大学学报(自然科学版),2005,20(2):152-154. |
| |
| 作者姓名： | 白额尔敦 |
| |
| 作者单位： | 内蒙古民族大学,职业技术学院,内蒙古,通辽,028043 |
| |
| 摘 要： | 利用EXCEL电子表格软件来处理工资核算和工资条的制作，主要利用EXCEL的函数功能计算非原始型工资项目的计算，解决了不同单位不同标准下工资项的计算问题，极大地方便了财务部门的工资核算。在此基础上对工资表制作利用“分类汇总”和“筛选”功能制作了工资条，还可以直接按部门“筛选”发放工资．
|
| 关 键 词： | 工资核算 原始项 筛选 分类汇总 单元公式 |
| 文章编号： | 1671-0185(2005)02-0152-03 |
| 修稿时间： | 2005年1月10日 |
The Excel Software is Used to Dispose the Work of Counting the Wages and Making Pay Slips |
| |
| BAI Eerdun.The Excel Software is Used to Dispose the Work of Counting the Wages and Making Pay Slips[J].Journal of Inner Mongolia University for the Nationalities(Natural Sciences),2005,20(2):152-154. |
| |
| Authors: | BAI Eerdun |
| |
| Abstract: | 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. |
| |
| Keywords: | Work of counting the wages Primitive items Collecting Filtrating Unit formula |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
