Page 12 - Excel Data Analysis

01 537547 FM.qxd 3/4/03 11:43 AM Page x

TABLE OF CONTENTS

7) WORKING WITH PIVOTTABLE REPORTS

PivotTable Basics ..............................................................................................................120
A View of the PivotTable Report Fields ........................................................................121
Create a PivotTable Report from an Excel List ..............................................................122
Change the Layout of a PivotTable ................................................................................126
Filter a Field ......................................................................................................................128
Change the Calculation of a Data Field ........................................................................130
Group PivotTable Data Items ........................................................................................132
Add Another Data Area Calculation ..............................................................................134
Add a Calculated Field ....................................................................................................136
Add a Calculated Item ....................................................................................................138
Retrieve a Value from a PivotTable Report ..................................................................140

8) CREATING PIVOTCHARTS

Create a PivotChart from an External Database ..........................................................142
Change the Layout of a PivotChart ................................................................................146
Change the Chart Type of a PivotChart ........................................................................148
Filter a PivotChart Field ..................................................................................................150
Group Items in a PivotChart Field ................................................................................152
Add a Data Table to a PivotChart ..................................................................................154

9) AUTOMATING ACTIONS WITH MACROS

An Introduction to Macros ............................................................................................156
Record a Macro ................................................................................................................164
Run a Macro ....................................................................................................................166
Activate the Visual Basic Editor ......................................................................................168
Create a Macro Using the Visual Basic Editor ..............................................................170
Update a Recorded Macro ..............................................................................................172
Set Macro Security ..........................................................................................................174
Create a Custom Function ..............................................................................................178
Declare a Variable ............................................................................................................180
Execute a Task a Specific Number of Times ..................................................................182
Display a Message Box ....................................................................................................184
Request User Input for a Macro ....................................................................................186
Assign a Macro to a Menu ..............................................................................................188

x