Page 297 - Excel Data Analysis

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

Excel Data Analysis:
Your visual blueprint for creating and
analyzing data, charts, and PivotTables
Enter event, 211 find operation formulas. See also functions; macros
equal sign (=) conditional format, 45 absolute references, 273
comparison operator, data list exact values, 6 arithmetic operators, 270
filters, 53 by format, 6 cell references, 273
comparison operator, Solver functions, 60 color-coded, 72
constraints, 67 by specified criteria, 27 comparison operators, 270
in formulas, 5 with wildcards, 6, 77 conditional, 68–69, 214, 216–219
error messages. See also entries for Find option, 6 copy, 63
specific messages FinOptions XL (on the CD), 275 create, 3
customize, 57
formulas, 273 folder handling, 256, 262 debug. See formulas, evaluation
Font property, 205
defined, 5
hide, 43, 73
Information messages, 57 fonts, format, 19 dependent cells, display, 65
For Next statement, 182–183
edit, 62–63
Stop messages, 57
user input errors, 57 forecast. See PivotCharts; PivotTables error messages, 273
Format Cells dialog box, 25
evaluation, 64–65, 72–73
Warning messages, 57
Evaluate Formula dialog box, 64–65 format numbers, 16–17, 19 functions, 272
graphical representation of, 65
formats. See also autoformat; named
evaluation, formulas, 64–65, 72–73 styles; styles; templates
events, 211, 266–269. See also entries background patterns, 19 insert range names, 9
for specific events keyboard shortcuts, 236
Excel Programming: Your visual borders, 19 missing range names, 9
blueprint..., 196 with color, 16–17 move, 62–63
exclamation mark (!), in worksheet column width, 19 named ranges, 63
names, 38 conditional, 42–45 operator precedence, 271
exponential trendlines, 115 Conditional Formatting dialog paste, 15
Extensible Markup Language, 105 box, 42–45 in PivotTable calculated fields, 136
External Data Ranges Properties currency values, 16–17 precedent cells, display, 65
dialog box, 95 date/time values, 17 R1C1 reference style, 273
external databases, imported data, decimal places, 16–17 reference operators, 271
94–103, 142–145 display insignificant zeros, 16 relative references, 273
dollar signs, 16–17
F Find Format dialog box, 6 reuse, 63
solve for different values, 70–71
F statistics, 221, 229 find values by, 6 step through. See formulas,
field delimiters, imported data, 88 fonts, 19 evaluation
fields, PivotChart, 146–147, 150–153 Format Cells dialog box, 25 text operators, 270
file handling, 256, 262 keyboard shortcuts, 235 trace, 65, 72–73
Fill Handle, 28, 63 line colors, 19 true/false conditions, 68–69
filters, 58–53 outlines, 41 view execution of, 64–65, 72–73
data lists, 48–53 parentheses, 16–17 4TOPS Data Analysis (on the CD), 275
database records, 96–101 paste, 15 fractions, 4
PivotChart fields, 150–151 PivotCharts, 149 Frame button, 196–197
PivotChart source data, 143 row height, 19 From dialog box, 26–27
PivotTables, 120, 125, 128–129 switch chart types, 110 F-Test Two-Sample for Variances
financial functions, 214, 244–246, table color, 19 tool, 228–229
262–263 zero values, 16–17 Function Arguments dialog box,
Find and Replace dialog box, 6 forms, 2, 194, 196–213 60–61, 62–63
Find Format dialog box, 6 Forms toolbar, 195, 199

283