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 3: Soccer team

Real-world challenge 3: Soccer team - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Real-world challenge 3: Soccer team

“

I am coming to you from HR because I need your help. We had a problem. We had this employee over here. Look at this. Scary, intimidating. Was going around the workplace asking people to donate to their kids soccer team. They need jerseys and they go on trips out of town to different competitions. They need money. But you know those people that they can ask you a question, but you know that they're telling you what to do. Now, we can't have that. And we have sent this person off to have some pleasant personality improvement workshops. All right. But here's where your help is needed. Here is a list of our employees. Here, we were able to get a list of the donations that this intimidating person collected. We need two separate queries. Our people who donated less than $300, because we can go ahead and refund them. And then we need to know greater than or equal to $300 because they have to go through some approval, but they'll get their money back. Now, let's look at the data. Jeff…

Contents