From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Choose preferred names

Choose preferred names - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Choose preferred names

“

- [Instructor] In this challenge, we have to create name tags in column F, or the names that people want. In row three, we've got Elvin Baxter, who wants to go by Skip. That is what should be in F3 is Skip. Rhonda, her name should be an F4, but we only want to create names for the people who are attending. So even though Casey wants to go by CJ, there's an N for attending, F6 should remain blank. Also, we need for this solution to be dynamic, so please change some of the data once you have your solution and make sure everything updates, and also add some new data to the bottom of the list. Got it? Good. Pause the video. Come on back. (upbeat music) Here we go. Because we want this data to be dynamic, the first thing that I want to do is put this data into a table. Cursor is in the data set, format as table. Let's grab, let's say this teal color. Table has headers. Okay, get rid of the filter buttons.…

Contents