Exceljet

Quick, clean, and to the point

This video comes from our online video training for Excel.

Pivot tables and movie data

Tags 
Video Transcript 

OK so in this example, we have 250 films. These are the top 250 films from the IMDB website for the year 2014. You can see that we've got Rank, Title, Director, Rating, Genre, and Runtime. So, let's use a pivot table to answer some questions about this data.

My first question is:

What are the the top 10 films by rating?

So there are the top 10 films in that list, by rating. And the next question is more difficult, it's:

How do these films compare in terms of runtime?

How many films are one hour, one and a half hours, and so on.

OK, so here's a breakdown of films by runtime. You can see that we have 28 films that are between an hour and an hour and a half. And 178 films that are between an hour and a half and two hours, and so on.

OK the next question is:

What's a breakdown of all these films by Genre?

So, here's a breakdown of films by Genre, and you can see that clearly Comedy, Action, and Drama are by far the top categories for these films.

And finally for the last question, you can see that there are 13 films that are classified in the Biography genre and the question is:

What are those 13 films...can we get a list?

And, using the drill down feature in pivot tables, we can do just that.

 

Author 
Dave Bruns
This is fantastic. I am working on a report and this is exactly what I needed. Thanks. -Diane
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course