Select Page

Excel Video 11 Sum and Count Pivot Table Values

by | 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...

Excel Video 10 Multiple Pivot Table Value Fields

by | 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...