Excel 2003 Formulas [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0764540734 | ISBN-13: 978-0764540738 | Publication Date: October 17, 2003

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

Editorial Reviews

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.

Product Details

• Paperback: 864 pages
• Publisher: For Dummies (October 17, 2003)
• Language: English
• ISBN-10: 0764540734
• ISBN-13: 978-0764540738
• Product Dimensions: 9.2 x 7.4 x 1.8 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (25 customer reviews)
• Amazon Best Sellers Rank: #247,937 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

20 of 20 people found the following review helpful:

1.0 out of 5 stars Not the best option, March 8, 2007

By 

Rebecca K. Porter "golden maple" (Belleville, WI USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Excel 2003 Formulas (Paperback)

I have this and the Excel 2003 Bible. Don't waste time on this. Go right for Excel Bible. This one seems to be a duplicate with only a small amount of expansion. Excel 2003 Bible will help you through a lot more problems.

25 of 27 people found the following review helpful:

2.0 out of 5 stars Okay, but no cigar, August 2, 2006

By 

Book Buyer - See all my reviews

This review is from: Excel 2003 Formulas (Paperback)

Typically these technical how-to books are badly written and rushed to print and I found this one to be no exception. Although it offers some helpful hints not found in other Excel guides, it is rather wordy and vague in places. Some of the sample formulas simply do not work or else are not explained fully in context. Added to this, the accompanying CD skimps on the first four chapters, making it impossible to follow along on some the exercises the author provides. In some cases, he doesn't even provide a sample table. I went out and bought a copy of Microsoft's Excel Data Analysis and Business Modeling and find this to be better written, much more comprehensive, and easier on the wallet.

27 of 30 people found the following review helpful:

5.0 out of 5 stars It's the BOM!, January 27, 2005

By 

Mfg Cost Analysis - See all my reviews

This review is from: Excel 2003 Formulas (Paperback)

I use Excel non-stop for Bill Of Material (BOM) and pricing/cost analysis for manufacturing. This is by far the best publication available for the number crunching workhorse. I just find it peculiar that John decided to introduce "financial formulas" in Chapter 11. But seriously, it's loaded with boo-koos of real word examples that have made my work much more automated and easier.