Details
Author: Walkenbach, John
ISBN: 0764534491
Publisher: IDG Books Worldwide, 2000, ~1,300 pp., List price $50.99 (US).
Includes: CD-ROM
Status: Available
Target Reader: This book is designed for Excel users of all levels.
Comments: This is a greatly expanded edition of the Excel 2000 Bible. It contains lots of additional material on advanced formulas and VBA macros. The additional material is adapted from two other books: Excel 2000 Power Programming With VBA and Excel 2000 Formulas.
Table of Contents
Part 1: Getting Started
- Chapter 1: What’s New in Excel 2000?
- Chapter 2: Getting Acquainted with Excel
- Chapter 3: Navigating Through Excel
- Chapter 4: Working with Files and Workbooks
Part II: Working with Excel
- Chapter 5: Entering and Editing Worksheet Data
- Chapter 6: Essential Spreadsheet Operations
- Chapter 7: Working with Cell Ranges
- Chapter 8: Creating and Using Formulas
- Chapter 9: Using Worksheet Functions
- Chapter 10: Manipulating Text
- Chapter 11: Working with Dates and Times
- Chapter 12: Counting and Summing Formulas
- Chapter 13: Lookup Formulas
- Chapter 14: Printing Your Work
- Chapter 15: Customizing Toolbars and Menus
- Chapter 16: Using and Creating Templates
Part III: Adding Visual Elements
- Chapter 17: Worksheet Formatting
- Chapter 18: Chart-Making Basics
- Chapter 19: Advanced Charting
- Chapter 20: Enhancing Your Work with Pictures and Drawings
- Chapter 21: Creating Maps with Microsoft Map
- Chapter 22: Putting it All Together
Part IV: Advanced Excel Features
- Chapter 23: Creating and Using Worksheet Outlines
- Chapter 24: Linking and Consolidating Worksheets
- Chapter 25: Introducing Arrays
- Chapter 26: Performing Magic with Array Formulas
- Chapter 27: Using Excel in a Workgroup
- Chapter 28: Sharing Data with Other Applications
- Chapter 29: Excel 2000 on the Web
- Chapter 30: Making Your Worksheets Error-Free
- Chapter 31: Less Productive Uses for Excel 2000
Part V: Analyzing Data with Excel
- Chapter 32: Importing Data from Other Sources
- Chapter 33: Working with Lists
- Chapter 34: Using External Database Files
- Chapter 35: Analyzing Data with Pivot Tables
- Chapter 36: Performing Spreadsheet What-If Analysis
- Chapter 37: Analyzing Data Using Goal-Seeking and Solver
- Chapter 38: Analyzing Data with Analysis ToolPak
Part VI: Programming Excel 2000 with VBA
- Chapter 39: Essentials of Spreadsheet Application Development
- Chapter 40: Introducing VBA
- Chapter 41: VBA Programming Fundamentals
- Chapter 42: Working With VBA Sub Procedures
- Chapter 43: Creating Custom Worksheet Functions
- Chapter 44: Introducing UserForms
- Chapter 45: UserForm Examples
- Chapter 46: Understanding Excel’s Events
- Chapter 47: Interacting with Other Applications
- Chapter 48: Creating Custom Excel Add-Ins
- Chapter 49: Creating Custom Toolbars
- Chapter 50: Creating Custom Menus
- Chapter 51: Providing Help for Your Applications
Appendices
- Appendix A: Using Online Help: A Primer
- Appendix B: Excel Resources on the Internet
- Appendix C: Worksheet Function Reference
- Appendix D: Importing 1-2-3 Formulas
- Appendix E: Excel’s Shortcut Keys
- Appendix F: VBA Statements and Function Reference
- Appendix G: VBA Error Codes
- Appendix H: ANSI Code Reference
- Appendix I: What’s on the CD-ROM?