Product Description

Everything you need to know about
∗ Mastering operators, error values, naming techniques, and absolute versus relative references
∗ Debugging formulas and using the auditing tools
∗ Importing and exporting XML files and mapping the data to specific cells
∗ Using Excel 2003′s rights management feature
∗ Working magic with array formulas
∗ Developing custom formulas to produce the results you need


Here′s the formula for Excel excellence

Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel′s capacity.

CD–ROM Includes
∗ Trial version of the author′s award–winning Power Utility Pak 5
∗ More than 90 sample workbooks illustrating key formula concepts

Product Details

• Amazon Sales Rank: #118701 in Books
• Published on: 2003-10-17
• Original language: English
• Number of items: 1
• Binding: Paperback
• 864 pages

From the Back Cover
Everything you need to know about

• Mastering operators, error values, naming techniques, and absolute versus relative references
• Debugging formulas and using the auditing tools
• Importing and exporting XML files and mapping the data to specific cells
• Using Excel 2003’s rights management feature
• Working magic with array formulas
• Developing custom formulas to produce the results you need

Here’s the formula for Excel excellence

Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel’s capacity.

CD–ROM Includes

• Trial version of the author’s award–winning Power Utility Pak 5
• More than 90 sample workbooks illustrating key formula concepts

About the Author
John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award–winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows, and maintains the popular Spreadsheet Page at www.j–walk.com/ss.

Customer Reviews

Excellent!
I am an experienced, self-taught user of Excel but bought this book to see if there was anything in it that could help me advance my skills further. This book did far more than that! It is really great and I can highly recommend it, (particularly the section about the use of arrays in Excel.)

John Walkenbach provides you with lots of handy tips and tricks and ensures you have a good grounding in each topic before advancing. His language is simple and easy to read with lots of working examples and a wide range of topics.

This book is really excellent and I can HIGHLY recommend it for a user of almost any skill level. It serves as an excellent reference manual. I also highly recommend his book on Excel 2003 Power Programming with VBA. In combination these two books will help you comfortably conquer Excel.

Excel Formulas
This author knows his stuff. The book is packed with good information and working examples. A definite purchase for anyone wanting to expand their Excel knowledge. As a supposedly competent Excel user, I learned a lot from this publication.

Harry