Excel – How to Cleanse Raw Data

When

November 21, 2023
10:00 am - 10:45 am
17 spaces left

Where

Online

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.

Either the booking cut off time has passed, or you are unable to book a place on this event due to security restrictions, please contact NECSU.learning@nhs.net if you believe this to be incorrect.