• Author:
  • Walkenbach, John
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  22/10/1999
• Price:
  $67.99
• <  Buy this book  >

This one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-to-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets -- and make the most of Excel.

John Walkenbach is one of the country's leading authorities on spreadsheet software. He's principal of JWalk & Associates Inc., a Southern California-based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the Power Utility Pak add-in for Excel. John has written more than 250 articles and reviews for publications such as PC World, InfoWorld, Windows, and PC/Computing. In addition, he's authored more than 20 other spreadsheet books, including Microsoft Excel 2000 Bible, Excel 2000 For Windows For Dummies Quick Reference, and Excel 2000 Programming For Dummies. He also maintains the Spreadsheet Page on the World Wide Web (j-walk.com). When he's not banging away on his computer keyboard, he's probably banging away on one of his guitars, trying to cop a few blues licks from Freddie King.

Preface.

Acknowledgments.

PART I: Basic Information.

Chapter 1: Excel in a Nutshell.

Chapter 2: Basic Facts About Formulas.

Chapter 3: Using 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 Techniques.

Chapter 8: Lookups.

Chapter 9: Databases and Lists.

Chapter 10: Financial Calculations.

Chapter 11: Miscellaneous Calculations.

PART III: Array Formulas.

Chapter 12: Introducing Arrays.

Chapter 13: Performing Magic with Array Formulas.

PART IV: Miscellaneous Formula Techniques.

Chapter 14: Intentional Circular References.

Chapter 15: Charting Techniques.

Chapter 16: Pivot Tables.

Chapter 17: Conditional Formatting and Data Validation.

Chapter 18: Creating Megaformulas.

Chapter 19: Tools and Methods for Debugging Formulas.

PART V: Developing Custom Worksheet Functions.

Chapter 20: Introducing VBA.

Chapter 21: Function Procedure Basics.

Chapter 22: VBA Programming Concepts.

Chapter 23: VBA Function Examples.

Appendix A: Working with Imported 1-2-3 Files.

Appendix B: Excel's Function Reference.

Appendix C: 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.