Index290
Decode cycle, CPUs, 4
decomposition principle, 103
DecToHex function, 283
Defined Names group, 59–60
Delete command, rows, 148
delimiters, text, 163
depth axis, charts, 185
descending order, sorts, 151
descriptive statistics, 200–202
design step, problem solving, 106
Design tab
chart styles, 187–188
Convert to Range command, 160
Move Chart command, 190
Table Tools, 147
destination workbooks, linked workbooks, 42
Develop tab
assigning macros to graphic objects, 232–235
macro security, 230
working with macros, 229–230
digital signatures, macro security, 230
digital versatile disks (DVDs), 5
Dim keyword
declaring variables and, 248
variable scope and, 259
direct access memory, 5
Display options, for worksheets, 35
divide and conquer strategy, problem solving, 103
division operation (
/), 22, 283
Do Until loops, VBA, 278, 283
Do While loops, VBA, 277–280
domain name servers, 8
DVDs (digital versatile disks), 5
E
Editing group, Sort and Filter options, 151–152
EDVAC (Electronic Discrete Variable Automatic
Computer), 2
Electronic Numerical Integrator and Computer
(ENIAC), 2
Else keyword. See flow control, VBA programming
embedded charts, 185
engineering functions, 55, 120
ENIAC (Electronic Numerical Integrator and
Computer), 2
equals operator (
=), VBA, 251
equals sign (=), indicating formulas, 21
Error Alert tab, Data Validation dialog box, 98, 100
error checking, 6468
Excel Options, 64
Formula Auditing group, 6568
list of error values, 65
VBA, 245, 263–267
Error Checking dialog box, 6566
error values, 65
errors, rounding, 6263
Euclidean distance, 56–58
Evaluate Formula, 54, 6668
event-driven programming, 242
events, VBA, 242
Excel basics, 11–39
cell selection, 20
creating worksheets, 26–30
custom settings, 33–37
data types, 20–24
le formats, 32–33
formatting, 24–26
help options, 37–38
interface for, 12
navigating worksheets, 18–19
overview of, 1112
printing worksheets, 30–32
Ribbon, 13–15
tips for good worksheets, 38–39
worksheet templates, 32
workspace, 15–18
Excel icon, 26
Excel Office tab, 13
Excel Options, 33–37, 64
Excel tables. See tables
Execute cycle, CPUs, 4
exhaustive search strategy, 103, 105
exponential growth, 106
exponentiation operation (
^), 22
expressions, VBA, 250–251
Extensible Markup Language (XML), 32–33
external links, referencing styles, 42
extraction functions, text, 127–129
F
F1 key (help), 37
F9 key (manual calculation), 34
False(), logic function, 81
Fetch cycle, CPUs, 4
fields
names, 146
Pivot table, 169
le formats, 32–33
le servers, 7
les, linked, 42
Fill Color button, font styles, 27
ll handles, Excel workspace, 16
ltering
advanced, 156159
tables, 154–156
financial functions, 55
FIND function, 131
Find Next, searching by criteria, 150–151
floating point calculations, 61
Floor function, 6162
flow control, VBA programming
If-Then structure, 272–274
If-Then-Else structure, 274–275
overview of, 272
Select Case structure, 275–276
flowcharts
nested
IF functions and, 72–73
problem solving, 106–108
fonts
Excel Options for, 33–34

Get Computing with Excel and VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.