by Nate Moore | Nov 28, 2012 | Pivot Tables
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...
by Nate Moore | Nov 26, 2012 | Pivot Tables
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...
by Nate Moore | Nov 21, 2012 | Pivot Tables
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...
by Nate Moore | Nov 19, 2012 | Pivot Tables
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...
by Nate Moore | Nov 14, 2012 | Pivot Tables
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...
