Page 300 - Excel Data Analysis
P. 300
18 537547 Index.qxd 3/4/03 11:54 AM Page 286
INDEX
numeric characters, 4 PivotChart Wizard, display, 127 groups, hide, 133
numeric data types, 4, 158 PivotCharts groups, remove, 133
numeric values, imported data, 88 change chart type, 144, 148–149 hidden cells, 120
change layout, 146–147 keyboard shortcuts, 237
O custom chart types, 149 remove fields, 127
Object Browser, 193 data labels, 155 report fields (illustration), 121
Object data type, 159 data tables, add, 154–155 restrictions, 120
Object Database Connectivity, 97 defined, 3 size limit, 120
Object Linking and Embedding, 74–75 determine layout, 145 sort, 135
observations, 229 embed in worksheets, 144 plug-ins. See add-ins
ODBC, 97 from external databases, 142–145 plus sign (+)
OLE, 74–75 fields hidden record indicator, 40–41
Open event, 190–191 add, 146 VBA concatenation operator, 162
Open method, 191 filter, 150–151 PMT function, 82–83
operator precedence, formulas, 271 group items, 152–153 polynomial trendlines, 115
operators move, 146 population variance, imported
arithmetic, 161 remove, 147 data, 103
comparison, 162–163 filter source data, 143 positive numbers, format, 16
concatenation, 162 format, 149 power trendlines, 115
filter data lists, 51 hide buttons, 151 PPMT function, 82–83
logical, 163 keyboard shortcuts, 237 precision, 4
VBA, 161–163 legend, display, 154 prediction. See PivotCharts;
PivotTables
OptionButton button, 196–197 PivotTable toolbar, display, 145 presentations. See charts;
outline data, 40–41 refresh, 147 PivotCharts; result presentation
uses for, 142
P PivotTable reports previews, imported data, 99
break into pages, 125 private functions, 170–171, 179
P statistic, 229 Product function, 37
copy values from, 141
parentheses, format numbers, 16–17 program flow, VBA statements,
password protection, 24–25 create from Excel lists, 122–125 257–258
data types, 123
Paste command, 84–85 properties, forms, 205
paste operation, 14–15, 84–85 retrieve values from, 140–141 proportional comparisons, 107–108
sort, 139
Paste option, 14–15 Protect Sheet dialog box, 24–25
Paste Special dialog box PivotTable toolbar, 125, 145 protected worksheets, 24–25
PivotTables
add data to charts, 117 public functions, 170–171, 179
copy PivotTable values, 141 calculated fields, 136–137 pyramid charts, 109
calculated items, 138–139
customize paste behavior, 15
options, 84–85 calculation functions, 130–131 Q
calculations, multiple, 134–135
% of column option, 131 QUARTILE function, 81
% Of option, 131 category-type source fields, 120 quartile values, find, 81
change layout of, 126–127
% of row option, 131 query files, 95
% of Total option, 131 data types, 120 Query Wizard, 96–101
data-type source fields, 120
percentages, 4 question mark (?), wildcard character
percentiles, 232–233 defined, 3 in data list filters, 50
filter data, 120, 125, 128–129
Picture (Enhanced Metafile) in value searches, 6, 77
option, 85 group data, 120
pie charts, 107, 111 grouping data, 132–133
286
