Excel2003 Formulas
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £0.25
Trade in Excel 2003 Formulas for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
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
∗ 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
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
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
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
MICROSOFT EXCEL HAS BEEN referred to as "the best application ever written for Windows." Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
17 of 18 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
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.
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.
2 of 2 people found the following review helpful
Format:Paperback
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
Harry
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
25 reviews
20 of 20 people found the following review helpful
Not the best option
8 Mar 2007
Format:Paperback|Amazon 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.
25 of 27 people found the following review helpful
Okay, but no cigar
2 Aug 2006
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
It's the BOM!
27 Jan 2005
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
