m notation (minutes), 529
m notation (months), 528, 529
M status link indicator, 475
Macintosh
date values, adjusting, 70
file formats, 56, 57, 72
importing files, 69
transferring worksheets to Windows, 522
Macro-Enabled Workbooks (XLSM), 830
macro recorder, 830–833, 841, 846
macro settings in Trust Center, 106–107
macros
adding code to, 841–843
assigning to objects, 394–395
creating, 95
defined, 91, 827
documenting, 851–852
editing, 841–843
further reading, 859
IRM-protected documents and, 805
keyboard shortcuts, 941
macro recorder, 830–833, 841, 846
Object Browser, 836–837
Personal Macro Workbook, 845
relative cell references and, 832
run-time errors, 866–869
security and, 827–830
shared workbooks and, 792
stepping through code, 862–863
subroutines, 843–845
troubleshooting, 859–869
Trust Center settings, 106–107
unexpected results, 833
VBA objects, methods, and properties, 835–837
Visual Basic Editor and, 833–835
magic crossover date, 523
magnification. See zooming
mail-merged data, 901–904
major gridlines, 628
major tick marks, 628, 642, 644, 646, 649
manual page breaks, 420–421
Manual Query feature, 772
manually updating linked objects, 889, 896
mapping XML elements to columns, 757–758
marching ants (marquee), 181
margins
headers and, 408
Page Layout view, 406
printed output, 407–408
text in shapes, 383
marquee, 181
master workbooks, 799
MATCH function, 483–485, 516–517, 971
matching
case sensitivity, 221
cell contents, 221
query criteria, 770–772
text strings, 505
materials, applying to shapes, 380
math operators, 188–189
mathematical functions, 497–502
matrices, 359
maturity, 546
maturity securities, 545
MAX function
overview, 554, 972
in PivotTables, 732
in Query, 775
using instead of QUARTILE, 557
MAXA function, 556, 972
maximums, 569, 649. See also limitations
MDB files (database), 749–750
MDE files (database), 749–750
MDETERM function, 972
MDI (multiple document interface), 30, 166
MDURATION function, 548–549, 972
means, 568, 577
media files, 362–364
MEDIAN function, 554, 557, 972
medians, 554, 568
meetings, scheduling, 808
members of classes, 836–837, 861
memory usage, 9
menus
commands and options, 907–925
keyboard shortcuts, 942
merging
cell styles, 283–284
cells in shared workbooks, 792
consolidating worksheets, 258–264, 799
PivotTable labels, 723
scenarios, 589, 593–595
unmerging cells, 337–339
workbooks, 798–800
Message Bar (Trust Center), 107
Messenger icon, 807, 811
methods (VBA), 835–837, 840–841
MHT file format (Web pages), 70
MHTML file format (Web pages), 70
Microsoft Access databases, 746, 749–750, 759
Microsoft Equation Editor, 887
Microsoft Graph, 900
Microsoft Internet Explorer, 785, 807, 816, 875–876
Microsoft Internet Information Services (IIS), 803
Microsoft Office
Clipboard, 909
Excel Web Access, 820–821
Excel Worksheet Objects, 894–895
keyboard shortcuts, 945
macros and, 827
Office Assistant, 17
Office Diagnostics program, 80–81
Office Online. See Office Online
Office Update Web site, 551
registering Excel, 21–22
Microsoft Office Button commands and options, 907–925
Microsoft Outlook, 800–802, 808, 817
Microsoft Query. See Query
Microsoft SQL Server 2005, 803
Microsoft Visual Basic for Applications. See Visual Basic for Applications (VBA)
Microsoft Windows
keyboard shortcuts, 945
Start button commands and options, 907
taskbar, 29, 30
transferring worksheets to Macintosh, 522
Microsoft Windows Live ID authentication, 803, 806
Microsoft Windows Live Messenger, 808
Microsoft Windows Messenger, 811
Microsoft Windows Packager, 887
Microsoft Windows Rights Management Services (RMS), 803
Microsoft Windows Server 2003, 803
Microsoft Windows SharePoint Services. See SharePoint Services
Microsoft Windows Trust Center. See Trust Center
Microsoft XML Paper Specification (XPS), 423–424
Microsoft XPS Document Writer, 423–424
MID function, 506, 972
MIDB function, 972
middle alignment, 320
military time, 523, 526
MIN function
compared to QUARTILE, 557
overview, 554, 972
PivotTables, 732
Query, 775
MINA function, 556, 973
mini Ribbon, 88
Mini toolbar, 42, 95
minimums, 569, 649. See also limitations
minor gridlines, 628
minor tick marks, 628, 642, 644, 649
minus sign (-), 138, 256, 427, 458
MINUTE function, 533, 973
minutes
displaying, 526
m, mm notation, 529
overview, 521–522
MINVERSE function, 973
MIRR function, 541, 973
missing commands, finding, 907–925
misspellings. See spelling checker
mixed arguments in functions, 492
mixed cell references, 429–430, 433–434
mm, mmm, mmmm notations (months), 529
mm notation (minutes), 529
MMULT function, 973
MOD function, 499, 973
MODE function, 554, 973
mode in formulas, 568
models, loading, 607
modified annual duration of securities, 548–549
modified internal rate of return, 540–541
modifying. See editing
modular worksheet design, 123
modules in Visual Basic Editor, 833–835, 847–848
monitoring
code, 866
tasks, 812–814
variables, 862
Monte Carlo decision analysis, 575
MONTH function, 532–533, 973
monthly payments, 538
months
as chart base units, 649
last day of, 533
m, mm, mmm, mmmm notations, 528, 529
sorting and, 682–683
"more information" indicator in Help, 73
most recently used list (MRU), 875
mouse (wheeled), 27
movies, 363
moving. See also navigating
arrays, 469
axis labels, 642–643
chart elements, 635
chart labels, 647
charts to chart sheets, 620–621
data labels, 624
fields to alternate locations in PivotTables, 718–721
graphics, 387–393
keyboard shortcuts, 942–943
Quick Access Toolbar, 83–84
rows or columns with shapes, 390
shapes, 346
SharePoint documents, 818
SmartArt, 360
through interface or worksheets. See navigating
worksheets, 946
moving averages, 580–582, 660–661
MROUND function, 501, 973
MRU (most recently used) list, 875
MS-DOS file extensions, 53
MsgBox statement, 851
MSN Messenger, 811
MSN MoneyCentral Investor, 779
multilevel categories in charts, 658–660
MULTINOMIAL function, 974
multiple-criteria matches, 771–772
multiple document interface (MDI), 30, 166
multiple-page documents, 882
multiple regression, 560
multiples, rounding to, 501
multiplication, 498–499
multiplication sign (*), 427
multithreaded calculation, 10, 463
multiuser workbooks
advanced sharing options, 793–794
Excel Services, 820–823
multiple users in same workbook, 790–798
setting up, 792
turning off sharing, 797, 798
My Templates option, 46