From the course: Excel: Managing and Analyzing Data
Join today to access over 24,400 courses taught by industry experts.
Challenge: Apply what you've learned in Excel - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Challenge: Apply what you've learned in Excel
(funky music) - [Instructor] Now it's time for the finale, the big trick. But this is practice. This is not in front of a live crowd, okay? So if you get dropped from the trapeze and land in the net, that's fine, but out in real life, in front of a real audience, if you fall into the net, that's when you scare a lot of little kids. That's not entertaining. So here in the safe confines, here is the final monster challenge. And we have three. First, in this data set, we see we played, in January, Lisbon on a Friday. We played Mexico City on a Friday and a Thursday. And you see, February, March, April. We want to know how many times did we play each city. How many times did we play Denver? How many times did we play Lima, Peru? Et cetera. And we do not care about the months or the weekdays. Next, take this data, where we can see this data is divided up, January 1st through 15th, and then the second half of January, here is our merchandise sales, Vienna $647 in posters. The goal, reshape…
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.
