PivotTableGuru.com - Video Training to Help Master Pivot Tables in Microsoft Excel

Video	Lesson	Length
Introduction
	Introduction to Excel 2007 Pivot Tables	2:17
	Differences and Key Notes between Excel 2003 and 2007	3:10
Pivot Table Basics
	Underlying Data for Building a Pivot Table	1:55
	Layout of a Pivot Table	3:29
	More on the Layout of a Pivot Table	1:43
	Creating a Basic Pivot Table	2:35
Common Pivot Table Operations
	Manipulating or Pivoting Data	2:42
	Adding Fields to the Report	1:56
	Refreshing Data	3:39
	Filtering Data	1:27
	Sorting Data	1:33
	Drilling in / Drilling out	5:58
	Aggregating (Grouping) data	7:11
	Subtotaling	3:13
	Field Settings	2:29
	Pivot Table Options	5:19
	Options Tab	2:17
Formatting
	Formatting Individual Cells	2:06
	Formatting and Styling Pivot tables	2:16
	Themes and Custom Styles	3:38
Pivot Charts
	Creating a Basic Pivot Chart	2:53
	Formatting Pivot Charts	2:54
Advanced Pivot Tables
	Custom Fields (Calculated Fields)	6:02
	Connecting a Pivot Table to a Database	11:07
Creating Dashboard
	Creating Gross Profit Report	6:35
	Creating Gross Margin Report	3:35
	Putting the Dashboard together	6:04

Title: Pivot Tables in Excel 2007
Instructor: Aaron Browne

Total Time: 1 hr 40 min

Experience Level: Expert
Prerequisites:
   Working Knowledge of Excel
   Pivot Tables for Beginners
   Advanced Pivot Tables
   Programming Experience

Software: Microsoft Excel 2007

Format: Web Based Online Training
Video: Yes
Audio: Yes

Access: Online Access for 1 Year
License: Single User

$29.99

30 day money back guarantee