by Nate Moore | Dec 5, 2012 | Pivot Tables
Excel Video 316 has one of the most important things to know about a Pivot Table. One of the reasons Pivot Tables can manipulate so much data so quickly is that once you set up a Pivot Table in Excel, Excel never goes back to the original data to see if the data has...
by Nate Moore | Dec 3, 2012 | Pivot Tables
Pivot Tables are easier to organize and manage if you know the tricks to using the Pivot Table Field List shown in Excel Video 315. Watch how to hide the Pivot Table Field List when you’re presenting your Pivot Table. We’ll also discuss several ways to display your...
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...
