We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all 10 items are correct, data is clean. Simple and easy to use.
10 rules for Clean data
Remember, here we are talking about input data – not output (reports).
Although Word is most commonly used for creating documents, it can also be used for capturing data like a form. Word Forms do not require any programming knowledge. These are easy to create and will work across ALL versions of Word.
The Need for Word Forms
This is very useful for conducting quick surveys or quizzes where you want to control the responses. Of course, there are more sophisticated methods and tools available for bother these scenarios, Word is familiar to everyone and almost guaranteed to be available on every desktop. Hence it is a compelling option even today (2017).
The more I work with customers, the more I realize that data quality is still a very big problem. Data Validation in Excel is an effective solution to this problem. Here is a short guide for you. Reading time 12 min.