Here is a sneak preview of my Introduction to Pivot Tables course, showing you how to create a pivot table in Excel 2007.
You can download the whole course for both Excel 2007 and Excel 2003, including manual, sample data and real world examples here.
This free video is now available here.
This video just scratches the surface. You can find out more and get the full course (in Excel 2003 and 2007 versions) here.