From the course: Excel: Advanced Formulas and Functions
Join today to access over 23,200 courses taught by industry experts.
Challenge 1: Course completions
From the course: Excel: Advanced Formulas and Functions
Challenge 1: Course completions
- Welcome to your first challenge. Haha. This one is going to cause you to think and put in some real effort. So here is data about reps and courses that they took. And they had to do it in a minimum of 30 days or a maximum of 120 days. So the goal is to assign a thumbs up, a broken heart, or a lightning bolt, based on how long it took them to complete these courses. Now look at the data. Seth took course one in June, ah, but took course two in April. So he took course two first. Course three was taken in August, so they were out of order, but still that doesn't matter. Whatever the time span was, it could not be shorter than 30 days or more than 120 days. And you have to assign the right icons, all right? Time to pause the video, get all of that sorted and calculated, then come on back and hopefully you and I will have the same results. - (upbeat techno music) - Okay, let's do it. Alright, so slide this side…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.