Overview

* Part of the bestselling Power Pack family of technical guides, this book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools * Helps the reader master basic formula facts, including absolute vs. relative references, operators, error values, naming techniques, and more * Offers practical tips on using Excel's worksheet functions in formulas, using formulas to enhance charts and pivot tables, developing custom worksheet functions with VBA, using powerful array formulas, and debugging * Written by one of the leading authorities on spreadsheet programs who also maintains the popular online Spreadsheet Page * CD--ROM includes more than ninety example workbooks that illustrate key concepts for the book, as well as the author's award--winning Power Utility Pak

Full Product Details

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

9780764540738

ISBN 10:   0764540734
Pages:   864
Publication Date:   17 October 2003
Audience:   College/higher education ,  General/trade ,  Tertiary & Higher Education ,  General
Format:   Paperback
Publisher's Status:   Out of Stock Indefinitely
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited 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: 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 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.Index.End-User License Agreement.

Reviews

Author Information

John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows, and maintains the popular Spreadsheet Page 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