我自己写的,第一稿,二十多页,熟练的同学可以参考一下
Table of Contents
Introduction 1
OR / OM 1
A Brief History of Electric Spreadsheet 2
Spreadsheets / Database 2
What on Earth Are Spreadsheets? 2
Web-Based Spreadsheets 3
I/O and Display 3
A1 / R1C1 Style Formulas 3
Relative / Absolute / Mixed Reference 3
Name 5
List 6
Sort 7
Filter / Advanced Filter 7
Validation 9
Conditional Formatting 9
Go To 10
Import External Data 10
Protection 11
Analysis Tools 11
Scenarios 11
(Data) Table 12
Goal Seek 12
Solver 13
Formula and Function 14
Array Formulas 14
Subtotals 14
Conditional Sum 15
PivotTable / PivotChart 15
Chart 16
Forms / Control Toolbox 17
Data Analysis (Analysis ToolPak) 18
Add-Ins 18
Spreadsheet Practice 18
Data Refinement 18
Simulation 18
Statistical Flaws in Excel 18
Danger, Will Robinson! 19
End-user Model / Custom Tool 19
Interface 20
Usability 20
Challenges 21
Spreadsheet Development 22
Component Object Model 22
Excel Object Model 22
Excel VBA Power 23
Visual Studio Tools for Office 24
Windows API 24
Recommended Reading Materials 24
Beginner 24
Intermediate 24
Advanced 25


雷达卡


京公网安备 11010802022788号







