Excel函数提升状态数据采集质量的方法探讨

Discussion on Methods of Using Excel Functions to Improve the Quality of State Data Collection

每年采集的数据需上传至教育部云数据中心,教育行政部门可以查阅院校的任何一个数据。而上传的数据在数据采集工作结束之后,不允许修改。2019年"双高计划"的实施,将数据采集工作推向了一个新的高度,数据的运用也越来越广,数据质量显得尤为重要。经过几年的实践,发现在数据审核过程中巧用IF、VLOOKUP、COUNTIF、COUNTIFS等函数可以提高工作效率,提升数据质量。

The data collected each year should be uploaded to the cloud data center of the Ministry of Education so that the educational administration department can consult any data of the institutions, while the uploaded data is not allowed to be modified after the completion of data collection. The implementation of the Double High-level Plan in 2019 has pushed the data collection work to a new height. The data is being used more and more widely, and the data quality is particularly important. Several years of practice proved that skillful use of IF, VLOOKUP, COUNTIF, COUNTIFS, and other functions can improve work efficiency and data quality.