Latest Posts
1

Copying Excel Pivot Table!

Copying Excel Pivot Table!

A pivot table is very flexible, but it has several limitations. Say you can't add new rows or columns to a pivot table, though you can add rows or columns in the data source. You can't change any of ...

READ MORE +
1

How to Modify an Excel Pivot Table

How to Modify an Excel Pivot Table

After you have created your pivot table, it is easy to change it. For example, you can add more summary information by using the PivotTable Fields task pane. Say, we have the following pivot table we ...

READ MORE +
5

Excel Pivot Table Terminology

Excel Pivot Table Terminology

You have to understand the terminology associated with pivot tables. It is the first step to the master Excel pivot table. See the following Figure.A pivot table Column labels Each item in the ...

READ MORE +
1

Data appropriate for a pivot table

Data appropriate for a pivot table

A pivot table can handle data that is in the form of a rectangle. Your database can be stored in either a worksheet or an external database file. Worksheet database can be in table form or just a ...

READ MORE +
0

Exporting Data in Excel

Exporting Data in Excel

We shall discuss in this section about exporting data in Excel. You can convert your Excel workbook in different formats like csv, txt, PRN, and many more. Converting Excel workbook to text format ...

READ MORE +