Excel 2007 Formulas

Name: Excel 2007 Formulas
Price: 5.58 USD
Availability: InStock
ISBN: 9780470044025

ISBN-10: 0470044020

ISBN-13: 9780470044025

Edition: 2007

Authors: John Walkenbach

List price: $44.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $5.58

what's this?

Rush Rewards U
Members Receive:

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

Description:

Excel is the standard among spreadsheet applications and is an indispensable tool in the business community. This book helps readers master the basic formula facts, including absolute and relative references, operators, error values, naming techniques, and more.

Book details

List price: $44.99
Copyright year: 2007
Publisher: John Wiley & Sons, Incorporated
Publication date: 2/12/2007
Binding: Paperback
Pages: 840
Size: 7.50" wide x 9.25" long x 2.00" tall
Weight: 2.838
Language: English




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