Skip to content Skip to navigation Skip to login

Excel 2003 - Pivot Tables Training View a tutorial on this topic

Platform: PC

Description

A pivot table is a dynamic summary report generated from a database. The database can exist in a Microsoft® Excel workbook, or an external database file. This tutorial series will show you how to utilize this powerful feature.
Click any of the highlighted titles to view free sample tutorial movies. Atomic Learning subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
Click here to learn about subscribing to this collection!
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Understanding the benefits of a pivot table 24758 0:57
2. preview Understanding pivot table terminology 24759 2:32
3. locked Selecting appropriate data for a pivot table 24760 1:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Building pivot tables using the wizard 24761 1:52
2. locked Manually laying out a pivot table 24762 1:28
3. locked Using the Layout button to arrange a pivot table 24763 1:36
4. locked Selecting different source data 24764 1:41
5. locked Deleting a pivot table 24765 0:36
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding & removing fields to a pivot table 24766 1:07
2. locked Adding & using a page field 24767 1:07
3. locked Changing the data area number format 24768 1:06
4. locked Changing how empty cells are displayed 24769 1:15
5. locked Formatting a pivot table 24770 1:36
6. locked Sorting a pivot table 24771 1:42
7. locked Viewing detail data for an item 24772 1:06
8. locked Viewing detail for a data cell 24773 1:14
9. locked Excluding row or column items from the data summary 24774 1:35
10. locked Grouping pivot table items by date 24775 1:25
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Printing a pivot table with column & row field names 24776 1:14
2. locked Inserting automatic page breaks after each row item 24777 1:27
3. locked Copying a pivot table 24778 1:31
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying grand totals 24779 1:03
2. locked Changing the data summary function 24780 1:03
3. locked Creating a calculated field 24781 1:31
4. locked Inserting a calculated item 24782 2:23
5. locked Listing the existing formulas used in a pivot table 24783 0:35
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Refreshing pivot table data 24784 1:37
2. locked Refreshing data one page field value at a time 24785 1:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a pivot chart from an existing pivot table 24786 1:59
2. locked Creating a pivot chart from scratch 24787 1:55
3. locked Changing the layout of a pivot chart 24788 1:34
4. locked Converting a pivot chart to a static chart 24789 1:09
Tutorial series by Sarah DePriest
Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.
©2012 Atomic Learning, Inc.   All rights reserved.