Excel5 for Windows简明手册PDF电子书下载

索引 1

环境 1

目录 1

简介 3

Excel A至Z 13

A 14

Absolute Cell Address 14

Active Cell 14

Active and Inactive Windows 15

Active Sheet 15

Adding Styles 16

Aligning Labels and Values 16

Application Windows 18

Applying Styles 18

ANSI Character 18

Argument 19

Array 20

Array Formulas 20

ASCII Character 21

ASCII Text Files 22

Auditing Worksheets 22

AutoFormatting Tables 23

AutoSave 24

AutoSum 25

B 26

Bold Characters 26

Boolean Algebra 26

Borders 27

Cell Address 28

Calculating Formulas 28

C 28

Cell Pointer 29

Cell Protection 29

Cell Reference 31

Cell Selector 31

Changing Fonts 31

Chart 32

Chart Colors 32

Chart Gridlines 33

Chart Legends 34

Chart Page Setup 34

Chart Sheets 35

Chart Text 36

Chart Titles 36

Chart Types 37

ChartWizard 39

Clip Art 42

Closing Workbooks 43

Color 43

Coloring Worksheet Ranges 44

Coloring Worksheet Text 44

Columns 44

Conditional Functions 45

Converting Formulas into Numbers 45

Copying 46

Copying Cell Formats 46

Copying Data 47

Copying Formulas 47

Copying Ranges 49

Copying Objects and Pictures 49

Creating Lists 50

Currency Symbols 51

Custom Filtering 52

D 52

Data Categories 52

Data Markers 52

Data Series 53

Data Format 53

Date and Time Functions 54

Date Values 54

Default Directory 55

Default Fonts 55

Deleting 56

Deleting Cells 56

Default Workbooks 56

Deleting Columns and Rows 57

Deleting Sheets 57

Delimited Text Files 57

Dependents 57

Dialog Box 58

Document Windows 58

Drag-and-Drop 58

Drawing 59

E 59

Editing Cell Contents 59

Editing Embedded Charts 60

Editing Lists 60

Embedding and Linking Existing Objects 61

Entering Data 62

Embedding New Objects 62

Erasing Cells 63

Erasing Workbooks 64

Error Message 64

Exiting Excel 65

Exporting 65

F 65

File Names 65

File Summary 66

Filling Cells 66

Fill Series 67

Filtering Lists 68

Financial Functions 71

Finding Cells 71

Fonts 72

Finding Files 72

Footers 73

Formatting 73

Formatting Numbers 74

Formula Bar 75

Formulas 75

Fractions 76

Full Screen 77

Functions 77

Function Wizard 78

G 79

Goal Seek 79

Go To 80

Groups 81

Gridlines 81

Headers and Footers 82

Help 82

H 82

Hiding and Unhiding Sheets 83

I 83

Importing Spreadsheet Files 83

Importing Text Files 83

Inserting 86

Inserting Cells 86

Inserting Columns 87

Inserting Rows 88

Inserting Worksheets 88

List Management 89

Lookup Function 89

L 89

Labels 89

Italic Characters 89

Lotus 1-2-3 90

Lotus Improv 90

M 90

Macro 90

Margins 91

Math Functions 91

Microsoft Word 91

Moving and Copying Sheets 92

Moving Data 92

Moving Objects and Pictures 93

Naming Sheets 94

Names 94

N 94

New Workbooks 95

Notes 95

O 96

Object Linking and Embedding 96

Opening Workbooks 97

P 98

Page Breaks 98

Page Numbers 98

Page Setup 98

Passwords 99

Patterns 99

Pagination 99

Page Tab 99

Percentages 100

Picture Charts 100

PivotTables 101

Points 104

Precedents 104

Printed Pages Setup 104

Printing 105

Print Preview 106

Q 107

Quattro Pro 107

R 107

Range Address 107

Relative Cell Address 107

Replacing Cell Contents 108

Repeat 108

Removing Styles 108

Reports 109

Resizing Pictures 110

Rows 111

S 111

Save Options 111

Saving Workbooks 112

Scenarios 113

Scientific Notation 113

Scrolling 114

Searching Lists 115

Selecting Cell 116

Selecting Columns 116

Selecting Rows 116

Sheet Page Setup 117

Sharing Microsoft Excel Data 117

Sheets 118

Shortcut Menus 118

Solver 118

Sorting Lists 119

Spelling 119

Starting Excel 121

Statistics Functions 122

Styles 122

Subtotaling Lists 122

Switching Tasks 124

T 125

Text Boxes 125

Text String Formulas 126

Text Functions 126

Time Formats 127

Time Values 128

TipWizard 128

Toolbars 129

TrueType 130

U 130

Underline Characters 130

Undo 130

V 130

Values 130

W 131

What-if Tables 131

Visual Basic 131

Views 131

Window Command Buttons 133

Window Control-menu Commands 134

Window Panes 136

Workbook Functions 137

Workbooks 137

Worksheet Pictures 137

Worksheets 138

Worksheet Titles 139

Worksheet View 139

Workspace 139

Z 140

Zooming 140

释疑 141

速查参考 157