From the course: Excel: Advanced Formulas and Functions
Join today to access over 25,300 courses taught by industry experts.
Challenge 2: Guitars - Microsoft Excel Tutorial
From the course: Excel: Advanced Formulas and Functions
Challenge 2: Guitars
(upbeat music) - [Instructor] In this challenge, we want to dig into Aimee's guitar collection. She plays guitar, she collects guitars. In this dataset, we see transaction dates, guitars, the action, and the amount. The challenge is to find out, does Aimee still own Guitars F, L, M, or A? And if she never owned any of these, then return N.O. In the dataset, we see that's a bit jumbled, but Guitar M was purchased in May of '99 for $710, and the next action on Guitar M was June of 2020, where Aimee sold it for $800, and then December '22, she bought it back for $800. So it looks like Aimee does own Guitar M right now. But rather than eyeballing it, the challenge is use Excel to figure this out for us. (upbeat music) Welcome back, and let's see if your result matches my result. I'm going to slide this out of the way. I'm going to put this dataset into a table, format it as a table. Let's grab this blue. Look at this,…
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.