Vba pivot tables introduction in Excel

Pivot tables are one of the most powerful features of excel. Their importance is inevitable in data analysis task.

Pivot table offers a way to extract significant data from a bunch of available data.

The pivot tables are capable of complex caluculations in a fraction of second, without which, the data analysis task is tedious.

With pivot table, the same data can be viewed in various dimension as per the need of the end user.

This chapter illustrates the use of pivot tables with a sample data as given below:

excel vba pivot tables introduction

excel vba pivot tables introduction

Now, the following steps illustrates the creation of the pivot table.

Choose the data , that is, from A8:G15 as above.

Now Goto Insert--->Pivot Table.

excel vba pivot tables introduction

Now a dialog box appears demanding user option for, whether to display pivot table in the same sheet or separate sheet.

This is as shown below:

excel vba pivot tables introduction

Here, the range containing data has to be selected and the option of new or existing sheet is also chosen.

In the above example, we have simply sh

Now click OK, and the pivot table is added.

The pivot table has various options of displaying data, like SUM,Total and the data can be grouped in any paricular fashion.

The Pivot table has various options which will be displayed, when the pivot table is selected.

A glimpse of that is shown below

excel vba pivot tables introduction

The four main members are Filters,Columns,Rows and Values.

These four determines the format of the pivot tables.


You can find similar Excel Questions and Answer hereunder

1) I work with a SW that returns Hex values - how can I convert them to decimal values?

2) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

3) What are events in excel VBA. Here an explanation about VBA events.

4) How can I identify all cells with Conditional Formatting in my WorkSheet?

5) How can I prevent edits on my worksheet by protecting it with a Password ?

6) How can I insert a watermark in my Worksheet?

7) this is an introduction to Excel VBA. Learning how to do macro and coding in Excel VBA

8) How can I identify all cells with Data Validation in my WorkSheet?

9) How to create Pivot table in excel VBA

10) Split one long column into multiple smaller columns in Excel


Here the previous and next chapter