• Excel 2007 Formulas See large image

    Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) (Paperback) By (author) John Walkenbach

    Hard to find title available from Book Depository

    $33.81 - Save $14.83 30% off - RRP $48.64 Free delivery worldwide Available
    Dispatched in 4 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    Description* 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.

Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10


Reviews | Bibliographic data
  • Full bibliographic data for Excel 2007 Formulas

    Excel 2007 Formulas
    Authors and contributors
    By (author) John Walkenbach
    Physical properties
    Format: Paperback
    Number of pages: 840
    Width: 187 mm
    Height: 234 mm
    Thickness: 46 mm
    Weight: 1,265 g
    ISBN 13: 9780470044025
    ISBN 10: 0470044020

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 01
    B&T Modifier: Subject Development: 10
    B&T Modifier: Text Format: 01
    LC subject heading:
    BIC subject category V2: UFC
    B&T Merchandise Category: COM
    DC22: 005.54
    LC subject heading: ,
    Warengruppen-Systematik des deutschen Buchhandels: 26350
    BISAC V2.8: COM054000
    Ingram Subject Code: XW
    B&T General Subject: 230
    LC subject heading:
    LC classification: HF5548.4.M523 W344857 2007
    LC subject heading:
    John Wiley and Sons Ltd
    Imprint name
    John Wiley & Sons Ltd
    Publication date
    08 February 2007
    Publication City/Country
    Author Information
    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.
    Back cover copy
    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 tutorialsSee the CD appendix for details and complete system requirements.Mr. Spreadsheet's Success TechniquesTechnique # 1 Master operators, error values, and absolute vs. relative referencesTechnique # 2 Find errors and debug formulasTechnique # 3 Use pivot tables to eliminate formulasTechnique # 4 Create single- and multi-cell array formulasTechnique # 5 Build custom functions with VBA
    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.