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.

Excel For Underdogs

Have you ever had trouble trying to count items based on two criteria? Don’t worry – it’s Underdog to the rescue!
Note: There’s a short sound clip in the video, so turn down your speakers if your co-workers are napping.
Underdog Comes to the Rescue in Excel
Use SUMPRODUCT to Count
As Underdog mentioned, [...]