Excel Pivot Tables Recipe Book: A Problem-Solution Approach

Front Cover
Apress, Nov 21, 2006 - Computers - 332 pages

Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables—from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables.

All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for. There’s no fuss to this book, only clear and precise information to help you assess your situationwhether common or uniqueand solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

V
5
VII
6
VIII
7
IX
9
X
11
XII
14
XIII
15
XIV
16
CXXXIV
141
CXXXV
142
CXXXVI
143
CXXXVII
144
CXXXVIII
145
CXXXIX
147
CXLII
148
CXLIII
149

XV
17
XVI
18
XVII
19
XVIII
20
XIX
21
XX
22
XXI
23
XXII
24
XXIII
25
XXIV
27
XXV
28
XXVI
29
XXVII
30
XXVIII
31
XXIX
32
XXX
33
XXXI
34
XXXII
35
XXXIII
36
XXXIV
37
XXXV
39
XXXVI
40
XXXVII
41
XXXVIII
42
XXXIX
44
XLI
46
XLII
48
XLIII
49
XLIV
50
XLV
53
XLVII
54
XLVIII
55
XLIX
56
L
57
LI
59
LII
60
LIII
61
LV
62
LVII
63
LVIII
65
LX
69
LXI
70
LXII
71
LXIII
72
LXIV
74
LXV
75
LXVI
77
LXVII
78
LXVIII
79
LXIX
80
LXX
81
LXXI
82
LXXII
83
LXXIII
84
LXXIV
85
LXXV
86
LXXVI
87
LXXVII
89
LXXVIII
90
LXXIX
91
LXXX
92
LXXXI
93
LXXXII
96
LXXXV
97
LXXXVI
98
LXXXVII
99
LXXXVIII
100
LXXXIX
101
XC
102
XCI
103
XCII
104
XCIV
105
XCV
106
XCVI
107
XCVII
108
XCVIII
109
C
110
CI
111
CIII
112
CIV
113
CV
114
CVII
115
CVIII
117
CX
118
CXI
119
CXII
120
CXIV
121
CXV
125
CXVIII
126
CXIX
127
CXX
128
CXXII
129
CXXIII
130
CXXIV
131
CXXV
133
CXXVI
134
CXXVII
137
CXXVIII
138
CXXX
139
CXXXII
140
CXLIV
150
CXLV
151
CXLVI
152
CXLVIII
153
CXLIX
154
CLI
155
CLII
156
CLIII
157
CLIV
160
CLV
161
CLVI
162
CLVIII
163
CLIX
164
CLX
165
CLXI
168
CLXIII
170
CLXIV
171
CLXV
172
CLXVI
173
CLXVII
174
CLXVIII
175
CLXIX
176
CLXX
177
CLXXI
178
CLXXII
179
CLXXIII
180
CLXXIV
181
CLXXV
182
CLXXVI
183
CLXXIX
184
CLXXX
185
CLXXXI
186
CLXXXII
187
CLXXXIII
188
CLXXXV
190
CLXXXVII
192
CLXXXIX
195
CXC
199
CXCI
201
CXCIII
202
CXCIV
203
CXCV
205
CXCVIII
208
CXCIX
209
CC
211
CCI
212
CCII
214
CCIII
215
CCIV
216
CCV
218
CCVI
219
CCVII
222
CCIX
223
CCX
226
CCXI
230
CCXII
232
CCXIII
235
CCXV
236
CCXVI
237
CCXVII
238
CCXVIII
239
CCXIX
240
CCXX
241
CCXXI
242
CCXXII
247
CCXXIV
248
CCXXV
250
CCXXVI
252
CCXXVII
253
CCXXVIII
254
CCXXIX
255
CCXXXI
256
CCXXXII
257
CCXXXV
259
CCXXXVI
264
CCXXXVII
265
CCXXXVIII
267
CCXXXIX
268
CCXL
270
CCXLI
271
CCXLII
273
CCXLIII
275
CCXLIV
276
CCXLV
277
CCXLVI
278
CCXLVII
279
CCXLVIII
281
CCXLIX
282
CCL
284
CCLI
286
CCLII
287
CCLIII
288
CCLIV
289
CCLV
291
CCLVI
293
CCLVII
294
CCLVIII
295
CCLIX
296
CCLX
299
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page 20 - Multiple consolidation ranges Another PivotTable report or PivotChart report What kind of report do you want to create?
Page 20 - PivotTable and PivotChart Wizard - Step 1 of 3 Where is the data that you want to analyze? O Microsoft Office Excel list or database...
Page 6 - Excel list or database External data source Multiple consolidation ranges Another PivotTable report or PivotChart report What kind of report do you want to...

About the author (2006)

Debra Dalgleish is a computer consultant in Mississauga, Ontario, Canada, serving local and international clients. Self-employed since 1985, she has extensive experience in designing complex Excel and Access applications, as well as sophisticated Word forms and documents. She has led hundreds of Microsoft Office corporate training sessions, from beginner to advanced level. In recognition of her contributions to the Excel newsgroups, she has received the Microsoft Office Excel "Most Valuable Professional" award each year since 2001. You can find a wide variety of Excel tips and tutorials, and sample files, on her Contextures website: Contextures.com/tiptech.html.

Bibliographic information