The Good, the Bad, and the Hungry Sale
 
 

Recently Viewed clear list


Original Essays | July 22, 2014

Nick Harkaway: IMG The Florist-Assassins



The three men lit up in my mind's eye, with footnotes. They were converging on me — and on the object I was carrying — in a way that had... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Tigerman

    Nick Harkaway 9780385352413

spacer
Qualifying orders ship free.
$44.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
5 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets

Mr. Spreadsheet's Bookshelf #3: Excel 2007 Formulas

by

Mr. Spreadsheet's Bookshelf #3: Excel 2007 Formulas Cover

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

  • Written by John Walkenbach, aka " Mr. Spreadsheet, " who is one of the world’ s leading authorities on Excel
  • Gives users the practical know-how and real-world examples they need to master formulas, which are among the trickiest Excel tools to get a handle on
  • Fully updated to cover the new Excel interface and features
  • Includes a valuable CD-ROM with templates and worksheets from the book as well as the author’ s award-winning Power Utility Pak
  • Synopsis:

    • 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 the Author

    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.

    Product Details

    ISBN:
    9780470044025
    Author:
    Walkenbach, John
    Publisher:
    Wiley
    Subject:
    Business
    Subject:
    Spreadsheets - Excel
    Subject:
    Electronic spreadsheets
    Subject:
    Business -- Computer programs.
    Subject:
    Spreadsheets - General
    Subject:
    Microsoft Excel
    Subject:
    Personal Computers-Applications
    Subject:
    Personal Computers-Desktop Applications-Spreadsheets
    Copyright:
    Edition Description:
    CD
    Series:
    Mr. Spreadsheet's Bookshelf
    Series Volume:
    3
    Publication Date:
    20081231
    Binding:
    Electronic book text in proprietary or open standard format
    Language:
    English
    Illustrations:
    Y
    Pages:
    840
    Dimensions:
    9.16x7.34x1.84 in. 2.58 lbs.

    Other books you might like

    1. World War Z: An Oral History of the...
      Used Trade Paper $6.00

    Related Subjects

    Computers and Internet » Computers Reference » General
    Computers and Internet » Operating Systems » Microsoft Windows » Applications
    Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
    Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
    Science and Mathematics » Mathematics » General

    Mr. Spreadsheet's Bookshelf #3: Excel 2007 Formulas New Trade Paper
    0 stars - 0 reviews
    $44.99 In Stock
    Product details 840 pages John Wiley & Sons - English 9780470044025 Reviews:
    "Synopsis" by ,
  • Written by John Walkenbach, aka " Mr. Spreadsheet, " who is one of the world’ s leading authorities on Excel
  • Gives users the practical know-how and real-world examples they need to master formulas, which are among the trickiest Excel tools to get a handle on
  • Fully updated to cover the new Excel interface and features
  • Includes a valuable CD-ROM with templates and worksheets from the book as well as the author’ s award-winning Power Utility Pak
  • "Synopsis" by ,
    • 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.

    spacer
    spacer
    • back to top
    Follow us on...




    Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.