From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Identify at least five problems with this data

Identify at least five problems with this data - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Identify at least five problems with this data

“

- [Instructor] This data is a mess and when we learn how to control this kind of stuff, we are really working with Excel. So check this out. We know that we don't have 19 people. There are some extra records in here. Let's take a look. We look at Odeda Mays Koller. Odeda Koller. Rows two and nine. Same birthday but then the city is called Devlin and it's called Devlin Park. We go down and look. Terri Benton. T Benton. Probably the same person. Our job is to identify the possible duplicates. It's up to you if you want to make a new column, flag in the possible duplicates. Maybe you want to use conditional formatting. But just identify the possible duplicates. Right? Pause the video. Work it out. Come back and I'll show you a way through this. Alright now. You ready to get into this? This is beautiful. What we're going to do is create a unique ID. I'm going to just call it UID. I want to put this…

Contents