599CD Computer Training

Courses - Microsoft Excel 223 - PivotTables Part 1

Description:

Intermediate Microsoft Excel - PivotTables 1

Running Time:

69 minutes

Pre-Requisites:

Excel 222 strongly recommended

Versions:

We use Excel XP in this course, but the lessons are valid for all versions of Excel from 95 to 2003. There are cosmetic changes in Excel 2007. Order before 2/7/2012 to get a FREE upgrade to our 2007 version when released!

This class was just recently completed. The full outline will be posted here shortly. Excel 223 is the first of our two-part series on PivotTables. It covers:

What is a PivotTable
Building a PivotTable
Manipulating PivotTable Fields
PivotTable rules for data
Field Settings
Pivoting Your Data
Inner & Outer Fields
Example: Sales Log
Example: Employee List
Refreshing PivotTable Data
Filtering Data
Using Page Fields to Filter Data
Sorting PivotTable Data
More

Try a FREE Demo Lesson

You may want to read these articles from the 599CD Blog:

11/18/2011	Dashboards in Excel
10/6/2011	Excel Expert 11 On Hold
10/1/2011	Excel 2010 Expert 10
8/22/2011	Two New Excel Handbooks Posted
8/9/2011	Excel 2010 Expert 9
7/20/2011	Help Me Decide on Excel Topics
7/20/2011	Excel 2010 Expert 8
7/19/2011	Excel Expert 8 Recorded
6/14/2011	Excel 2010 Expert 7
6/8/2011	Excel 2010 Expert 6

Do you have questions about Word, Excel, Access, Web Design, or computers in general? Just ask us anything you'd like. Click here for assistance.

Get Free Tips & Tricks

Join our mailing list today and get information on our Free Tips & Tricks Newsletter including free video tutorials, eBooks, live seminars, and more.

Email:

Name:

	Type in the word to the left:

Your email will be kept 100% safe and will never be given to 3rd parties.

Subscribe to our RSS Feed. What's This?

Facebook Twitter RSS hide help