Excel 2002 Formulas

Excel 2002 Formulas

3.68 (16 ratings by Goodreads)
By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

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

Try AbeBooks

Description

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

Product details

  • CD-ROM | 860 pages
  • 187.96 x 233.68 x 48.26mm | 1,292.73g
  • John Wiley & Sons Inc
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 076454800X
  • 9780764548000
  • 2,210,545

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

Back cover copy

Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, 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-so-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. Your Road Map to High-Performance Excel Formulas
* Get a concise overview of Excel's many features, including cell formatting, analysis tools, and protection options
* Master basic formula facts - including absolute vs. relative references, operators, error values, naming techniques, and more
* Get practical tips on using Excel's worksheet functions in your formulas
* Find expanded coverage of discounting, depreciation, and other financial formulas
* Perform magic with powerful array formulas
* Use your formulas to enhance charts and pivot tables
* Debug formulas and take advantage of Excel's auditing tools
* Develop custom worksheet functions with VBA
Bonus CD-ROM Includes
* A trial version of the author's award-winning Power Utility Pak 2000
* A demo of the author's Sound-Proof 2000
* Example Excel workbooks from the book
System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com
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: 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.
show more

Rating details

16 ratings
3.68 out of 5 stars
5 12% (2)
4 56% (9)
3 19% (3)
2 12% (2)
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