I used to teach OpenRefine as a part of Data Carpentry workshops, and more than once, I heard people say it changed their lives.

This is that lesson for getting started with OpenRefine. http://datacarpentry.org/OpenRefine-ecology-lesson/