The Excel workbook is included with our video training.

Abstract

In this video, we look at how to use a pivot table to analyze movie data by rating, runtime, genre, and more.

Transcript

Okay, so in this example we have 250 films...these are the top 250 films from the IMDB website for the year 2014.

And you can see we got Rank, Title, Director, Rating, Genre, and Runtime.

So let's use a Pivot table to answer some questions about this data, and my first question is:

What are the top 10 films by rating?

Okay, 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?

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

Okay, the next question is:

What's a breakdown about these films by genre?

OK so here's a breakdown 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 there are 13 films that are classified in the biography genre, and the question is:

What are those thirteen films?

Can we get a list?

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

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.