From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Solution: Apply what you've learned in Excel

Solution: Apply what you've learned in Excel - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Solution: Apply what you've learned in Excel

“

(upbeat music) - {instructor] Let's get straight into it because this is what's standing between you and the completion. So I'm not going to horse around. We want to know how many times we played each city. I'm going to leave my cursor right here, =TOCOL, double-click right here. There we go. Comma, ignore blanks, yes, and comma, scan by column, yes. Boom. Whoa, look at that. Okay, we got it. Here we go. Got to split some columns. All right, I'm going to do this trick. Slide, slide, Copy Here as Values Only. Get rid of the formula underneath. I'm going to do this, Lisbon, Denver. Huh, look at that. Flash Fill hooking me up. And I need some space here because watch what I'm going to do now. I'm going to slide this over, and then I'm going to do this, Cities, and bold it, and Insert, PivotTable. Yeah, I'll put it on a new worksheet. And I've got Cities and Cities in Values. Look at that. And then I'm going to go to Data and sort this Descending. We played Mexico City four times. We…

Contents