看了几本教程 感觉这几本不错 发上来给大家下载
资料不好找, 如果大家喜欢, 请回帖,谢谢!
TABLE OF CONTENTS
CHAPTER 1: GETTING STARTED . . . . . . . . . . . . . . . . . . . . .2
Introduction to Data Analysis with Excel ..............................................................2
Understanding the Excel Window..........................................................................3
Enter Data ............................................................................................................4
Format Numbers....................................................................................................6
Format Cells ........................................................................................................10
Select Data ..........................................................................................................14
Copy, Cut, and Paste Cells....................................................................................16
Copy with the Office Clipboard ............................................................................18
Insert and Delete Cells ........................................................................................20
Find and Replace ................................................................................................22
Find and Replace Formats ..................................................................................24
CHAPTER 2: CREATING FORMULAS . . . . . . . . . . . . . . . . .26
Understanding Formulas ....................................................................................26
Create Formulas ..................................................................................................28
Edit Formulas ......................................................................................................30
Name Cells and Ranges ......................................................................................32
Define and Display Constants ..............................................................................34
Create Formulas that Include Names....................................................................36
Check Formulas for Errors ..................................................................................38
Trace Precedents and Dependents ........................................................................40
CHAPTER 3: CREATING AND USING FUNCTIONS . . . . . .42
Understanding the Function Wizard ....................................................................42
Round a Number ................................................................................................44
Determine the Nth Largest Value ........................................................................46
Create a Conditional Formula ..............................................................................48
Calculate a Conditional Sum ................................................................................50
Calculate Products and Square Roots ..................................................................52
Look Up Information ..........................................................................................54
Determine the Location of a Value ......................................................................56
Perform Time Calculations ..................................................................................58
Perform Date Calculations....................................................................................6
。。。。。。。。。。。
版主:coral033
第一个文件重复,论坛币退还。