20PivotTablesDay1StudyGuide

20PivotTablesDay1StudyGuide -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Day
16
–
Pivot
Tables
And
Data
Analysis
1
Study
Guide
 R:
8/25/09
dd
 
 1.
Appropriate
Uses
of
PivotTables
 
 2.
Four
Regions
of
a
PivotTable
(Row,
Column,
Page,
Data)
 
 3.
Data
Preparation
for
PivotTables
 
 4.
Grouping
 
 5.
Changing
Summary
Field
Types
 
 6.
Changing
“Show
value
as”
settings
 Difference
From
 %
Difference
From
 %
of
Column
 %
of
Row
 %
of
Total
 
 7.
Selecting
items
to
show
 
 8.
Adding
and
removing
subtotals
 ...
View Full Document

This document was uploaded on 03/15/2012.

Ask a homework question - tutors are online