PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
PIVOT TABLE is a well known feature of GOOGLE SHEETS which everybody of us might have heard of. But many times we don’t know how to effectively use the PIVOT TABLE.
PIVOT TABLE is a dynamic table which we can create in GOOGLE SHEETS. We called it dynamic as we can transform it within seconds. The original data remains the same.
We know that whatever is hinged to a pivot, can rotate here and there, so is the name given to these tables.
PIVOT Table is a very powerful tool to summarize, analyze explore the data in very simple steps. Its very important to learn the use of pivot tables in excel if we want to master excel. Pivot tables give us the facility to put different simple operations on a selected data in seconds.
In this article , we would learn to create a pivot table from the scratch and using it in different ways.
we need to analyze large data in a short notice.
we need to total, summarize, category wise, sub category wise, perform different calculations like sum, average, or any custom calculation etc.
A collapsible presentation, which we can twist and present in our own way within a few seconds.
Play with rows and columns and create different reports.
we need to filter, group, sort and conditionally format the data.
Let us understand the steps to create pivot table using an example.
DATA SAMPLE:
The table and picture below show the Sales of Cars for every day of a month. [ Only a portion is available].
We will create a PIVOT TABLE for the given data and see what kind of different operations we can perform on this data within seconds.
DAY | SALES |
sunday | 1 |
monday | 2 |
tuesday | 3 |
wednesday | 4 |
thursday | 5 |
friday | 6 |
saturday | 7 |
sunday | 8 |
monday | 9 |
tuesday | 4 |
wednesday | 5 |
thursday | 6 |
friday | 7 |
saturday | 8 |
sunday | 5 |
monday | 4 |
tuesday | 4 |
wednesday | 3 |
thursday | 7 |
friday | 9 |
saturday | 7 |
sunday | 3 |
STEPS TO CREATE A PIVOT TABLE:
CHOOSING DIFFERENT OPTIONS TO CREATE PIVOT TABLE:
In the picture above we can see that an empty structure of the PIVOT TABLE has been created.
On the RIGHT SIDE of the screen are the different options from where we can choose the different columns which we want to put in ROWS , COLUMNS , VALUES or FILTER
COLUMNS: This field will contain the columns of our pivot tables. For examples, if we need the values, we need to select values from the dropdown list there. Click ADD to get the list of available fields and click to choose.
FOLLOW THE STEPS TO CALCULATE THE TOTAL SALES PER DAY:
FOLLOW THE STEPS TO CALCULATE THE AVERAGE SALES PER DAY:
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE