M


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




Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net