课程: Excel: Power Query?(Get & Transform)
今天就学习课程吧!
今天就开通帐号,24,100 门业界名师课程任您挑!
Real-world challenge 3: Soccer team - Microsoft Excel教程
课程: Excel: Power Query?(Get & Transform)
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…
随堂练习,边学边练
下载课堂讲义。学练结合,紧跟进度,轻松巩固知识。