Excel 2010 Formulas

Name: Excel 2010 Formulas
Price: 3.89 USD
Availability: InStock
ISBN: 9780470475362

ISBN-10: 0470475366

ISBN-13: 9780470475362

Edition: 2010

Authors: John Walkenbach

List price: $82.95

30 day, 100% satisfaction guarantee!

Buy new: $32.45

Marketplace

4 new & used from $3.89

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Take your Excel formulas to the next level with this updated referenceJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more…

Book details

List price: $82.95
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 5/7/2010
Pages: 816
Size: 7.40" wide x 9.20" long x 1.90" tall
Weight: 2.640
Language: English



Introduction



Basic Information



Excel in a Nutshell



Basic Facts about Formulas



Working with Names



Using Functions in Your Formulas



Introducing Worksheet Functions



Manipulating Text



Working with Dates and Times



Counting and Summing Techniques



Using Lookup Functions



Tables and Worksheet Databases



Miscellaneous Calculations



Financial Formulas



Borrowing and Investing Formulas



Discounting and Depreciation Formulas



Financial Schedules



Array Formulas



Introducing Arrays



Performing Magic with Array Formulas



Miscellaneous Formula Techniques



Intentional Circular References



Charting Techniques



Pivot Tables



Conditional Formatting and Data Validation



Creating Megaformulas



Tools and Methods for Debugging Formulas



Developing Custom Worksheet Functions



Introducing VBA



Function Procedure Basics



VBA Programming Concepts



VBA Custom Function Examples



Appendixes



Excel Function Reference



Using Custom Number Formats



Additional Excel Resources



What's on the CD-ROM?


Index