Excel – How to Cleanse Raw Data

Date/Time: Thursday, 11th November 2021 - 11:00 am - 11:45 am

Location: Online

Available Spaces: 20

Contact Details: Paul Atwell: paul.atwell1@nhs.net

Description

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 course also demonstrates the usage of the functions: CLEAN, TRIM, SUBSTITUTE, SEARCH, REPLACE, LEFT and MID.

This course is ideally suited to those who already have a good working knowledge of Excel.

Session contents:

  • 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

This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.


You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.