pdf格式,英文版,21.3MB
=============================================================
基本信息
- 出版社: JOHN WILEY & SONS INC; 1 (2010年5月24日)
- 丛书名: Mr. Spreadsheet's Bookshelf
- 平装: 788页
- 语种: 英语
- ISBN: 0470475366
- 条形码: 9780470475362
- 商品尺寸: 18.8 x 4.3 x 23.4 cm
- 商品重量: 1.2 Kg
- ASIN: 0470475366
目录
Introduction.Part I: Basic Information.
Chapter 1: Excel in a Nutshell.
Chapter 2: Basic Facts about Formulas.
Chapter 3: Working with Names.
Part II: Using Functions in Your Formulas.
Chapter 4: Introducing Worksheet Functions.
Chapter 5: Manipulating Text.
Chapter 6: Working with Dates and Times.
Chapter 7: Counting and Summing Techniques.
Chapter 8: Using Lookup Functions.
Chapter 9: Tables and Worksheet Databases.
Chapter 10: Miscellaneous Calculations.
Part III: Financial Formulas.
Chapter 11: Borrowing and Investing Formulas.
Chapter 12: Discounting and Depreciation Formulas.
Chapter 13: Financial Schedules.
Part IV: Array Formulas.
Chapter 14: Introducing Arrays.
Chapter 15: Performing Magic with Array Formulas.
Part V: Miscellaneous Formula Techniques.
Chapter 16: Intentional Circular References.
Chapter 17: Charting Techniques.
Chapter 18: Pivot Tables.
Chapter 19: Conditional Formatting and Data Validation.
Chapter 20: Creating Megaformulas.
Chapter 21: Tools and Methods for Debugging Formulas.
Part VI: Developing Custom Worksheet Functions.
Chapter 22: Introducing VBA.
Chapter 23: Function Procedure Basics.
Chapter 24: VBA Programming Concepts.
Chapter 25: VBA Custom Function Examples.
Part VII: Appendixes.
Appendix A: Excel Function Reference.
Appendix B: Using Custom Number Formats.
Appendix C: Additional Excel Resources.
Appendix D: What’s on the CD-ROM?
Index.
=====================================================================