摘要
针对住房货币化分配中大量重复性的数据处理工作,提出了利用Excel的函数、复制、粘贴链接等功能的解决方案,实践证明:利用Excel可以准确、高效地完成住房补贴额的计算、汇总和制表等工作,并且补贴金额一览表中的原始数据发生了改变。
Aiming at a great amount and repetition of data processing work in housing monetization distribution,this paper presents the solutions to use function,reproduction,paste link,etc, of Excel. The result shows that Excel can be used to calculate, gather and tabulate housing allowance correctly and high efficiently and the original data in allowance form will be changed.
出处
《电脑开发与应用》
2005年第9期48-49,共2页
Computer Development & Applications
关键词
货币化分配
住房补贴
数据处理
EXCEL
制表
monetization distribution, housing allowance, data processing, Excel, tabulation
