PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many times we don’t know how to effectively use the PIVOT TABLE.
We have already discussed HOW TO CREATE A PIVOT TABLE AND USE ITS DIFFERENT FUNCTIONS HERE.
Although pivot table creation takes very less time but what if we want it in lesser time .
So we will discuss a really quick way here to create a pivot table automatically in excel or automatic creation of pivot table in excel.
This can be created by an option called RECOMMENDED PIVOT TABLES.
This option , when used , present a number of already made pivot tables which saves us some time by saving us from setting up the fields for the pivot tables. Let us find out more details about the same.
We will find the option for automatically create PIVOT TABLES in EXCEL under the INSERT TAB in TABLES SECTION as shown in the picture below.
|DAYS||IN CHARGE||EMPLOYEES ON DUTY|
STEPS TO CREATE A PIVOT TABLE:
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE