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 and move attendee data

Identify and move attendee data - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Identify and move attendee data

“

- [Instructor] Now this is serious. You and I held an event and we have contact information about the attendees. And we asked them do they wanna be on the newsletter. We would like a list of the people who do want to be on the newsletter and we don't wanna irritate people who don't wanna be on our newsletter. And here's where you come in. Add a new worksheet and color that sheets tab red. Name that tab No Contact. Make the column headers Attendee, Email, Add to Newsletter. And then remove the people from this sheet and move them to the other sheet, those who don't want our newsletter and didn't include an email address. So go ahead, pause the video, get the list segmented, come back and I'll walk you through a solution. Now we gonna add a new worksheet and color its tab red. Go down, hit this plus sign. I'm gonna right click, tab color, and just pick a red, whatever's your favorite. And I'm gonna pick this first one.…

Contents