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