Cart
Free Shipping in the UK
Proud to be B-Corp

Excel 2007 Formulas John Walkenbach

Excel 2007 Formulas By John Walkenbach

Excel 2007 Formulas by John Walkenbach


£4.50
New RRP £29.99
Condition - Very Good
Only 2 left

Summary

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.

Excel 2007 Formulas Summary

Excel 2007 Formulas by John Walkenbach

* This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere* Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else* John Walkenbach, aka "Mr. Spreadsheet," is one of the world's leading authorities on Excel* Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features* Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

About John Walkenbach

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.

Table of Contents

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.

Additional information

GOR002896869
9780470044025
0470044020
Excel 2007 Formulas by John Walkenbach
Used - Very Good
Paperback
John Wiley and Sons Ltd
2007-02-08
840
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel 2007 Formulas