You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Site Actions
This page location is:
Home
Tech Tools @ Mason
Excel-Pivot Tables
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Excel-Pivot Tables
team site for students, parents, and staff
Top Link Bar
Tech Tools @ Mason
Currently selected
PC Maintenance & Security
Digital Citizenship
Digital Citizenship links
Access
Intro
Intermediate
Advanced
Outlook
Office 2010
Sound Recording
Audacity PC
Audacity Mac
What does sound look like?
Video tools
Premier Pro CS4
Windows Movie Maker
Recently Modified
Home
Premier Pro CS4
Movie Maker
Audacity Project
Audacity PC
Quick Launch
Team Discussion
Word
Getting Started
Intro
Intermediate
Advanced
Newsletter Workshop
Mail Merge Workshop
WordTips
PowerPoint
Getting Started
Intro
Intermediate
Advanced
Excel
Intro
Intermediate
Advanced
Charting Workshop
Pivot Tables
Currently selected
Statistical Analysis
All Site Content
Excel 2007 - Pivot Tables
A. Pivot Tables
Understanding the benefits of a pivot table
Understanding pivot table terminology
Selecting appropriate data for a pivot table
B. Creating & Deleting
Working without a pivot table wizard
Manually laying out a pivot table
Using the classic pivot table layout in the grid
Selecting different source data
Deleting a pivot table
C. Customizing the Appearance & Layout
Adding and removing fields from a pivot table
Adding and using the page field
Changing the data area number format
Changing how empty cells are displayed
Formatting a pivot table
Sorting a pivot table
Viewing detail data for an item
Viewing detail for a data cell
Excluding row or column items from the data summary
Grouping pivot table items by dates
D. Printing Options & Copying a Pivot Table
Printing a pivot table with column & row field names
Inserting automatic page breaks after each row item
Copying a pivot table
E. Summarizing with Totals & Formulas
Displaying grand totals
Changing the data summary function
Creating a calculated field
Inserting a calculated item
Listing the existing formulas used in a pivot table
F. Refreshing Data
Refreshing pivot table data
Refreshing data at specific time intervals
G. Pivot Charts
Creating a pivot chart from an existing pivot table
Creating a pivot chart from scratch
Changing the layout of a pivot chart
Converting a pivot chart to a static chart
false,false,1
