Excel 2007 Formulas
Published on 8. February 2007
Book
Paperback/Softback
840 pages
978-0-470-04402-5 (ISBN)
Description
Create killer formulas--Mr. Spreadsheet shows you how
Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.
It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.
CD-ROM INCLUDES:
Sample files for tutorials
See the CD appendix for details and complete system requirements.
Mr. Spreadsheet's Success Techniques
Technique # 1 Master operators, error values, and absolute vs. relative references
Technique # 2 Find errors and debug formulas
Technique # 3 Use pivot tables to eliminate formulas
Technique # 4 Create single- and multi-cell array formulas
Technique # 5 Build custom functions with VBA
Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.
It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.
CD-ROM INCLUDES:
Sample files for tutorials
See the CD appendix for details and complete system requirements.
Mr. Spreadsheet's Success Techniques
Technique # 1 Master operators, error values, and absolute vs. relative references
Technique # 2 Find errors and debug formulas
Technique # 3 Use pivot tables to eliminate formulas
Technique # 4 Create single- and multi-cell array formulas
Technique # 5 Build custom functions with VBA
More details
Series
Edition
1. Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Dimensions
Height: 23.3 cm
Width: 18.7 cm
Thickness: 4.3 cm
Weight
1179 gr
ISBN-13
978-0-470-04402-5 (9780470044025)
Schweitzer Classification
Other editions
Additional editions
Person
John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2003 Power Programming with VBA, Excel Charts, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.
Content
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: Tables and Worksheet Databases.
Chapter 10: Miscellaneous Calculations.
Part III: Financial Formulas.
Chapter 11: Borrowing and Investing Formulas.
Chapter 12: Discounting and Depreciation Formulas.
Chapter 13: Financial Schedules.
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.
Part VII: Appendixes.
Appendix A: Excel Function Reference.
Appendix B: Using Custom Number Formats.
Appendix C: Additional Excel Resources.
Appendix D: What's on the CD-ROM.
Index.
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: Tables and Worksheet Databases.
Chapter 10: Miscellaneous Calculations.
Part III: Financial Formulas.
Chapter 11: Borrowing and Investing Formulas.
Chapter 12: Discounting and Depreciation Formulas.
Chapter 13: Financial Schedules.
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.
Part VII: Appendixes.
Appendix A: Excel Function Reference.
Appendix B: Using Custom Number Formats.
Appendix C: Additional Excel Resources.
Appendix D: What's on the CD-ROM.
Index.