Microsoft Excel 2000 Formulas

Microsoft Excel 2000 Formulas

4.04 (21 ratings by Goodreads)
By (author)  , By (author) 

List price: US$44.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

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.show more

Product details

  • CD-ROM | 792 pages
  • 177.8 x 223.52 x 45.72mm | 1,111.3g
  • John Wiley & Sons Inc
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 0764546090
  • 9780764546099
  • 1,795,787

About John Walkenbach

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.show more

Table of contents

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.show more

Rating details

21 ratings
4.04 out of 5 stars
5 33% (7)
4 43% (9)
3 19% (4)
2 5% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X