From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Real-world challenge 1: Projects

Real-world challenge 1: Projects - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

Real-world challenge 1: Projects

“

Here is the Projects and Personnel challenge. Let's first look at the data before we get into what we have to do. Here on the projects tab, we have a list of projects and everybody who's on each team. On the Galaxy project, we have Jesse, Carlos and Frida and then on the team page, we have our full team in a long list, all the way down to Wolfgang in Row 44. Scroll back up. Now, let's look at what we have to do. List each project and the number of people on each project. So we just need to know, atmosphere project and then the count of people. Just a number. And then list every one by the number of projects that they are on, and then list them alphabetically. We want it to look like this. Notice that the numbers are descending. So we've got Amy on five projects and then Carl, James and Marnie are assigned to three projects, Ella on two projects. And the people who have a three, they are, in alphabetical order; Carl, James, Marnie, And then list everybody from the full team list who…

Contents