PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO CREATE A PIVOT TABLE QUICKLY AND AUTOMATICALLY IN EXCEL?

PIVOT TABLE IN EXCEL
OUR FIRST PIVOT TABLE

INTRODUCTION

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.

BUTTON LOCATION OF AUTOMATICALLY CREATE PIVOT TABLE IN EXCEL

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.

CREATE PIVOT TABLES QUICKLY
BUTTON LOCATION FOR CREATING PIVOT TABLES QUICKLY

BENEFITS OF QUICKLY CREATE A PIVOT TABLE

We know the benefits of PIVOT TABLES. But here are the benefits of AUTO CREATE PIVOT TABLES.
Most of the times, we have standard situations. We have a data put in the columns having the headings . There are multiple types of data such as numbers and text.
So, what if we get some already created layouts from which we can choose.
It is going to be great for sure!
So, this is the reason why we can use this function and save us some time.

STEPS TO USE RECOMMENDED PIVOT TABLES IN EXCEL

It is always easy to learn a feature using the example.
Let us take a simple range from which we will create a pivot table.
The data is given below.
DAYSIN CHARGEEMPLOYEES ON DUTY
SUNDAYDAVE45
MONDAYSTEVE48
TUESDAYSTEVE41
WEDNESDAYDAVE54
THURSDAYDAVE25
FRIDAYDAVE78
SATURDAYSTEVE54
 

example of pivot table
DATA SAMPLE FOR PIVOT TABLE

STEPS TO CREATE A PIVOT TABLE:

  • Select the data including  headers ,go to insert tab and click RECOMMENDED PIVOT TABLES.
  • Click RECOMMENDED PIVOT TABLES BUTTON. A dialog box will open as shown in the following pic.
CREATE PIVOT TABLES DIRECTLY FROM AUTO PIVOT TABLES
CHOOSE PIVOT TABLES FROM THE OPTIONS GIVEN
  • The dialog box shown above, is giving the options of the PIVOT TABLES thought of automatically by Excel.
  • We need to choose the option from the given ones, which suit us most.
  • If none of the option suits us, click BLANK PIVOT TABLE at the bottom of the DIALOG BOX.
  • It’ll take us to the standard process of PIVOT TABLE CREATION.
  • If we have selected the PIVOT TABLE from the option list, click it.
  • It’ll start showing in the right portion of the dialog box as mentioned in the picture above.
  • CLICK OK.
  • Our PIVOT TABLE is ready.
 

 

CREATE A PIVOT TABLE IN SECONDS
INSERTED PIVOT TABLE FROM THE OPTIONS

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

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: