Excel 2010 Formulas

Excel 2010 Formulas

by John Walkenbach

Paperback

$44.99 $49.99 Save 10% Current price is $44.99, Original price is $49.99. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Wednesday, February 20

Product Details

ISBN-13: 9780470475362
Publisher: Wiley
Publication date: 05/24/2010
Series: Mr. Spreadsheet's Bookshelf Series , #7
Pages: 816
Sales rank: 843,292
Product dimensions: 7.30(w) x 9.20(h) x 1.90(d)

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Power Programming with VBA, John Walkenbach's Favorite Excel 2010 Tips & Tricks, and the Excel 2010 Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Read an Excerpt

Click to read or download

Table of Contents

Introduction 1

Part I: Basic Information

Chapter 1: Excel in a Nutshell 11

Chapter 2: Basic Facts about Formulas 39

Chapter 3: Working with Names 65

Part II: Using Functions in Your Formulas

Chapter 4: Introducing Worksheet Functions 103

Chapter 5: Manipulating Text 119

Chapter 6: Working with Dates and Times 143

Chapter 7: Counting and Summing Techniques 181

Chapter 8: Using Lookup Functions 213

Chapter 9: Tables and Worksheet Databases 235

Chapter 10: Miscellaneous Calculations 275

Part III: Financial Formulas

Chapter 11: Borrowing and Investing Formulas 293

Chapter 12: Discounting and Depreciation Formulas 317

Chapter 13: Financial Schedules 341

Part IV: Array Formulas

Chapter 14: Introducing Arrays 367

Chapter 15: Performing Magic with Array Formulas 391

Part V: Miscellaneous Formula Techniques

Chapter 16: Intentional Circular References 415

Chapter 17: Charting Techniques 429

Chapter 18: Pivot Tables 473

Chapter 19: Conditional Formatting and Data Validation 519

Chapter 20: Creating Megaformulas 555

Chapter 21: Tools and Methods for Debugging Formulas 573

Part VI: Developing Custom Worksheet Functions

Chapter 22: Introducing VBA 599

Chapter 23: Function Procedure Basics 613

Chapter 24: VBA Programming Concepts 635

Chapter 25: VBA Custom Function Examples 669

Part VII: Appendixes

Appendix A: Excel Function Reference 717

Appendix B: Using Custom Number Formats 733

Appendix C: Additional Excel Resources 753

Appendix D: What’s on the CD-ROM? 759

Index 769

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Excel 2010 Formulas 4 out of 5 based on 0 ratings. 3 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago