Exceljet

Quick, clean, and to the point

This video comes from our online video training for Excel.

Pivot tables and movie data

Tags 
Summary 
A simple example of how you can use pivot tables to analyze all kinds of data, not just sales data. We look at the top 250 movies from IMDB from 2014.
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

Related shortcuts

CtrlSpace
Space
I think your website is great! It has helped me so much in learning to how to do things in Excel, please keep up the excellent work. -Stuart
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course