Exceljet

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 up 10 films on 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 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 in 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.

Course 
Core Pivot

Related shortcuts

CtrlSpace
Space
Author 
Dave Bruns