利用Excel的控件和函数批量制作学生成绩报告单

Using Existed EXCEL Resource to Make Student Mark Sheet

Excel是办公常用软件，利用Excel可以制作各种格式的表格，提高办公效率，本文介绍了如何利用Excel软件中自带的控件和函数，以及各个教学单位已有的学生的成绩电子数据，制作可以自动生成的成绩报告单．减少因手工填写而带来的麻烦和错误。

Excel is a commonly used office software,by using Excel ,we can make various of forms to improve ofrice efficiency . In the article, it introduces how to use Controls and Function in the Excel software, and electronic datas of student mark sheets, which have been had in every teaching units, to make mark sheets that can be produced automatic, in order to reduce troubles and errors caused by handwriting.