Page 301 - Excel Data Analysis
P. 301
18 537547 Index.qxd 3/4/03 11:54 AM Page 287
Excel Data Analysis:
Your visual blueprint for creating and
analyzing data, charts, and PivotTables
R protection, worksheets, 24–25 StdDevp function, 37
selfcert.exe program, 174 stock charts, 109
R1C1 reference style, 273 trusted sources, 177 stock market data, charts, 109
radar charts, 108 worksheet passwords, 24–25 Stop messages, 57
range (of data), 227 Select Data Source dialog box, 87 Store Macro In option, 165
ranges selection String data type, 159
copy and paste, 14–15 cells for copy, 14–15 string manipulation functions (VBA),
named, 8–13, 62–63, 136 deselection, 14 quick reference, 265–266
selection, 7 items from a list, 197 Style dialog box, 20–21
Rank and Percentile Tool, 232–233 multiple rows/columns, 7 styles, 20–21. See also formats;
RANK function, 80–81, 233 noncontiguous cell ranges, 7 templates
ranks, 80–81, 232–233 objects in forms, 197 Subtotal dialog box, 46–47
record operation, macros, 164–165 a range of cells, 7, 197 SUBTOTAL function, 47
#REF! message, 273 whole rows/columns, 7 subtotals, data lists, 46–47
RefEdit button, 196–197 selection, keyboard shortcuts, 238 Sum function, 37, 59
reference form, 78 selfcert.exe program, 174 summarized data lists, 46–47. See
reference functions (Excel), quick Series dialog box, 29 also PivotTables
reference, 248 sums of values, 37, 59, 103, 227
reference operators, 271 series of data, 28–29 surface charts, 108
shortcut keys. See keyboard shortcuts
relative cell references, 164, 273 system requirements, CD-ROM, 274
repeated values in a series, 28–29 Sigma XL (on the CD), 275
Single data type, 158
result presentation, 3. See also T
charts; PivotCharts single quote (') tabbed dialog boxes, 197
reusable formulas, 63 fraction indicator, 4 tabbed form sections, 197
row height, format, 19 numeric text indicator, 4 table color, format, 19
rows VBA comment indicator, 173 Table dialog box, 70–71
labels, 4 in worksheet locations, 122 tables (database), imported,
sort, 30–31 in worksheet names, 38 94–95, 99
transpose to columns, 15 skewness, 227 TabStrip button, 196–197
R-squared values, 114–115 SMALL function, 81 templates, 22–23. See also
Running Total In option, 131 Solver option, 66–67 formats; styles
Solver Parameters dialog box, 66–67 Templates dialog box, 22–23
S Sort dialog box, 30–31 test functions (Excel), quick
sort operation, 30–35, 100–101, reference, 255
sample variance, 103, 227 135, 139
scatter charts, 107 Sort Options dialog box, 34–35 text
scenarios, 54–55 Source Data dialog box, 117 breaks in imported data, 88
scientific functions, 214 spin buttons, 197 concatenated, 162, 270
scientific notation, 4 SpinButton button, 196–197 data types, 4
screening. See filters square brackets ([ ]), in worksheet import formatting, 93
scroll bars, 197 locations, 122 join, 162, 270
ScrollBar button, 196–197 standard deviation, 37, 103, 227 text boxes, 197
searching. See find operation standard errors, 227 Text Import Wizard, 86–89
secondary axes, charts, 119 static Web pages, 104 text labels in forms, 197
seconds, format, 17 statistical functions, 251–254 text operators in formulas, 270
security statistics. See entries for specific Text option, 85
macro settings, 174–177 measures Text property, 205
protection, scenarios, 55 StdDev function, 37 Text to Columns option, 90–91
TextAlign property, 205
287
