Details
Author: Walkenbach, John
ISBN: 0-7645-3259-6
Publisher: IDG Books Worldwide, 1999, 936 pp., List price $39.99
Includes: CD-ROM
Status: Available
Target Reader: This book is designed for Excel users of all levels.
Comments: This is a general purpose guide to Excel 2000. It contains many examples and techniques that aren't found in any other books.
Table of Contents
Part I: Getting Started
- Chapter 1: A Bit of Background
- Chapter 2: What's New in Excel 2000?
- Chapter 3: Getting Acquainted with Excel
Part II: Introductory Concepts
- Chapter 4: Navigating Through Excel
- Chapter 5: Working With Files and Workbooks
- Chapter 6: Entering and Editing Worksheet Data
- Chapter 7: Essential Spreadsheet Operations
- Chapter 8: Working with Cells and Ranges
- Chapter 9: Creating and Using Formulas
- Chapter 10: Using Worksheet Functions
- Chapter 11: Worksheet Formatting
- Chapter 12: Printing Your Work
- Chapter 13: Chart-Making Basics
- Chapter 14: Enhancing Your Work With Pictures and Drawings
- Chapter 15: Putting it All Together
Part III: Advanced Features
- Chapter 16: Advanced Charting
- Chapter 17: Creating Maps with Microsoft Map
- Chapter 18: Creating and Using Worksheet Outlines
- Chapter 19: Linking and Consolidating Worksheets
- Chapter 20: Creating and Using Array Formulas
- Chapter 21: Using Excel in a Workgroup
Part IV: Analyzing Data
- Chapter 22: Using Data From Other Sources
- Chapter 23: Working With Lists
- Chapter 24: Using External Database Files
- Chapter 25: Analyzing Data with Pivot Tables
- Chapter 26: Performing Spreadsheet What-If Analysis
- Chapter 27: Analyzing Data Using Goal Seeking and Solver
- Chapter 28: Analyzing Data with the Analysis ToolPak
Part V: Other Topics
- Chapter 29: Sharing Data With Other Applications
- Chapter 30: Excel and the Internet
- Chapter 31: Making Your Worksheets Error-Free
- Chapter 32: Fun Stuff
Part VI: Customizing Excel
- Chapter 33: Customizing Toolbars and Menus
- Chapter 34: Using and Creating Templates
- Chapter 35: Using Visual Basic for Applications (VBA)
- Chapter 36: Creating Custom Worksheet Functions
- Chapter 37: Creating Custom Dialog Boxes
- Chapter 38: Using Dialog Box Controls in Your Worksheet
- Chapter 39: Creating User-Oriented Applications
- Chapter 40: Creating Custom Excel Add-Ins
Appendixes
- Appendix A: Using On-Line Help: A Primer
- Appendix B: Worksheet Function Reference
- Appendix C: Excel's Shortcut Keys
- Appendix D: What's on the CD-ROM