From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Assign the team leads

Assign the team leads - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Assign the team leads

“

- [Instructor] Here we go with this situation. You ask for volunteers and nobody wants to do it. So now we've got these 15 teams, and your task is to assign a team lead for each of these teams. For team one, will it be Garson, Nalani, Lorna, Anissa, or Smokey? For team eight, will it be Enrique or Tessa? You have to make that list and use a formula. Do not type names. And when you're done, get rid of any underlying formulas. All right, pause the video, make the assignments, come on back, and I will make a list. (light upbeat music) Okay, let's make some assignments, and now, let me say up front, your list is going to look different from mine because we are talking about random assignments. All right, let me move this box out of the way and then I'm going to put this data into a table. Format as Table. Let's grab this blue. Okay, get rid of these filter buttons. Okay, I'm going to call this IDX for index.…

Contents