Excel 97 Bible

Details

Author: Walkenbach, John

ISBN: 0-7645-3036-4

Publisher: IDG Books Worldwide, 1997, 896 pp., $34.99

Status: Available

Target Reader: This book is designed for Excel users of all levels.

Comments: This is a general purpose guide to Excel 97. It contains many examples and techniques that aren't found in any other books.

If you've had problems locating the sample files for the book, I apologize. The publisher has changed names twice since this book was published. The sample files are available at the Wiley web site. Click here.

Part I: Getting Started

Chapter 1: A Bit of Background
Chapter 2: What's New in Excel 97?
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 at the Web Site