Cleansing Data in Excel

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.

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.

• 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