Excel 2010: The Missing Manual

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

Macro dialog box 2nd

macros 2nd

        adding buttons and menu entries that trigger

        anatomy of

        attaching to button inside worksheet

        attaching to toolbars or menus

       examples

                alternating row formatting

                calculating average and median values for a list of numbers

                inserting a header

        FormatHeader

        FormatRow

        keyboard shortcuts 2nd

        overview

        personal macro workbook

        playing

        recorder

                absolute versus relative recording

                key points

                recording new macro

        recording

        relative reference mode

        running in Visual Basic editor

        security and

        setting workgroup templates folder

        shortcut dangers

       VBA

                debugging

                finding and moving

        ways to create

        where stored

        written by hand

Macros submenu

MATCH( ) function

        combining with INDEX( ) function

        double lookups

math with dates and times

mathematical functions

mathematical operators

Max (Status bar shortcut)

MAX( ) function

        SUBTOTAL ( ) function codes and

MDETERM( ) function

MDURATION( ) function

MEDIAN( ) function

menus

        accidently deleting top-level

        adding new command

        attaching macros

        changing button image

        changing displayed text

        controlling whether text is displayed along with image in

        creating submenus

        quick reference

        restoring top-level 2nd

method of least squares

methods (programming

methods (programming)

        using

Microsoft Excel Help command

Microsoft Office Online 2nd

MID( ) function 2nd

Min (Status bar shortcut)

MIN( ) function

        SUBTOTAL ( ) function codes and

MINUTE( ) function

MINVERSE( ) function

MIRR( ) function

missingmanuals.com

MMULT( ) function

MOD( ) function

MODE( ) function

modulus

MONTH( ) function

months, setting

More AutoShapes (shape category)

mouse clicks, moving into cells with

Move or Copy Sheet dialog box

MROUND( ) function function

MULTINOMIAL( ) function

multiple users without workbook sharing

multiplication