If you need to analyze and summarize data based on different parameters we wait tables are going to
be your favorite tool.
So to apply pivot tables what you need to do is to actually need to simply click on insert and click
on the speaker table tab you once you click etc. Ask you to select the third range.
Typically it was like all the data in the file so you will need to do nothing.
And then it will ask you if you want to clear the table.
On this you shoot all the existing sheet creating a table on your shirt is always better.
And just like booking Excel will take you to this new screen.
And this news can you will see that on your right hand you have different parameters.
And in this four boxes you can correct them.
So for example if I want to look at the.
Look at the data based on my preference.
Other than just click and drag it for granted into the rows and others.
What I want to see against this brand is after a brutal bias I just drag them into the values and extroverts
typically take the some of the correct values.
Jackson will not show you the sum of your value as some of the deal prices against all of that.
These brands next bring in one more parameter and not destroy it cause.
Let's bring that in as well.
And know you can see that you can see both of the a retail price and bird calls against the brands.
What if we have to also see the tie against their first name.
So all you can also drag them into your into the rules format and so they quickly give you your rules.
Here in this uh a actually quickly give your birth names as well.
And this group of course for Mac.
Now what if we have to do some other parameters we have to bring in some other parameters as well as
support for it.
What if we only have to look at the recyclable products in one go.
I click here into the feed goes here and now you can just click the words which are recyclable here
and you will apply it.
Okay.
Next to the sort that I try to only bring in the values for the parts which are recyclable or you can
select all of them as well.
And you can also play an additional they both know that if that work is low fat you can also bring that
in and you can also apply this additional figure as well so you can apply different parameters you can
have hopefully you can bring in your data based on different but I mean those which can be for brands
that we each can be book for itself and you can also use this going on a feature if you want to list
your different values separately.
So if I want to uh if I can grab the bird brand here into the bird columns you will see that it's sort
of a long career.
The bird because separate columns for each brand and on a separate column you would see these birds.
So this way you can quickly summarize and analyze your data based on different parameters.
So pivot tables are my favorite tool for analyzing data and hopefully it will be yours as well.
It's very easy to implement.
Just go to click this click here on insert and click onto a table.
Here next a little pick me give you the pivot table for your data and you can prepare your data within
minutes.
Hope that was helpful.