From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Challenge 2: Donations

Challenge 2: Donations - Microsoft Excel Tutorial

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 nonprofit's 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 and median. And get a count 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, time to pause the video, get that data, and come on back. (upbeat contemporary 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, =sum open…

Contents