Clean data checklist
Data can be text, numbers, dates, and so on. Just entering or importing the data into Excel (or any other spreadsheet) is not enough. The data must be CLEAN. Unfortunately, hitherto, there has not been any simple definition of what clean means. Here is a simple 11-item checklist.
If your data passes each item, then it is clean. Here is the checklist:
It is important to understand this concept. Watch this video to see examples of each item. The video shows each rule with sample data and explains why it is important to follow the rule. It shows the wrong format first. It explains why it is wrong and then shows the correct format.
You should compare these examples with your own data and learn how to apply these rules.
How to use this checklist
Look at your data – each column as well as overall. Check which items are not right and then clean them up or repair...
