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

This is a tough question. Whether you are using the Report Filter or the new Excel 2010 Slicer feature in a pivot table, there is really no good way to change the filter with a formula. Instead, you ...

Use Table format No. 9 Hi GB If you need to have multiple columns in the data area of a Pivot Table the simplest way is to choose No. 9 from the 'Format Report' option on the Pivot Table toolbar. As ...