Cleansing data in Excel can be laborious and take a lot of time, but some people/organizations have limited options. In this course, Cleansing Data in Excel, you’ll learn to cleanse data effectively and efficiently in Excel. First, you’ll explore the different types of dirty data. Next, you’ll discover tips on how to keep your data accurate, which can be particularly difficult if you have multiple people working in files. Finally, you’ll learn how to clean the data in Excel to ensure you are as accurate as possible. When you’re finished with this course, you’ll have the skills and knowledge of data cleansing needed to work efficiently, reduce errors, and minimize time cleansing data.
Author Name: Susan Walsh
Author Description:
With a decade of experience fixing your dirty data, Susan Walsh is the Classification Guru. Susan is Founder and MD of The Classification Guru Ltd, a specialist data classification, taxonomy customisation and data cleansing consultancy. She is an industry thought leader, TEDx speaker and author of ‘Between the Spreadsheets: Classifying and Fixing Dirty Data’. She’s also the founder of COAT.

Table of Contents

• Course Overview
  1min
• Why Data Needs to Be Cleansed
  11mins
• Data Cleaning Best Practice
  7mins
• Cleaning Names in Excel
  33mins
• Cleaning Addresses in Excel
  52mins