by Nate Moore | Dec 14, 2009 | Pivot Tables
Lesson 14 demonstrates another, simpler way to create formulas based on Pivot Table data. When you want relative formulas that change cell references as the formulas are copied, instead of GETPIVOTDATA, try typing the cell references directly into the formula. This...
by Nate Moore | Dec 9, 2009 | Pivot Tables
The GETPIVOTDATA function is a pretty hairy looking formula in Pivot Tables. The idea behind GETPIVOTDATA is to consistently pull the same data from a Pivot Table, even if the data is sorted or filtered differently. Excel will create the GETPIVOTDATA formula for you...
by Nate Moore | Dec 7, 2009 | Pivot Tables
Lesson 12 demonstrates a couple of formatting tricks to make your Pivot Tables look really good. Excel has set up a variety of Pivot Table styles in the Design toolbar that make it easy to select any of a variety of formats for your data. If you’ve used styles in the...
by Nate Moore | Dec 3, 2009 | Pivot Tables
I’ve created new set of sample data to learn with, sample receivables data. My experience is that analyzing accounts receivable is one of the most powerful, money saving ways to use a Pivot Table. We start Lesson 11 by analyzing accounts receivable by adding the...
by Nate Moore | Dec 1, 2009 | Pivot Tables
Lesson 10 shows how to add calculations to a Pivot Table by dragging more than one field to the values area of a Pivot Table. In this example, we use the same field twice in the same Pivot Table, once to count the number of new patients with each E&M code level...