Excel – How to Cleanse Raw Data

Date/Time: Thursday, 29th September 2022 - 11:00 - 11:45
Location: Online
Available Spaces: 19
Contact Details: Paul Atwell: paul.atwell1@nhs.net

Description

Raw data often requires cleansing to make it meaningful, useful and usable.  This 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.

Prerequisites
A good to advanced working knowledge of Excel functions.

Course outline

  • 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

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.


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.