Live Support
HOME
PRODUCTS
CONSULTING
LINKS
CONTACT US
Pivot Tables for Beginners
Advanced Pivot Tables
Pivot Tables in Excel 2007
Video
Lesson
Length
Introduction
Pivot Table Overview
3:15
How to Use Pivot Table Guru
3:05
Pivot Table Basics
Introduction to Pivot Tables
1:31
Underlying Data for Building a Pivot Table
2:50
Layout of a Pivot Table (Row, Column, Data, Page)
2:23
Data Validation
2:41
Pivot Table Wizard, Toolbar, Options
2:10
Creating Your First Pivot Table
2:10
Data Types
Text
0:59
Numbers
1:29
Time Based Values (Dates)
1:27
Calculated Fields
2:54
Common Pivot Table Operations
Selecting / Copying / Deleting a Pivot Table
2:41
Manipulating (Pivoting)
2:49
Refreshing Data
1:21
Filtering Data
1:14
Sorting Data
2:13
Showing and Hiding Detail Data
2:01
Aggregating (Grouping) Data
5:15
Subtotaling
2:03
Field Settings
1:24
Formatting
Formatting Pivot Tables
3:10
Formatting Pivot Table Cells
1:16
Pivot Charts
Creating a Basic Pivot Chart
2:49
Creating Advanced Pivot Charts
5:53
Sharing and Publishing
Sharing (Printing / Emailing / Publishing)
3:22
Putting It All Together
Gross Profit Report
5:50
Net Profit Report
4:03
Gross Margin Percentage Report
3:54
Net Margin Percentage Report
3:14
Title:
Pivot Tables for Beginners
Instructor:
Aaron Browne
Total Time:
1 hr 21 min
Experience Level:
Beginner
Prerequisites:
Working Knowledge of Excel
Software:
Microsoft Excel 2003
Format:
Web Based Online Training
Video:
Yes
Audio:
Yes
Access:
Online Access for 1 Year
License:
Single User
$19.99
