Free Excel Tutorial

Short Description
Free Excel Tutorial. http://www.usd.edu/trio/tut/excel/. ITM Online Help Collection. http://www.uwec.edu/help/excelXP.htm. Microsoft Excel Questions and …

Website: www.cmu.edu | Filesize: 935kb

Content
Microsoft?Excel PivotTables?- LUNCH AND LEARN Class Handout
TABLE OF CONTENTS
TABLE OF CONTENTS………………………………………………………………………………………………………………………1
CREATING A PIVOTTABLE?……………………………………………………………………………..2
Benefits of PivotTable Reports……………………………………………………………………2
SOURCE DATA……………………………………………………………………………………………2
The PivotTable Wizard……………………………………………………………………………..3
THE PIVOTTABLE LAYOUT………………………………………………………………………………4
REARRANGING PIVOTTABLES…………………………………………………………………………..5
CHANGING THE SUMMARY FUNCTION………………………………………………………………….6
ADDING A PAGE FIELD………………………………………………………………………………….6
REFRESHING A PIVOTTABLE……………………………………………………………………………6
FORMATTING A PIVOTTABLE……………………………………………………………………………7
PIVOTCHART REPORT…………………………………………………………………………………..7
NOTES:………………………………………………………………………………………………….8
EXCEL LINKS……………………………………………………………………………………………..9 1
CONTRIBUTED DOCUMENTATION This document is NOT supported by Computing Services.
DO NOT contact the Help Center with questions on this document.Microsoft?Excel PivotTables?- LUNCH AND LEARN Class Handout
Creating a PivotTable?
Use File: Excel PivotTable Class File
Microsoft?Excel PivotTable?feature organizes, summarizes, and analyzes your data to reveal its meanings.
PivotTable reports:
..
..
..
..
..
..
offer comparisons,
reveal patterns and relationships, and
analyze trends.
Each PivotTable report gives you a different view of your data, answering your questions on the spot, and is customized to your purposes.
Once you have your questions in mind, Excel makes it easy to get answers. First, a wizard takes us step-by-step in preparing the data for a new view. Next, you drag and drop the data from a list into a new PivotTable report view.
Benefits of PivotTable Reports
Pivot data around - moving parts of the table structure to summarize the data
Easily adjustable and customizable
PivotTables can quickly become PivotCharts
Source Data
We must become familiar with the source data to produce successful PivotTables. Let’s look at a sample of our worksheet:
2…