快速校验Excel数据的两种方法

在日常工作中,我们经常要使用Excel录入大量的数据,如客户信息、学生成绩等。由于信息量大,在录入过程中,我们不可避免的会出现一些错误。如何快速、有效的检查、校验录入的信息是值得研究的。这里文章介绍两种轻松、高效的数据校验方法——公式审核法和语音校验法。

Two Ways of Checking Excel Data

In daily works,we often want to use Excel to do a lot of data entry,such as customer information,the grade of students. because Informative,in the entry process,we will inevitably be some errors. How fast and effective inspection,checking the information input is worth studying. This article describes two easy and efficient data validation methods-formula for checking a parity and voice.