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 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.
DAYS | IN CHARGE | EMPLOYEES ON DUTY |
SUNDAY | DAVE | 45 |
MONDAY | STEVE | 48 |
TUESDAY | STEVE | 41 |
WEDNESDAY | DAVE | 54 |
THURSDAY | DAVE | 25 |
FRIDAY | DAVE | 78 |
SATURDAY | STEVE | 54 |
STEPS TO CREATE A PIVOT TABLE:
After the pivot table is created automatically, we still have complete control over the table.
We can add or remove any fields as per requirement.
FOR MORE INFORMATION ABOUT PIVOT TABLES. CLICK HERE.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE