Page 779 - Excel 2013 All-in-One For Dummies

Index 761
lookup functions HLOOKUP function,
410–413
INDEX function, 415–417 LOOKUP function, 417 MATCH function, 413–417 overview, 409
VLOOKUP function,
410–413
lookup tables, 82, 409 Lotus 1-2-3 compatibility,
55, 61
LOWER function, 425 LP Simplex method, 662 Lync online meeting
software, 490, 495–496
M
Macro dialog box, 715–716 macro recorder, 710–715 macros
adding to Quick Access Toolbar, 44–45
creating, 710
custom tabs on Ribbon
for, 718–719 editing in Visual Basic
Editor, 724–726
finding and replacing code
in, 726–728
InputBox function, 729–733 overview, 709
Quick Access toolbar
buttons for, 719–720 recording, 710–715 running, 715–716 security, 716–717 writing in Visual Basic
Editor, 733–735 magnification, 199–201, 204 Manage Relationships
dialog box, 623, 626
Manage Rules option, 174 managing worksheets.
See also consolidating worksheets; Outline feature; View Side by Side feature
adding worksheets, 251–252
background images, adding, 250–251
color coding tabs, 249–250
columns and rows, adding, 232, 233–234
deleting columns and rows, 232–233
deleting worksheets, 251–252
group editing, 253 hiding worksheets, 254 overview, 231–232 rearranging order of
worksheets, 251–252 renaming worksheets,
248–249
splitting worksheets into
panes, 234–237 Manual calculation, 335,
336, 382
Manual option, Excel
Options dialog box, 49 margins
overview, 270
setting, 278–280
in text boxes, 564–565 viewing in Page Layout
view, 273
viewing in Print screen,
276, 280
Margins button, 277 Mark as Final option, 437 marking invalid data,
226–228
marking up with digital ink, 486–488
Match Case check box, Find and Replace dialog box, 218
Match Entire Cell Contents check box, Find and Replace dialog box, 218
Math & Trig functions CEILING.MATH, 393–394 EVEN, 393
INT, 392–393
ODD, 393 overview, 389–390 POWER, 394–395 ROUND, 390–392 SQRT, 394–395 SUM, 395–396 SUMIF, 396–398 SUMIFS, 396–399 TRUNC, 392–393
Math AutoCorrect option, 51 MAX function, 400 Maximum Change text box
option, Excel Options
dialog box, 49 Maximum Iterations option,
Excel Options dialog
box, 49
MDURATION function, 387 MEDIAN function, 400 Member Options dialog
box, 738
memory considerations in
workbook design, 83 Merge & Center button, 146 Merge Styles dialog box, 173 merging
cell styles into other workbooks, 173
changes from different users, 479–482