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.

Add new participants to teams

Add new participants to teams - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Add new participants to teams

“

- [Instructor] You and I run a music school and it's time for the annual assessment. We've got a mix of students and staff who will do the assessments, and they're divided into groups. Now here's the situation, we've got two new participants and an entire new group. And here's where your help is needed, add Helena to Sylvester's group. Add Brandon to Levi's group, and move Irina's group to the correct format and after Connie's group. After all the work, ensure that there are two blank rows between each group. So go ahead, pause the video, get this sorted out, come back, and I'll take you through a solution. Okay, you're back, so let's dive in. We have to add Helena to Sylvester's group. I'm gonna highlight Helena's name, drag her name down, she's going to Sylvester's group. Brandon to Levi's group. And we have to add one blank row after Brandon's name. So I'm gonna highlight this row, right click, insert. So we've got…

Contents