Getpivotdata – an easier and better way to reference a pivot table in Excel

From my other blog I have illustrated how to create a pivot table. How to read information from a pivot table Now I am going to mention how to refer information from a pivot table. There are two ways to do the job refer to the corresponding cells  (e.g. = a10) using the “GetPivotData” function … Read more

How to change report formats in Excel

Pivot Table - Rows

From my last blog, I have mentioned how to create pivot table in excel. Now, let’s go through different kinds report formats in Excel pivot table. There are three types of report formats in Excel Pivot Table: Compact Form Outline Form Tabular Form Suppose we have a pivot table with the following report fields. Following is … Read more

How to create a pivot table from multiple sheets (data sources) in excel using Pivot Table Wizard

How to create a pivot table from multiple sheets (data sources) in excel? From my previous blog, I have illustrated How to create pivot table in excel. The pivot table was using data from one single location. However, what about if the data itself is from multiple sources. Is it possible to create a pivot … Read more