课程: Excel: Power Query?(Get & Transform)

今天就学习课程吧！

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

Real-world challenge 2: Donors

Real-world challenge 2: Donors - Microsoft Excel教程

课程: Excel: Power Query?(Get & Transform)

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

Real-world challenge 2: Donors

“

Before we dive into this challenge, let's look at the data. We have a 2023 tab and a list of donors. Okay. Scroll down and check it out. All right. We see that we've got Sylvester three times. Okay. Keith twice. Okay. Let's look at 2024. Same columns. Okay. And notice we have Sylvester again. Now, let's look at the challenge. First, use the drill down feature to create a variable in cell B2. Second, list donors whose total donations are greater than or equal to the value in B2. That means if, say, somebody donated three times in 2023 and once in 2024, would the total donations add up to this $850 or above, and then change the value in B2 and refresh and make sure everything updates. And then list all of the donors who donated in both years, regardless of the number of donations or amount. All right. Time to pause the video and set you free to exercise your Power Query skill. First of all, let's do to drill down. Cursor is in that data, right-click, Get Data from Table/Range, table has…

内容