Refine your data

If you use Filters in Excel then this tip is for you.

Although Excel is a powerful tool to sort and filter data, OpenRefine can help you explore large data sets with ease.  It is an amazing tool to clean up messy data and get exactly what you need. For instance, if you have a huge list of records with City. It’s possible that there may be people who entered Mumbai or Bombay which should be considered the same.