Quick, clean, and to the point

Pivot Table Example - IMDB Movie data

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.


Related shortcuts

Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.