From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Override names

Override names - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Override names

“

- [Instructor] We're about to have a super fun event, and we need to print out name labels. And typically, we would print a person's first name, but for a few people like Cristian Doss, Cristian prefers to go by Skip, so that is what needs to be printed on Cristian, or Skip's, label. That's where your help is needed. In the Name to Print column, fill that out with the first name, or if the person have a preferred name, print that, and then make them all all-caps. You ready to get these labels going? All right. Pause the video, work it out, come back, and I'll show you a solution. All right, let's have some fun here. All right, I'm going to click in the data set, and I'm going to put this into a table. Home. Format as Table. Let's go with this nice purple, okay. Get rid of those filter buttons. Here we go. Equals if, open parentheses, this does not equal empty, then print this. Otherwise, print the first…

Contents