Excel 2002 Formulas - Softcover

Walkenbach, John

Softcover

ISBN 10: 076454800X ISBN 13: 9780764548000

Verlag: John Wiley & Sons, 2001

Inhaltsangabe

Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications. This book answers virtually all formula-related questions posed in Excel newsgroups on the Internet. Plus, it contains a coupon for Walkenbach's Professional Power Utility Pak.

Über diesen Titel

Über die Autorin bzw. den Autor

John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.

Von der hinteren Coverseite

Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, this one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-so-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets - and make the most of Excel. Your Road Map to High-Performance Excel Formulas
* Get a concise overview of Excel's many features, including cell formatting, analysis tools, and protection options
* Master basic formula facts - including absolute vs. relative references, operators, error values, naming techniques, and more
* Get practical tips on using Excel's worksheet functions in your formulas
* Find expanded coverage of discounting, depreciation, and other financial formulas
* Perform magic with powerful array formulas
* Use your formulas to enhance charts and pivot tables
* Debug formulas and take advantage of Excel's auditing tools
* Develop custom worksheet functions with VBA
Bonus CD-ROM Includes
* A trial version of the author's award-winning Power Utility Pak 2000
* A demo of the author's Sound-Proof 2000
* Example Excel workbooks from the book
System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com

Aus dem Klappentext

Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, this one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-so-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets - and make the most of Excel. Your Road Map to High-Performance Excel Formulas * Get a concise overview of Excel's many features, including cell formatting, analysis tools, and protection options * Master basic formula facts - including absolute vs. relative references, operators, error values, naming techniques, and more * Get practical tips on using Excel's worksheet functions in your formulas * Find expanded coverage of discounting, depreciation, and other financial formulas * Perform magic with powerful array formulas * Use your formulas to enhance charts and pivot tables * Debug formulas and take advantage of Excel's auditing tools * Develop custom worksheet functions with VBA Bonus CD-ROM Includes * A trial version of the author's award-winning Power Utility Pak 2000 * A demo of the author's Sound-Proof 2000 * Example Excel workbooks from the book System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements.

Details zur Ausgabe

• Verlag: John Wiley & Sons
• Erscheinungsdatum: 2001
• Sprache: Englisch
• ISBN 10: 076454800X
• ISBN 13: 9780764548000
• Einband: Taschenbuch
• Auflage: 1
• Anzahl der Seiten: 860
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar