Select Page

## Excel Video 314 Calculated Fields in Pivot Tables Part 2

Excel Video 314 has a couple more things you should know about calculations in Pivot Tables. The most important trick is to find an existing calculation when you go to the Insert Calculated Field window. Once you’re okay there, I have a way to show all of the Pivot...

## Excel Video 313 Calculated Fields in Pivot Tables Part 1

Excel Video 313 Calculated Fields in Pivot Tables Part 1 Here’s a third way to make calculations with Pivot Table Data Excel Video 313 introduces a third way to make calculations with Pivot Table data. Calculated fields take a little longer to set up, but if you’re...

## Excel Video 312 GETPIVOTDATA Part 3

Excel Video 312 covers a few more things to know about GETPIVOTDATA. We’ll start where we left off in Excel Video 311 by adding even more fields to our Pivot Table. Once you understand the structure of the GETPIVOTDATA formula, adding more fields to the Pivot Table is...

## Excel Video 311 GETPIVOTDATA Part 2

Now that we’re a little more familiar with GETPIVOTDATA, let’s see what else it can do for us in Excel Video 311. We’ll take what we learned in the last Excel Video and apply it to the original formula we had trouble copying a videos ago. Notice how easy it is to copy...

## Excel Video 310 GETPIVOTDATA Part 1

Excel Video 310 is the first step in our effort to demystify GETPIVOTDATA. As you’ll remember from our last Excel Video, Excel automatically creates a GETPIVOTDATA formula for you when you click to create a formula referencing a cell from a Pivot Table. Last time I...