From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Can this data be useful?

Can this data be useful? - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Can this data be useful?

“

- [Instructor] Let's look at more of the murkiness of the real world. We've got this data that is a sample of our main data source of 500 records. We've got a column of names, column of addresses. Let's look at it. In row four, we don't have a name, but we do have an address. We look at Jerome Burke and there is no address. Maybe they match up, but we don't know. But let's look further. There is Franks comma Lance, and an address on Worthen Drive. Then Lance Franks on Worthen Drive and Lance Franks on Diamond Cove. And another Lance Franks in row 11 on Worthen Drive. Scroll down, Stephanie Daniels, DDS and no address, Stephanie Q. Daniels on G. Street. Then we've got Tasha Dyson and Tosha Dyson. Two different spellings. Same address on Ballard Road. Now we have three addresses on Perry Street for Daryl, no last name, Jonas Carey and Lucrece Stenquist. And Lucrece Stenquist has no unit number or apartment number like the other two on Perry Street at that address. Then we've got Theresa…

Contents