
- 作 者:(美)Stephen L.Nelson著;方中译
- 出 版 社:北京:清华大学出版社
- 出版年份:1994
- ISBN:7302017433
- 标注页数:175 页
- PDF页数:192 页
请阅读订购服务说明与试读!
订购服务说明
1、本站所有的书默认都是PDF格式,该格式图书只能阅读和打印,不能再次编辑。
2、除分上下册或者多册的情况下,一般PDF页数一定要大于标注页数才建议下单购买。【本资源192 ≥175页】
图书下载及付费说明
1、所有的电子图书为PDF格式,支持电脑、手机、平板等各类电子设备阅读;可以任意拷贝文件到不同的阅读设备里进行阅读。
2、电子图书在提交订单后一般半小时内处理完成,最晚48小时内处理完成。(非工作日购买会延迟)
3、所有的电子图书都是原书直接扫描方式制作而成。
索引 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