Excel 2003 Introduction.doc

Excel 2003 Essentials

http://www.mousetraining.co.uk

                            Excel 2003 Essentials

Table of Contents

Introduction              11

How to use this guide              11

Objectives              11

Instructions              11

Appendices              11

Keyboard              11

Commands              12

Notes              12

Tips              12

Section 1              13

The Basics              13

Windows Concepts              14

Excel Basics              16

The Spreadsheet Concept              17

The Excel Screen Layout              18

Menu bar              18

Toolbars              19

Name box              19

Formula Bar              19

Worksheets              19

Status Bar              20

Task Pane              20

Use Toolbars              22

Show and hide toolbars              22

Use Menus              23

Menu Bar              23

Shortcut menus              23

Smart Tags              24

Getting Help              26

Microsoft Excel Help              26

Find a specific topic              26

Find a specific topic              27

Ask a Question Box              28

Maximise windows              29

Help              29

Section 2              31

Move around and enter information              31

Moving              32

Move with the mouse              32

Scrolling              32

Move with the keyboard              33

Moving between the Workbook sheets              34

Go To              35

Data Entry              36

Enter Text and Numbers              36

Cancel an entry              37

Edit an unconfirmed entry              37

Enter Dates              37

Recognised formats for dates              38

AutoComplete              38

Pick from list              39

Disable AutoComplete              39

Editing              41

Typing replaces selection              41

Use the Mouse to edit              41

Using the Keyboard              42

Select information              43

Select cells the mouse                            43

Select cells with the keyboard              44

Deselect a block              44

Select multiple sheets              45

Select adjacent sheets              45

Select non-adjacent sheets              45

Clear cells              46

Clear contents              46

Clear contents, formats and comments              46

The fill handle              47

Scrolling              49

Data entry              49

Select cells to limit data entry              49

Select cells for multiple entry              50

Section 3              52

Formulae and functions              52

Formulae              53

Typing Formulae              53

Entering Formulae by Pointing              54

Errors in formulae              55

Filling Formulae              56

The fill handle              56

Fill formulae using keystrokes              57

Functions              58

AutoSum              58

Other Common Functions              59

Paste Function              60

Function box              62

Type functions              63

Function Argument Tool tips              63

Cell references              64

Counting and totalling cells conditionally              64

Use SUMIF()              65

Use COUNTIF              66

Absolute and relative references              67

Relative References              67

Absolute References              67

Fill handle              70

Absolute references              70

Section 4              72

File Operations              72

File Operations              73

Save files              73

Saving changes to files              75

Close Files              75

Open Files              76

New Files              77

Close all files              78

Create Workspace files              78

Section 5              80

Moving and copying data              80

Move & Copy              81

Moving items              81

Copying items              82

Copying items              83

Drag and Drop              84

Shortcut menus              85

Moving and Copying between files              87

Using the Clipboard              87

Insert Paste              89

Moving and copying between worksheets              89

Paste Special              90

Section 6              93

Formatting              93

Formatting              94

Formatting Toolbar              94

Font              94

Point Size              95

Bold, Italic and Underline              96

Font Colour              96

Background Fill colour              97

Borders              97

Alignment              98

Merge cells              99

Indents              100

Number formats              101

Advanced Formats              103

Format Cells dialog              103

Custom Number formats              113

Formatting Columns and rows              114

Column width              115

Row height              117

Hide columns and rows              118

Insert and delete cells              120

Add cells              120

Delete cells              122

Format Painter              124

Shortcut keys for formatting              125

Format cells dialog              126

Conditional formatting              126

Example              127

Section 7              130

Names              130

Names              131

Rules when naming cells              131

Name Box              131

Define Name              132

Create names              133

Selecting names              133

Names in Formulae              134

Apply names              135

Delete names              136

Paste List              138

Intersecting names              138

Section 8              142

Working with multiple sheets              142

Multiple worksheets              143

Moving between the Workbook sheets              143

...