Pivot tables - take it easy

Problem

I have data and I need to get some useful information from them. In this case I want (using pivot table) to know, how many Fords is in the list and how much are they together.

Solution

We will work with this table:
Table to download

I will start by clicking anywhere into the table - it is not necessary to point out any part of the table. Then I will click on "Insert" and "Pivot Table".

In this dialog I don´t have to change anything, I just click on "OK". 

I have created new sheet with the pivot table by doing this.

Notice the right column wit menu - above are in rows names of the columns. As they will be moved into the table, the pivot table will be modified. 

I wanted to know, how many Fords is in the list and how much are they together. I will do it so as I will get a table with sums of prices for all producers - Ford including.

"Ford" is on of the producers. That means I will drag "Producer" from the right rectangle to the rectangle "Drop Row Fields Here" in the table.

Now there is the list of producers in the rectangle, where I dragged it.

Now I need to know, how much cars of these producers are. I will drag "Price" into "Drop Data Items Here".

Now I see, how much are the cars separated by producers.

Now I can see, how many of cars is in the list - separated by producer.

I will double click on "Sum of Price" and in menu I will change "Sum" to "Count".

And that is all.

And here is the video containing this tutorial. 

Are there any questions? Write them below.