Excel 2003 Formulas and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Excel 2003 Formulas on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel 2003 Formulas [Paperback]

John Walkenbach
5.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 48.99
Price: CDN$ 30.86 & FREE Shipping. Details
You Save: CDN$ 18.13 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Wednesday, August 6? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $27.90  
Paperback CDN $30.86  

Book Description

Oct. 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

Customers Who Bought This Item Also Bought


Product Details


Product Description

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.

Inside This Book (Learn More)
First Sentence
MICROSOFT EXCEL HAS BEEN referred to as "the best application ever written for Windows." Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars Walkenbach and Excel...a great combination! Nov. 24 2003
By Claire
Format:Paperback
Excel 2003 Formulas provides some amazing ways to really master Excel. Walkenbach's formulas are the best! He covers operators, naming techniques, debugging, auditing, developing custom VBA functions, array formulas, imported 1-2-3 files, etc. Oh, and the CD that comes with this one is load too!
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.2 out of 5 stars  29 reviews
21 of 21 people found the following review helpful
1.0 out of 5 stars Not the best option March 8 2007
By Rebecca K. Porter - Published on Amazon.com
Format:Paperback|Verified Purchase
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.
26 of 28 people found the following review helpful
2.0 out of 5 stars Okay, but no cigar Aug. 2 2006
By Book Buyer - Published on Amazon.com
Format: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! Jan. 27 2005
By Mfg Cost Analysis - Published on Amazon.com
Format: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.
10 of 10 people found the following review helpful
5.0 out of 5 stars Excellent book, but there's a better choice July 30 2007
By Michael - Published on Amazon.com
Format:Paperback
I've found that some reviewers say that this book doesn't give enough theory or examples are trivial or you can find that all in the Help. However, I believe that only advanced Excel users might be dissatiafied with "Excel 2003 Formulas". While that's true that it's not overloaded with the advanced theory (which is what professionals look for), it does give the beginners or intermidiate users all they need to know about formulas, and the tips and tricks offered by Walkenbach really help to discover the world of Excel.
However, on the other hand if you're interested not only in formulas, but you're also planning to study the Excel as a whole then I would recommend to get the "Excel 2003 Bible" of this author. The reason is that the "Formulas..." for the most part just copy the "Bible..." which describes usage of the whole Excel and has a lot more information than the "Formulas".
47 of 61 people found the following review helpful
5.0 out of 5 stars Walkenbach and Excel...a great combination! Nov. 24 2003
By Claire - Published on Amazon.com
Format:Paperback
Excel 2003 Formulas provides some amazing ways to really master Excel. Walkenbach's formulas are the best! He covers operators, naming techniques, debugging, auditing, developing custom VBA functions, array formulas, imported 1-2-3 files, etc. Oh, and the CD that comes with this one is load too!
Search Customer Reviews
Only search this product's reviews

Look for similar items by category


Feedback