From the course: Excel: Managing and Analyzing Data
Join today to access over 24,400 courses taught by industry experts.
Challenge: Splitting columns in Excel - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Challenge: Splitting columns in Excel
(upbeat music) - And here is the splitting columns challenge. We've got three things, actually a fourth. Let's get some balloons going because this data set has awardees, RSVP statuses and their guests. One thing we want, a single list of the guests. We want Fatima, Leslie Carr, Joy, Armine, Septimus, Gordon, all of the guests. We don't want the awardees. Maybe we're trying to print up the name tags. Also, we want to extract the RSVP statuses for each awardee and then identify any problems with the data quality. Is there anybody who says that they're not coming, but they have guests listed? That's something to look into. Now, it's your turn. Open up that workbook and work those out.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
