Excel作为现今办公普及的Office套装软件之一,其内置的函数“OFFSET”、“VLOOKUP”以及“名称”和标准宏语言VBA使其办公自动化水平得到了极大的扩充.通过对Excel中的函数“OFFSET”和“名称”的应用以及矩形框与单元格数据的关联可以实现批量准考证的制作,实现了办公自动化.该方法操作简单,自动化程度高,工作效率高.%Excel is one of the currently popular Office package software, whose built-in function "OFFSET" , "VLOOKUP", and "name" together with standard macro language VBA make the level of its office automation extend largely. Batch ticket production can be realized through the application of Excels function of "OFFSET" and "name" and the correlation of rectangular frame and cell data, which confirms that the office automation is realized. The method is simple, high automation, and high operating efficiency.
展开▼