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

Video	Lesson	Length
Introduction
	Advanced Pivot Table Overview	4:00
	How to Use Pivot Table Guru	3:41
Advanced Pivot Table Creation
	Creating a Pivot Table from External Data	4:15
	Pivot Cache	4:15
	Consolidation Ranges	2:03
	Data from Another Workbook	1:23
	Dynamic Data Sources	2:41
	List	2:00
Refreshing Data
	Refresh All Button	1:55
	Refresh On Change	1:32
Advanced Grouping and Summarizing
	Grouping Hierarchical Data	4:11
	Summarize By Options	10:56
Calculated Fields / Items
	Advanced Calculated Fields	6:29
	Calculated Items	2:17
Advanced Formatting
	Conditional Formatting	4:30
Utilizing Data from a Pivot Table
	GetPivotTableData	2:20
	Cell References	4:18
	Functions	6:03
Automatically Creating Worksheets
	Show Pages	0:54
Pulling it All Together
	Invoices	6:01
	Revenue and Forecasted Revenue	4:02
	Schedule Management	6:47

Title: Advanced Pivot Tables
Instructor: Aaron Browne

Total Time: 1 hr 26 min

Experience Level: Intermediate
Prerequisites:
Working Knowledge of Excel
Pivot Tables for Beginners

Software: Microsoft Excel 2003

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

Access: Online Access for 1 Year
License: Single User

$19.99

30 day money back guarantee