1003 Pivot Table - How to Create One?

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.22
You save:  A$55.78
List Price:  ৳11,874.82
You save:  ৳3,393.05
List Price:  CA$185.28
You save:  CA$52.94
CHF 91.10
List Price:  CHF 127.54
You save:  CHF 36.44
List Price:  kr884.03
You save:  kr252.59
List Price:  €118.72
You save:  €33.92
List Price:  £107.32
You save:  £30.66
List Price:  HK$1,085.03
You save:  HK$310.03
List Price:  ₹10,472.62
You save:  ₹2,992.39
List Price:  RM587.04
You save:  RM167.74
List Price:  ₦53,336.19
You save:  ₦15,240
List Price:  kr1,250.97
You save:  kr357.44
List Price:  NZ$212.50
You save:  NZ$60.71
List Price:  ₱6,854.21
You save:  ₱1,958.48
List Price:  ₨23,539.31
You save:  ₨6,726
List Price:  S$192
You save:  S$54.86
List Price:  ฿4,349.48
You save:  ฿1,242.80
List Price:  ₺1,020.31
You save:  ₺291.53
List Price:  R2,440.10
You save:  R697.22
Already have an account? Log In


Hi there. After looking at some of the introductory session on pivot table, I'm sure that you are rolling to find out how this pivot table reports are being made. And what is the logic behind every click that we eventually be doing. So I don't want you to learn in an ad hoc manner. So what I will do is, for every one particular click and feature, I will tell you the background logic behind it. And I'll start with the simple data.

Once we cover all these tips and tricks, we will then graduate to a data which may span over 60,000 lines and with multiple columns. At this moment, we have data, which is roughly 400 line items. What is it? It's a database of employees of a hypothetical company, the date of joining given salary in terms of number division that they're working with, and reading one is good, five is bad, each also given. Now from this columnar data where the headings are all filled with some text, it's not a blank anymore. I am going to prepare a pivot table feature to do so is that you will have to choose the entire block of data.

So we take the help of the best practices, I pick up the oj, that's the first cell shift control right shift control down. Once I choose the data, I just want to check whether there are any more for the lines below this data. So I press Shift control down again, there isn't any more data so shift control up. Now remember one of the shortcut keys from our earlier video session, which allows you to go to the header of the data without losing the selection. Yes, Ctrl backspace key. So all the ctrl backspace key is not necessary, but this just allows you to look at the headers while you are working with the data.

The point is, you got to choose the data display. Now, once having done so, we will go to the Insert tab which is present on top left corner of the screen. Once I go to Insert Tab, let me click on pivot table. Once I click on it, the generic box that comes before my screen, it says is the data that you have chosen full and final? I say yes And it also asks you Where would you want to present this pivot table report add in a new worksheet or in the current worksheet, or any specified location which you have in mind. At this moment, I'm happy if Excel says it's a new worksheet that in which pivot table is going to be generated into that Let me press OK. And what you get a new sheet generated, and that has the grid of pivot table.

So this is step one. After having covered the prerequisites of the data requirement, we went ahead and created a pivot table template, and in the next few sessions, I'll show you how do you modify certain settings so as to have more flexibility while creating pivot tables.

Sign Up