missingmanuals.com - This screencast from Matthew MacDonald, author of Excel 2007: The Missing Manual, guides you through building and modifying a pivot table in Excel....
See how to add with multiple criteria using a Pivot Table (PivotTable), the SUMPRODUCT function and the SUMIFS function! Also see how to create many...
See how to average with criteria using a Pivot Table (PivotTable), the AVERAGEIF function and the SUMIF/COUNTIF functions! Also see how to create many formulas...