How to Cleanse Raw Data (FULL COURSE)

There are probably far too many scenarios to cover to be able to adequately demonstrate every possible data cleansing technique. However, during this video, we touch upon a number of useful approaches which should help you arrive at more readable and sensibly formatted data sets.

The topics:

Data cleaning using the CLEAN and TRIM functions
Text substitution using the SUBSTITUTE and REPLACE functions
Using the Flash Fill feature
Extracting text using the SEARCH, LEFT and MID functions
Techniques to remove duplicates
Using the Text to Columns command to clean your data
Converting dates from an American format
Reformatting data which has become offset