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


For the best possible viewing experience, we recommend ‘High Definition’ mode. This can be achieved by starting the video, clicking on Settings (the ‘cog’ symbol found in the bottom right hand corner of the video) and then changing the Quality to ‘1080p HD’. If not available then select the highest value.

Subtitles can be switched on by starting the video and then clicking on Subtitles/closed captions (c) (found in the bottom right hand corner of the video).

Related Articles


Your email address will not be published.