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.

Presentations part 2: What day is each person presenting?

Presentations part 2: What day is each person presenting? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Presentations part 2: What day is each person presenting?

“

- [Instructor] All right, now. We got to write a formula, and we've got to link sheets. Are you ready for this? Here we have our presenters. This is a group that's presenting on Wednesday, these people on Thursday. All right. This overview sheet has everybody and this is what we need from this list. Add a day column and then write a formula that will tell us which day a person is presenting on. Nada Bowen, which day? We would like to be able to look at this and say oh, Nada Bowen, okay. I want to see her presentation. I'm going to show up, when? I don't know. And I don't want to go look at those other tabs, all right? So help us out. Pause the video, write the dynamic formula that will give us this answer, come back, and we'll do it together. All right now, let's do it. Here, we've got to write the day column. Day, all right. Let's make that bold, and then put this into a table, all right. Let's…

Contents