David Carter's previous AccountingWEB pivot table tutorials [1] show you how to create pivot tables from accounting transactions exported into Excel.

When you have a pivot table that counts instead of sums, it is caused by one of three reasons. Reason No. 1: There Are One or More Blank Cells in the Column Excel expects your numeric data to be 100% ...

David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls ...