Excel 2002 Bible

John's Excel books

Details

Author: Walkenbach, John and Underdahl, Brian

ISBN: 0764535838

Publisher: Hungry Minds Inc., 2001, 912 pp., List price $39.95 (US).

CD-ROM: No

Status: Available

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

Comments: This book is derived from the Excel 2000 Bible Gold Edition, but does not contain as much content.

The publisher hired another author to write the revision (John Walkenbach had nothing to do with it). You may find that this book is lacking in specific Excel 2002 content, and it does not contain a CD-ROM. So if you're looking for the ultimate Excel 2002 book, you may want to keep looking. Sorry! That's the way the computer book industry works.

Quick Start: Getting Acquainted With Excel

Part I: Getting Started With Excel

Chapter 1: Entering and Editing Worksheet Data
Chapter 2: Essential Spreadsheet Operations
Chapter 3: Printing Your Work
Chapter 4: Working with Cell Ranges
Chapter 5: Worksheet Formatting
Chapter 6: Using and Creating Templates

Part II: Working with Formulas and Functions

Chapter 7: Creating and Using Formulas
Chapter 8: Using Worksheet Functions
Chapter 9: Using Functions and Formulas to Manipulate Text
Chapter 10: Working with Dates, Times, and Related Functions
Chapter 11: Creating Formulas That Count and Sum
Chapter 12: Creating Formulas that Look Up Values

Part III: Enhancing Your Excel Workbooks

Chapter 13: Getting Started Making Charts
Chapter 14: Learning Some Advanced Charting
Chapter 15: Enhancing Your Work with Pictures and Drawings
Chapter 16: Introducing Arrays

Chapter 17: Performing Magic with Array Formulas

Part IV: Analyzing Data With Excel

Chapter 18: Importing Data From Other Sources
Chapter 19: Working with Lists
Chapter 20: Using External Database Files
Chapter 21: Analyzing Data with Pivot Tables
Chapter 22: Performing Spreadsheet What-If Analysis

Chapter 23: Analyzing Data Using Goal-Seeking and Solver
Chapter 24: Analyzing Data with Analysis ToolPak

Part V: Using Advanced Excel Features

Chapter 25: Creating and using Worksheet Outlines
Chapter 26: Linking and Consolidating Worksheets
Chapter 27: Customizing Toolbars and Menus
Chapter 28: Excel and the Internet
Chapter 29: Using Excel in a Workgroup
Chapter 30: Sharing Data With Other Applications
Chapter 31: Making Your Worksheets Error-Free

Part VI: Programming Excel 2000 with VBA

Chapter 32: Introducing Visual Basic for Applications
Chapter 33: VBA Programming Fundamentals
Chapter 34: Working With VBA Sub Procedures
Chapter 35: Creating Custom Worksheet Functions
Chapter 36: Introducing UserForms
Chapter 37: UserForm Techniques
Chapter 38: Working with Excel’s Events
Chapter 39: Creating Custom Excel Add-Ins
Chapter 40: Creating Custom Toolbars
Chapter 41: Creating Custom Menus

Appendix

Worksheet Function Reference