Cover image for Excel 2002 formulas
Excel 2002 formulas
Walkenbach, John.
Personal Author:
Publication Information:
New York, NY : M&T Books, [2001]

Physical Description:
xxxvi, 828 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.).
General Note:
Accompanying CD-ROM includes chapter examples from Excel workbooks discussed in the book, a trial version of the author's Power Utility Pak 2000, a demo version of the author's Sound-Proof 2000, and the latest version of Acrobat Reader from Adobe.

Includes index.
Format :


Call Number
Material Type
Home Location
Item Holds
HF5548.4.M523 W34474 2001 Book and Software Set Central Closed Stacks

On Order



Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications. This book answers virtually all formula-related questions posed in Excel newsgroups on the Internet. Plus, it contains a coupon for Walkenbach's Professional Power Utility Pak.

Author Notes

John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at

Table of Contents

Part I Basic Information
Chapter 1 Excel in a Nutshell
Chapter 2 Basic Facts about Formulas
Chapter 3 Working with Names
Part II Using Functions in Your Formulas
Chapter 4 Introducing Worksheet Functions
Chapter 5 Manipulating Text
Chapter 6 Working with Dates and Times
Chapter 7 Counting and Summing Techniques
Chapter 8 Lookups
Chapter 9 Databases and Lists
Chapter 10 Miscellaneous Calculations
Part III Financial Formulas
Chapter 11 Introducing Financial Formulas
Chapter 12 Discounting and Depreciation Financial Functions
Chapter 13 Advanced Uses of Financial Functions and Formulas
Part IV Array Formulas
Chapter 14 Introducing Arrays
Chapter 15 Performing Magic with Array Formulas
Part V Miscellaneous Formula Techniques
Chapter 16 Intentional Circular References
Chapter 17 Charting Techniques
Chapter 18 Pivot Tables
Chapter 19 Conditional Formatting and Data Validation
Chapter 20 Creating Megaformulas
Chapter 21 Tools and Methods for Debugging Formulas
Part VI Developing Custom Worksheet Functions
Chapter 22 Introducing VBA
Chapter 23 Function Procedure Basics
Chapter 24 VBA Programming Concepts
Chapter 25 VBA Custom Function Examples
Appendix A Working with Imported 1-2-3 Files
Appendix B Excel Function Reference
Appendix C Using Custom Number Formats
Appendix D Additional Excel Resources
Appendix E What's on the CD-ROM
End-User License Agreement
CD-ROM Installation Instructions