February 2024
Intermediate
3h 20m
English
on-demand course
Cleaning Data in Excel: Fixing Names, Addresses, Emails, and Phone Numbers
with Susan Walsh
Closed Captioning available in German, English, Spanish, French, Japanese, Korean, Portuguese (Portugal, Brazil), Chinese (Simplified), Chinese (Traditional)
Overview
Dirty data is everywhere. Have you had a letter addressed to you with your name misspelled? That’s dirty data. Do you have trouble finding a product on a website because it’s not in the right category? That’s dirty data. Do you have trouble finding a person or company name in your system because of a typo? That’s dirty data.
And it causes problems, lots of problems. Before software implementation, machine learning and AI, you need clean data. It’s THE most important thing to fix before doing any of these things, and we’re all expected to be able to clean or fix this data, yet no one tells us how to do it!
Some of the most common data problems occur in name, address, email and phone number data, and this course will cover this off. While there are many data-cleaning tools out there, almost everyone uses Excel, including non-data professionals, and it’s important to have the skills to be familiar with and be able to get to know your data before you use these tools.
It’s essential to be able to spot and fix errors in Excel first, and understand when the data isn’t right so you know if you can trust those fancy tools or not! This course will help you achieve this and you’ll learn:
- What is dirty data?
- The importance of data quality
- Tips for cleaning data in Excel
- How to clean names, addresses, emails and phone numbers in Excel
You’ll even get your own dirty data set to work on!
This course is for you because…- You have data quality issues in your organization and would like your team to understand the importance of data quality and how to improve it.
- You're a data professional spending a significant amount of time cleaning data and would like to work more efficiently.
- You're not a data professional, but work with data and want to work more efficiently with it.
Prerequisites:
- Some experience of Excel would be beneficial
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.