Hello, everyone, welcome to this lecture on Pivot Tables and Excel.
They were they were very strong tools, which are used to summarize large datasets.
They were automatically grouped together, similar wants to give out a meaningful summary.
To understand how, let us look at this data for Solid Wood Works Company in the first column, we have
salesperson name.
I have kept them as a salesperson one, two and three and so on.
Then, is the product sold in the next column contains region in which the sale was made next, his
customer name the date, then number of units bought by the customer, then 80 per unit cost, and the
next one is total payment made by the customer.
Now, let us say, we want to find out the sales made by each salesperson.
One way to do this is to apply filters one by one and some sales by each salesperson.
So we have applied a filter on tests for someone and the sample said is about two million, but doing
this will be very tempting and cumbersome.
Instead, let's do this using the word devil's.
So we go to the Internal Revenue on.
In the first exper.
Please ensure that the entire area selected.
Which itself is self-inflicted automatically for Arkes.
Next, if you want to pivot table in this chamber to select this option, I wanted in the new version,
so OK.
You can see that a new suit is added to the fine.
On the right is the pivot table menu, you notice that it has all the column names listed below this
list are for small boxes.
You can just drag and drop the desired column from above in the respective walks together, customer
support, if I drag drop salesperson in the rows, all the salesperson listed on the left.
Similarly, if I drag and drop the region name two columns, all four regions will be listed in columns.
We can apply filters by using the filter box.
But now let's try to get the summary of every sales person, it will drag and drop the sales person.
Indeed, horsebox.
Then we will bankrupt auto sales value and devalues what?
Notice that this is showing some of total cost.
In the ballot box, which means it has automatically added the sales value, whatever sales person or
sales person one also is supposed to do, and so on, next to identify which customer the salesperson
has sold, how much amount of furniture you will pick up customer name and will drop it into the columns
box.
We can see each person sell to each customer and the value of it, but if we want to see the count of
sales that its person has done, we will go to the value box.
Click on the settings.
And instead of some silicone.
You're going to see that salesperson one has made 17 sales to furniture.
And student Nicole overall.
As Bodycount salesperson has made 119 sales, which is the largest sales to arrange this data, that
is to sort this data from just the smallest, you go to the grand total column, right?
Click on any value and select third largest to smallest.
You can see that six percent is on top with the maximum number of sales and salesperson seven is at
the bottom with the least number of sales.
There's one more box left, which is defector's box.
If you want to apply some filter, say, for example, if I want to filter out some particular regions
from my data, I'll pick the regions box regions options and put in effect as what?
You can see that it has come on the top left corner.
If you click on this small triangle, you see all the four regions that are data has if you select NE
only and click on OK.
These four sales person have made these many sales in the northeast region, similarly, you can choose
not to not to say see this sales in north, west, northwest region.
But if you want to select multiple values in this filter economy, check box.
And then select multiple values that you want to say that.
So if we want northeast, northwestern, southeast, it does click on open and we will find all displaced
persons who have sold in these three regions.
No.
Instead of seeing this data from his personal point of view, if you want to see the amount of made
every month, we will remove salesperson from this table.
And will bring the date.
Column deros, blogs.
Can see.
We can see that the debt will grow automatically by itself in two years, quarters and debt.
If you want to change the grouping, you just go and click on it, go to the group option.
And you unsullied years and quarters.
Demands action, and you will now be able to see monthly sales for this furniture company.
Next, if you want to watch the Kardashians, why do these two companies it is home, space and hometown.
Probably these two companies are much together and we want to group these two sales values will select
these two and likely group.
And when we take this minus button, you'll see the combined sales to this group of two companies.
Next year, these laser options.
Slices are similar to figures.
Only these are more convenient to play.
So to apply it, we go to the analyst option in the menu and in that we go to the interpolated later
option.
Uncirculated is giving us the option to select the column name on which we want to apply this filter.
So, for example, if I want to apply for the region to region and click, OK.
So this laser, the four options which are favorable to her, if you click on NE.
We are seeing this in the northeast region only.
If you click on Notwist, you seeing this in the not particularly if I want to select multiple regions,
I'll click on this button.
And to the northeast and northwest both.
This gives us an easy way to play filters, that's all for this lecture in the next lecture.
We will cover charge.
Thanks.