Microsoft Excel Whiz 2002 2003

Find Formats, 34

Find Text, 34

Folders

Create a Folder, 11, 13-14

New Folder, 14

Footers, see Page Setup

Formatting

Cells, 48

Cell Content, 47

Charts, 135

Characters with the Menu, 46

Color List, 47

Font List, 46

Font Style List, 46

Size List, 46

Using the Toolbar, 46

Date and Time, 48

Pre-defined Date and Time Formats, 48

Dialog box, 48

Numbers

Number Formats, 47

Comma Style, 47

Current Style, 47

Designing Custom Number formats, 48

Percent Style, 47

Using the toolbar, 47

Worksheet Tabs, 96

Format Painter, 50-51

Formulas, 66

Creating and Editing Formulas using the Formula Bar, 7, 66-67

Edit Formulas, 70

Enter a Range within a Formula by Dragging, 69

Marquee, 69

Formula Palette, 78

Frankston, Bob, 3

Freeze and Unfreeze Rows and Columns, 94

Freeze Panes, 94

Functions, 77-80

Arguments, 85

FV, 85

Nper, 85

PMT, 85

PV, 85

Rate, 85

Autosum, 79-80, see also Autosum

AVERAGE function, 80-81

Basic, 79

Date Functions, 84-85

Entering Functions, 77

Financial functions, 85

FV, 85

PMT, 85-86

Insert Function, 77

Logical Functions, 86

IF Function, 86-87

Nested Ifs, 87

Shortcut Keys, 47

Statistical functions, 82

Maximum, 82

Median, 82

Minimum, 82

SUM function, 79-80

Future Value (FV), see Financial Functions

FV, see Financial Functions