Microsoft Excel Functions & Formulas (Wordware Applications Library) [Paperback]

Bernd Held (Author)

Book Description

ISBN-10: 159822011X | ISBN-13: 978-1598220117 | Publication Date: September 5, 2006

Easy To Use And Equipped With A Variety Of Functions, Microsoft Excel Is The Tool Of Choice When It Comes To Crunching Numbers, Building Charts, And Analyzing Tables. But Most Users Only Scratch The Surface Of The Program’S Functionality, Especially The Built-In Formulas Designed To Make Everyday Operations And Real-World Tasks More Efficient. Microsoft Excel Functions & Formulas Demonstrates The Secrets Of Excel Functions Through The Use Of Practical And Useful Examples In A Quick Reference Format. Topics Include Logical, Text, Date And Time, Basic Statistical, Mathematical, Financial, Database, And Lookup And Reference Functions As Well As Conditional Formatting With Formulas, Array Formulas, And User-Defined Functions. This Book’S Extensive Examples Make It An Excellent Tutorial For All Excel Users Who Want To Understand, Create, And Apply Formulas. Intermediate And Advanced Users Will Find Microsoft Excel Functions & Formulas An Excellent Reference To Many Of The Program’S Advanced Formulas And Functions.

Product Details

• Paperback: 397 pages
• Publisher: Jones & Bartlett Learning (September 5, 2006)
• Language: English
• ISBN-10: 159822011X
• ISBN-13: 978-1598220117
• Product Dimensions: 8.9 x 6 x 0.9 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #639,397 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

4.0 out of 5 stars Good Reference, But Could Go Further, June 11, 2010

By 

David (Irving, Texas, United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Excel Functions & Formulas (Wordware Applications Library) (Paperback)

I discovered this book by accident while browsing the MS Excel books at my local bookstore. I was impressed immediately. Most Excel users only utilize a small fraction of the capability of Excel. This is especially true when it comes to functions.

"Microsoft Excel Functions & Formulas," by Bernd Held explains several dozens of Excel Functions. The book begins logically with a discussion of Formulas in Excel. One needs to know how to use formulas before learing Excel Functions. However, Held should have discussed using nested formulas. The subject of nested formulas was omitted entirely.

Held then discusses many, many Excel Functions. Each function is described in detail and illustrated with a screenshot of the spreadsheet. This is a great visual age to assist in learning how each function works. It is one thing to use a function; it is another thing to understand how the function works. Without understanding, the user will be at a loss to apply the knowledge to solve future problems with Excel. Held does a good job of explaining how and why the function works, in addition to what it does.

However, the book falls a little short. Each explanation provides an example of the use of the function. It would have been better if Held had provided more than one use of the function, and explain each function if greater detail. As it is written, the book is only an introduction to each function. While this is useful, a fuller explanation, description, and application would have been better. I would have preferred a greater length to the book (even though that would mean a more expensive book) to explain in a more detail the working of each function. Some of the explanations fall short of fully explaining the function and providing multiple applications for the use of the function.

Despite these shortcomings, I still would recommend the book to any Excel user wanting to learn formulas and functions. The book does not require an extensive knowledge of Excel; it can be used by a beginner who is just learing Excel. Even an advanced user of Excel will not be familiar with all of these functions and can learn from the material. Most Excel users get stuck using a few favorite formulas and functions, and fail to expand their knowledge in this area. Held's book solves this problem.

Buyer beware: The book references the Excel 97 through 2003 versions of Excel. If you have Excel 2007 or 2010, you can still use the book, but be advised the book does not address the changes in Excel 2007 and Excel 2010. These changes were significant, especially the use of the ribbon in 2007. The book is still helpful to those using the 2007 and 2010 versions, but an updated book would be nice.

2 of 3 people found the following review helpful:

4.0 out of 5 stars Great reference - very thorough, March 31, 2008

By 

Beerman "Beerman" (Chicago) - See all my reviews

This review is from: Microsoft Excel Functions & Formulas (Wordware Applications Library) (Paperback)

I've found this book to be a great reference to create simple to complex formulas and functions in Excel. The challenge to writing a book on this subject is that the application of the formulas in the book is done using "real-world examples" like Calculate Manpower for a project using the ROUNDUP function. This is great if, in your work, you need to Calculate Manpower needed to do a project. The difficulty comes when you need to apply the ROUNDUP function to your own projects.

My only other comment is that I wish the book had a different binding, like spiral binding so the itlays flat while you type a formula.

1 of 2 people found the following review helpful:

4.0 out of 5 stars Excellent book for utillizing functions, May 12, 2009

By 

Bookseller (Chicopee, MA USA) - See all my reviews

This review is from: Microsoft Excel Functions & Formulas (Wordware Applications Library) (Paperback)

I have other books I use to reference formulas but this book takes it one step further, illustrating the use of these functions in real situations. I highly recommend this book to Excel users with some experience with functions but wanting to go one step further with their utilization. Well written and laid out in easy to read chapters.