Excel 2003 Formulas

Details

Author: Walkenbach, John

ISBN: 0764540734

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

Includes: CD-ROM

Status: Available

Target Reader: This book is intended for intermediate to advanced Excel users who want to learn more about creating effective formulas of all types.

Comments: This is a revision of the best-selling Excel 2002 Formulas, updated for Excel 2003. If you currently own the 2002 edition, there is probably not enough new material to warrant purchasing this edition. The CD-ROM includes an electronic version of the book.

NOTE:
This book was supposed to contain a coupon for a $30 discount for Power Utility Pak. Unfortunately, the coupon was omitted from the book. If you've purchased this book, click here to learn how to receive your $30 discount.

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. Using Lookup Functions
Chapter 9. Databases and Lists
Chapter 10. Miscellaneous Calculations

Part III: Financial Formulas

Chapter 11. Introducing Financial Formulas
Chapter 12. Discounting and Depreciation Financial Formulas
Chapter 13. Advanced Uses of Financial Formulas and Functions

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

Appendixes

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