To create a pivot table from data on different worksheets, you can use a Multiple Consolidation Ranges pivot table, but the result is a pivot table with limited features and functionality. Previously, Excel MVP Kirill Lapin shared his macro for creating a standard pivot table from data on different worksheets. Now Kirill has expanded that [...]

In Excel 2007, when you create a second pivot table from the same source data, you don’t get an option to base the new pivot table on an existing pivot table, the way you can in Excel 2003. In Step 1 of the Excel 2003 Wizard, you can select the first option, to create an [...]

Previously, we’ve looked at the pivot table summary functions:  Count, Average, Min and Max and Product. In this article we’ll look at the StdDev and StdDevp summary functions. StdDev Function and StdDevp Function Like the STDEV.P and STDEV.S worksheet functions, the StdDev and StdDevp summary functions calculate the standard deviation for the underlying data in [...]

Previously, we’ve looked at the pivot table summary functions:  Count, Average, Min and Max and Product. In this article we’ll look at the Var and Varp summary functions. Var Function and Varp Function Like the VAR.P and VAR.S worksheet functions, the Var and Varp summary functions calculate the variance for the underlying data in the [...]

In recent blog posts, we’ve looked at the pivot table Count function, the Average function, and the Min and Max functions. In this article we’ll look at the Product function. Product Summary Function The Product summary function shows the result of multiplying all the underlying values in the Values area. The result is the same [...]