Excel: How to Cleanse Raw Data

Raw data often requires cleansing to make it meaningful, useful and usable.  This course is for those requiring an understanding of the techniques available to cleanse data.  The usage of the functions: CLEAN, TRIM, SUBSTITUTE, SEARCH, REPLACE, LEFT and MID is also demonstrated. The topics are:

  • Data cleaning functions
  • Text substitution functions
  • Using Flash Fill
  • Finding the correct text
  • De-duplication techniques
  • Using Text to Columns to clean data
  • Working with American formatted dates
  • Reformatting offset headings
Not Enrolled
This course is currently closed

Course Includes

  • 9 Lessons
  • Course Certificate