How to Cleanse Raw Data in Excel 365

Date/Time: Wednesday, 12th May 2021 - 10:00 am - 10:45 am

Location: Online

Available Spaces: 20

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

Description

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.

[ultimatemember form_id="3621"]