Excel 2003 Bible

John's Excel books

Details

Author: Walkenbach, John

ISBN: 0764539671

Publisher: John Wiley & Sons., 2003, 897 pp., List price $39.95 (US).

CD-ROM: Yes

Status: Available

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

Comments: This book is a significant revision of the Excel 2002 Bible. In fact, it's the best edition to date.

Note: On the companion CD-ROM, one of the files listed for Chapter 10 does not work. The xdate.exe file was not transferred completely. However, you can download that file here.

Part I: Getting Started With Excel

Chapter 1: Introducing Excel
Chapter 2: Entering and Editing Worksheet Data
Chapter 3: Essential Worksheet Operations
Chapter 4: Working with Cells and Ranges
Chapter 5: Worksheet Formatting
Chapter 6: Understanding Files and Templates
Chapter 7: Printing Your Work

Part II: Working with Formulas and Functions

Chapter 8: Introducing Formulas and Functions
Chapter 9: Creating Formulas to Manipulate Text
Chapter 10: Working with Dates and Times
Chapter 11: Creating Formulas That Count and Sum
Chapter 12: Creating Formulas that Look Up Values
Chapter 13: Creating Formulas For Financial Applications
Chapter 14: Introducing Array Formulas
Chapter 15: Performing Magic With Array Formulas

Part III: Creating Charts and Graphics

Chapter 16: Getting Started Making Charts

Chapter 17: Learning Advanced Charting
Chapter 18: Enhancing Your Work With Pictures and Drawings

Part IV: Analyzing Data With Excel

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 Seek and Solver
Chapter 24: Analyzing Data with Analysis ToolPak

Part V: Using Advanced Excel Features

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

Part VI: Programming Excel with VBA

Chapter 34: Introducing Visual Basic For Applications
Chapter 35: Creating Custom Worksheet Functions
Chapter 36: Creating UserForms
Chapter 37: Using UserForm Controls in a Worksheet
Chapter 38: Working with Excel Events
Chapter 39: VBA Examples
Chapter 40: Creating Custom Excel Add-Ins

Appendixes

Appendix A: Worksheet Function Reference
Appendix B: What's on the CD-ROM
Appendix C: Just For Fun
Appendix D: Additional Excel Resources
Appendix E: Excel Shortcut Keys