IF YOU ARE USING EXCEL 2007, because these all have the file extension ".xls", if you want the Pivot Tables to look the same as in the videos, after you create the Pivot Table, right-click the Pivot Table, point to Pivot Table Options, click on the Display tab, then uncheck the checkbox “Classic Pivot Table layout”.

1) Custom Player, click and watch here (9 videos, 73 minutes):

2) Click on link to go to YouTube to watch videos (9 videos, 73 minutes):

Stats 01: Intro To Excel 2007 for Statistics
Stats 02: Calculations, Operators, Formulas
Stats 03: Data Analysis Sorting & Pivot Tables
Stats 04: Frequency Pivot Table Chart Basics
Stats 05: Cell References in Formulas
Stats 06: Don't get tricked by Number Formatting
Stats 07: Calculate Proportions and Percentages
Stats 08: Install Excel 2007 Data Analysis Add-in
Excel Magic Trick 603: Why 100*1.1 = 110 Means Increase by 10%

3) Click on link to go to YouTube Playlist (9 videos, 73 minutes):
Excel Statistics Business Class Ch00: Excel 2007 Basics