基于Excel的年度工资生成解决方案

The Solution of Building Annual Wages Based on Excel

Excel作为交互性非常强的电子表格软件,简单易用,为我们平时的数据处理带来了极大的方便。然而,Excel中的公式与函数并不能解决所有存在的问题。此时,常常需要使用VBA或VB加以辅助之。此年度工资生成解决方案采用二维数组指定某个月的数据、双重循环进行数据比对和使用VB直接操纵Excel等手段加以解决问题,在惠州旅游学校生成年度工资中实践通过,省时省力,获得了良好的效果。

As a powerful interactive spreadsheet software, Excel is very strong, easy to use, and bring great convenience for our usually data processing. However, Excel’s formulas and functions can not solve all the problems. At this point, we often need to be supplemented by the use of VBA or VB. In the financial office of Huizhou tourism school, this solution of annual wage based on Excel uses some ways to solve problems, e.g., a two-dimensional array to point out the data of a month, a dual loop to compare data and using VB to manipulate Excel’s data. It generates less time, has a good effect in the processing of annual wages.