Excel for Marketing Managers

Index

Formulas
Copy, 47, 48, 57, 73, 74, 91, 92, 105, 107,
132, 154, 155, 162, 178, 206, 215, 227-
229
Edit, 178
Enter, 1-8, 104, 110, 131, 179
Arrow Key Method, 5
Mouse Method, 3-5
Touch-Typing Method, 1, 2
Freeze Results, 87
Recalculate Automatically, 3, 55, 58, 75, 103,
153, 168, 177
Recalculate Manually, 55, 58, 103, 105, 109,
153, 168, 177
Forward Slash. See Division Operator, 10
Fractions, 10, 127-141, 185-199
in Pie Charts, 185-199
Visually Compare, 185, 196-199
Functions
ADDRESS, 99, 104
AND, 150, 151
AVERAGE, 17
CHAR, 159, 163, 165
CODE, 159, 162, 163, 165
COUNTIF, 131
Enter
Arrow Key Method, 6, 7
IF, 79, 80, 104, 106, 110, 150, 151, 154,
162, 165, 168, 169, 171, 178, 183, 184
INT, 63
INTEGER, 165
LEFT, 86
MAX, 206, 215
MID, 85
MOD, 62, 63
RAND, 66, 71
RANDBETWEEN, 53-55, 59, 62, 63, 104, 153,
154, 169, 179, 183, 184
RANK, 66, 72
RIGHT, 85
ROUND, 165
SQRT, 12, 14
SUM, 15, 86, 90, 92, 132, 148, 169, 179
VLOOKUP, 66, 72, 73

G

Graphs, Insert in Documents, 40

Grave. See Shortcut Keys, Ctrl+`, 72, 85

Grid Paper, 19-35

Grid Size, 31

Grid Sheet, Isometric, 32-34

Grid, Cartesian Coordinate, 35-40, 99

Handouts, 41

Gridlines, 22-28, 174, 181, 229

Hide, 95, 114, 139, 156, 189

H

Handout Sheets, 42, 43

Height Formula, 211, 215

Hidden

Columns, 65, 189

Text, 61, 112, 155, 189

Homework Checker, 75-99

I

Incrementation Value, 205, 214

IntelliSense, 15

Isometric Grid Sheets, 32-34

Iterations. See also Circular References, 103,

153, 168, 177

L

Landscape Mode, 67, 123

Largest Value, Find, 17

Left-justify Text, 56

Length Formula, 206, 209, 211, 215

Line Break, 202, 203, 212, 221, 222

Line Charts, 207, 208, 216, 217

Literals, 64