Simple play icon Course
Skills Expanded

Cleansing Data in Excel

by Susan Walsh

This course will teach you how to recognize dirty data, minimize its occurrence, and cleanse your data in Excel, working more efficiently, reducing errors, and minimizing cleansing time.

What you'll learn

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.

About the author

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.

Ready to upskill? Get started