Page 295 - Excel Data Analysis

18 537547 Index.qxd 3/4/03 11:54 AM Page 281

Excel Data Analysis:Analysis:
Excel
Data
Y
Your visual blueprint for creating andour visual blueprint for creating and
analyzing data, charts, and PivotTablesables
analyzing data, charts, and PivotT
medians, 81, 227 justify data in, 4
modes, 227 link to forms controls, 200
moving average trendlines, 115 lock. See protected worksheets
moving averages, 230–231 maximum number of characters, 4
Moving Averages Tool, 230–231 paste a range of, 14–15
selection, 7
B certification, macros, 174–177

BackColor property, 205 Change event, 211
background patterns, format, 19 chart events, 267
bar charts, 106 Chart Type dialog box, 144
BeforeDragOver event, 211 Chart Type option, 110
BeforeUpdate event, 211 chart types, 3, 106–113, 118–119
Bin operator, 67 charts, 106–109, 113–119
binary constraints, 67 check boxes, 197
bit, defined, 158 CheckBox button, 196–197
Bitmap option, 85 Click event, 208–209, 211
black square, cell corner, 28 code window, 208–209
Boolean data type, 159 color
borders, format, 19 BackColor property, 205
bubble charts, 109 formula codes, 72
byte, defined, 158 lines, 19
Byte data type, 158 number formats, 16–17
tables, 19
C column charts, 106
columns
calculated fields, 136–137
Calculated Item Solve Order dialog box, 139 labels, 4
skip on import, 91
calculated items, 138–139
calculation functions, PivotTables, 130–131 sort, 30–31
split to multiple, 90–91
Call statement, 170
capitalized letters, sort, 35 transpose to rows, 15
width, 19
Caption property, 205
case sensitivity, 35, 158 combo boxes, 197
ComboBox button, 196–197
category-type source fields, 120
CD-ROM, 274–275 command buttons, 197
CommandButton button, 196–197
cell ranges. See ranges
cell references comments, 15, 173
comparison operators, 162–163, 270
formulas, 273
macros, 164 comparisons, 106, 162–163
concatenated text, 162, 270
PivotTable calculated fields, 136
as range names, 9 concatenation operators, 162
conditional formats, 42–45
VBA variables, 181
cells Conditional Formatting dialog box, 42–45
conditional formulas, 68–69, 214, 216–219
copy, 14–15
data entry, 2. See also forms; import operation Conditional Sum Wizard, 214, 216–219
cone charts, 109
hide, 25
confidence level, 227
281