From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

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

Challenge: Building a tracker 2

Challenge: Building a tracker 2 - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Challenge: Building a tracker 2

“

(soothing music) - [Instructor] Right, now this is going to be a nice challenge for you, there's a lot here, but don't be intimidated. You've gotten this far, you can get this. Now let's look at the data. Here, we're on the overview sheet. Some friends are planning to go on a skydiving adventure and we know that the minimum number of participants is 14. We've got boxes for a participant count, regular count, VIP count, and a total due. Then, over on this sheet, we see a regular experience is $290, VIP experience, $500. We've got the list of friends over here, right? And I've written formulas in here such that when a person crosses a certain threshold, they will get this skydiving emoji. Over here we have payments, and we see Magda paid the full $500 in one payment. Bluto paid the entire $290 in one payment. Some of the others made multiple payments. So let's go back to the list of objectives. First of all, name the table…

Contents