课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,100 门业界名师课程任您挑！

Attendance queries

Attendance queries - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Attendance queries

“

I don't see Andy as a quick eye scan but that's why we use Excel and not our eyes. And we see Buddy, Finn, Jack, are all inactive. Did any of them go to a meeting? Let me show you one thing. I'm in the Data tab. I'm going to go to queries and connections. I've given you a head start with two queries, the meetings query, and the member status query, okay? create those two queries, and then come on back. (upbeat music) Okay, you ready to do it? Let's do the second objective first. Did any inactive members attend any meetings? All right, so I am going to go to the member status query. Double click on it. Open the Power Query editor. Alright, now what I'm going to do is duplicate this Query, the member status, right click, duplicate. Now this, I want the inactive ones. So I'm on a filter out the active members. I'm going to call this my inactive query. Now I want to see if any of these are in the meetings query. Alright,…

内容