Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Count Blank Cells in Pivot Table Source Data

Sometimes there are blank cells in a pivot table's source data, and you might want to show a count of those blank cells in the pivot table. In this example there's an Employee field in the source data, and some of the records have no employee name entered. In the pivot table, you'd like to [...]