From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

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

Challenge 2: Donations

Challenge 2: Donations

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 2: Donations

“

(upbeat music) - [Instructor] Time to do a little analysis on our nonprofits data. We've got the donations and the months from the previous year. The donations are separated online and not online. Like maybe somebody gave you $20 out of their pocket or they mailed a check in to the nonprofit. So the goal, the challenge, calculate the overall total. That's what we want here. Calculate the overall total. Overall average and overall median. And then do the same, but only for the online data, the total average in median. And get account of the values that are greater than or equal to $5,000. And then get the total of the values that are over $5,000. All right, you got that? So, go ahead and time to pause the video, get that data and come on back. (upbeat music) All right, let's get to it. Where do we want to put this total? Let's put the total right there and then slide this out of the way. Equals sum, open…

Contents