运用Excel函数编排高校校园运动会秩序册

Compilation of a college campus sports games order brochure by using Excel functions

运用Excel函数编排高校校园运动会秩序册,大大提高了准确率和效率。在一个Excle工作簿中,充分运用Excel函数组合来分类、传递和汇总报名数据,建立工作簿中各工作表之间的联系,实现自动生成运动员号码、运动员名单与号码对照表以及各类比赛项目的运动员分组、分道次表的目的。

Starting with working out a scientific sports games registration form, in an Excel workbook, the author fully utilized Excel function combinations to classify, transfer and summarize registration data, to establish connections between various worksheets in the workbook, and to realize the purpose of automatically generating athlete numbers, athlete lists, number correspondence forms, and the forms of heat and lane assignment for athletes who compete in various sports competition events. As for small sports events such as college campus sports games, such Excel function combinations greatly improve the accuracy and efficiency of compilation of such a sports games order brochure.