Harriman House | Business Books | Politicos | Financial Conferences | Glossary | Investor Education | Derivatives | Financial Gurus | Spread Betting Central |

Home |  Search |  shopping basket Shopping basket
Tel: +44 (0)1730 233870    Email: bookshop@holbornbooks.co.uk  
Categories

Excel 2002 Formulas by John Walkenbach
Usually ships within 1 to 3 working days

    • Product code: 20549
    • ISBN: 0764547992, ISBN13: 9780764547997, 860 pages, paperback
      Published by John Wiley & Sons, 2002 edition, 2001
    Rate this book...

    Rating: 0.0/5 (0 votes cast)

    Description of Excel 2002 Formulas

    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.

    Contents of Excel 2002 Formulas

    Preface
    Acknowledgments


    PART I: Basic Information
    1. Excel in a Nutshell
    2. Basic Facts about Formulas
    3. Working with Names


    PART II: Using Functions in Your Formulas
    4. Introducing Worksheet Functions
    5. Manipulating Text
    6. Working with Dates and Times
    7. Counting and Summing Techniques
    8. Lookups
    9. Databases and Lists
    10. Miscellaneous Calculations


    PART III: Financial Formulas

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


    PART IV: Array Formulas
    14. Introducing Arrays
    15. Performing Magic with Array Formulas


    PART V: Miscellaneous Formula Techniques
    16. Intentional Circular References
    17. Charting Techniques
    18. Pivot Tables
    19. Conditional Formatting and Data Validation
    20. Creating Megaformulas
    21. Tools and Methods for Debugging Formulas


    PART VI: Developing Custom Worksheet Functions
    22. Introducing VBA
    23. Function Procedure Basics
    24. VBA Programming Concepts
    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

    About John Walkenbach

    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.
    See other products on
    Bulk buying
    If you need bulk copies of Excel 2002 Formulas, or are interested in opening a corporate account, please contact us.
    View a print friendly version of this page