Skip to content Skip to navigation Skip to login

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

Platform: PC

Description

This online training series will demonstrate how to create and use Pivot Tables. You’ll learn how to select the appropriate Pivot Table data, format and sort the data, print and summarize the data, and create a Pivot Chart from an existing table. You’ll also learn how to create, format and view Sparklines and Slicers.
Click any of the unlocked titles to view free sample tutorial movies. Depending upon subscription level, Atomic Learning users have access to all of the following movies, plus thousands of other tutorials and resources on other applications and topics.
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview Understanding the benefits of a PivotTable 89338 1:04
2. preview Understanding PivotTable terminology 89339 2:39
3. locked Selecting appropriate data for a PivotTable 89340 1:24
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Working without a PivotTable wizard 89341 1:16
2. locked Laying out a PivotTable manually 89342 2:02
3. locked Using the classic PivotTable layout in the grid 89343 1:35
4. locked Selecting different source data 89344 1:59
5. locked Deleting a PivotTable 89345 1:12
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Adding and removing fields from a PivotTable 89346 0:58
2. locked Adding and using the page field 89347 1:10
3. locked Changing the data area number format 89348 1:32
4. locked Changing how empty cells are displayed 89349 1:40
5. locked Formatting a PivotTable 89350 2:17
6. locked Sorting a PivotTable 89351 1:23
7. locked Viewing data detail for an item 89352 1:40
8. locked Viewing detail for a data cell 89353 1:49
9. locked Excluding row or column items from the data summary 89354 1:53
10. locked Grouping PivotTables by dates 89355 1:24
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Printing a PivotTable with column & row field 89356 1:33
2. locked Inserting page breaks after each row item 89357 1:27
3. locked Copying a PivotTable 89358 1:55
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Displaying grand totals 89359 1:11
2. locked Changing the Data Summary function 89360 0:47
3. locked Creating a calculated field 89361 1:57
4. locked Inserting a calculated item 89362 2:39
5. locked Listing the formulas used in a PivotTable 89363 0:47
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Refreshing PivotTable data 89364 1:56
2. locked Refreshing data at specific time intervals 89365 1:18
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a PivotChart from an existing table 89366 1:36
2. locked Creating a PivotChart from scratch 89367 1:27
3. locked Changing the layout of a PivotChart 89368 1:28
4. locked Converting a PivotChart to a Static chart 89369 1:16
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Using Sparklines and Slicers 89370 1:24
2. locked Creating Sparklines 89371 1:21
3. locked Changing the Sparkline type 89372 1:15
4. locked Formatting Sparklines 89373 1:23
5. locked Viewing the parts of a Slicer 89374 1:47
6. locked Creating a Slicer 89375 1:16
7. locked Formatting a Slicer 89376 1:24
Tutorial series by Robert Norgon
Box shot reprinted by permission from Microsoft Corporation. Microsoft and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
©2012 Atomic Learning, Inc.   All rights reserved.