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.
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.
Table of contents
- Why Names Need to Be Cleaned 3m
- Formatting of Names 1m
- Introduction to Cleaning Names 1m
- Preparing Names for Text to Column 2m
- Splitting Names Using Text to Column 2m
- Cleaning Names Part 1 6m
- Cleaning Names Part 2 8m
- Cleaning Names Part 3 2m
- Cleaning Names Part 4 3m
- Merging Names Back with a Vlookup 5m
- Summary 1m
- Why Addresses Need to Be Cleaned 1m
- Formatting of Addresses 2m
- Preparing Addresses for Text to Columns 4m
- Splitting Addresses Using Text to Columns 4m
- Cleaning Addresses Part 1 7m
- Cleaning Addresses Part 2 4m
- Cleaning Addresses Part 3 6m
- Cleaning Addresses Part 4 3m
- Merge Addresses Back with Vlookup 5m
- Address Clean Post Vlookup 2m
- Checking City and County Using a Pivot Table 7m
- Checking Address Data Using a Pivot Table 6m
- Summary 1m
- Overall Summary 1m
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.