Overview

Full Product Details

Author:   John Walkenbach
Publisher:   John Wiley & Sons Inc
Imprint:   Hungry Minds Inc,U.S.
Dimensions:   Width: 18.70cm , Height: 4.50cm , Length: 23.30cm
Weight:   1.232kg
ISBN:  

9780764548000

ISBN 10:   076454800
Pages:   860
Publication Date:   29 September 2001
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Out of Stock Indefinitely
Availability:   Out of stock  

Table of Contents

Preface. Acknowledgments. 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. 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. Index. End-User License Agreement. CD-ROM Installation Instructions.

Reviews

Author Information

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 www.j-walk.com/ss.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions