Skip to content Skip to navigation Skip to login

Excel 2007 - 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 29669 1:15
2. preview Understanding pivot table terminology 29670 2:56
3. locked Selecting appropriate data for a pivot table 29671 1:32
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Working without a pivot table wizard 29672 1:40
2. locked Manually laying out a pivot table 29673 2:08
3. locked Using the classic pivot table layout in the grid 29674 1:39
4. locked Selecting different source data 29675 1:58
5. locked Deleting a pivot table 29676 1:16
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding and removing fields from a pivot table 29677 1:04
2. locked Adding and using the page field 29678 1:20
3. locked Changing the data area number format 29679 1:22
4. locked Changing how empty cells are displayed 29680 1:39
5. locked Formatting a pivot table 29681 2:42
6. locked Sorting a pivot table 29682 1:37
7. locked Viewing detail data for an item 29683 1:49
8. locked Viewing detail for a data cell 29684 1:46
9. locked Excluding row or column items from the data summary 29685 1:39
10. locked Grouping pivot table items by dates 29686 1:21
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Printing a pivot table with column & row field names 29687 1:34
2. locked Inserting automatic page breaks after each row item 29688 1:31
3. locked Copying a pivot table 29689 1:48
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying grand totals 29690 1:06
2. locked Changing the data summary function 29691 1:03
3. locked Creating a calculated field 29692 1:56
4. locked Inserting a calculated item 29693 2:18
5. locked Listing the existing formulas used in a pivot table 29694 0:37
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Refreshing pivot table data 29695 1:49
2. locked Refreshing data at specific time intervals 29696 1:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a pivot chart from an existing pivot table 29697 1:39
2. locked Creating a pivot chart from scratch 29698 1:33
3. locked Changing the layout of a pivot chart 29699 1:26
4. locked Converting a pivot chart to a static chart 29700 1:11
Tutorial series by Robert Norgon
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.