| EXCEL在工资查询系统中的运用 |
| |
| 引用本文： | 许国.EXCEL在工资查询系统中的运用[J].办公自动化,2012(16):46-47. |
| |
| 作者姓名： | 许国 |
| |
| 作者单位： | 诸暨市教育局会计核算中心 |
| |
| 摘 要： | EXCEL电子表格作为常用的数据处理的数据处理功能是非常强大的,给我们的日常工作带来了方便,但在数据查询方面EXCEL就显得力不从心了。如我们查询一个人的工资发放明细时,只能打开所有人员的工资明细,而不能屏蔽其他人员的工资明细,在实践中,我们运用EXCEL的VBA功能实现了指定人员工资明细的随有查询,提高了工作效率和工作质量。
|
| 关 键 词： | EXCEL 宏 工资查询系统 |
Application of Excel in Wage Query System |
| |
| Xu Guo.Application of Excel in Wage Query System[J].Office Automation,2012(16):46-47. |
| |
| Authors: | Xu Guo |
| |
| Affiliation: | Xu Guo(Accounting Center,Zhuji Municipal Bureau of Education Zhuji 311800) |
| |
| Abstract: | EXCEL electronic form as commonly used data processing data processing function is very powerful,for our daily work has brought convenience,but in the aspect of data querying,EXCEL appeared to be inadequate.If we query a person’s salary details,can open all the staff salary details,but cannot shield the other personnel salary details,in practice,we use the EXCEL VBA function to achieve a specified personnel salary details with a query,improve the work efficiency and the work quality. |
| |
| Keywords: | Excel Macro Wage query system |
| 本文献已被 CNKI 等数据库收录！ |
|
