You have a report of workshops, cities, and instructors, but there's a problem—you have inconsistent city names that have to be corrected.
- [Instructor] We held some workshops around the world…over 16 weeks and now it's time to do some analysis.…There's gonna be a problem because we've looked at the data…and we see NYC, but we also see New York…in certain places, like cell J3.…That's not gonna work and that's where your help is needed.…Please go in and replace every NYC with New York.…Pause the video, clean that up, come back…and I'll show you a solution.…
Let's get this cleaned up.…I'm gonna go to find, select and go replace.…Find what, NYC, replace with, New York.…Replace all, eight replacements.…Now we can pass this on for someone to do the analytics.…
AuthorOz du Soleil
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Beginner
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.