|
Formulas and Functions with Microsoft Excel 2003 (Business Solutions)

|
List Price:
$39.99
Homebizpc.com Price:
$26.39
Your Savings: $ 13.60 ( 34% )
Subject To Change Without Notice
Availability: Usually ships in 24 hours
Manufacturer: Que
|
Average Customer Rating:     

|
|
Binding: Paperback Dewey Decimal Number: 005.54 EAN: 9780789731531 ISBN: 0789731533 Label: Que Manufacturer: Que Number Of Items: 1 Number Of Pages: 504 Publication Date: 2004-06-21 Publisher: Que Studio: Que
|
|
|
|
|
|
Editorial Reviews:
|
|
The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating for even advanced computer users. Perhaps like you, a majority of users find it difficult to get the most they can out of this very valuable program. Formulas and Functions with Microsoft Excel 2003 strives to break down the complexities by focusing on the four primary technologies to master: ranges, formulas, data analysis tools and lists. Chapters such as Getting the Most Out of Ranges,” Building Your Own Functions Using VBA,” and Solving Complex Problems with Solver” will teach you practical skills and solutions that you can put to work immediately. Frustration will become a thing of the past as you begin to master the complex world of Excel!
|
|
|
Spotlight customer reviews:
|
Customer Rating:      Summary: An excellent buy for experienced users Comment: The book provides insights regarding everyday functions, which you didn't know. The author explains each step thoroughly, however nothing can replace the knowledge you gain by trying it yourself. Nevertheless, its a very interesting book that helps you gain more solid knowledge about almost every formula in excel which you are already using or interested about.
Customer Rating:      Summary: Excel Formula Fixer Comment: .
I have been teaching Excel and other Microsoft application for twelve-years, and I still found new information in this book.
The information is from the basic to the "WOW, Who thought of that?" Working with and calculating TIME and DATE functions has always been a pain....pain solved Chapter 10. Automated time cards are a breeze.
If you already know a lot about Excel, but don't use all the features everyday, then this book will help get started quicker when you need to use seldom used functions and create really robust formulas.
I was so proud of one very complex formula I almost had it tattooed to my leg.
Keyword: ALMOST
Customer Rating:      Summary: Excellent and instantly usable information Comment: I consider myself an intermediate Excel user and amateur VBA programmer. However my knowledge of formulas and functions is lacking, so I purchased this book. Within the first few pages I was learning things about selecting ranges, paste special, etc that I didn't know before. The book explains many basic worksheet functions and also covers forms and controls, Analysis Toolpak functions, Lists, Advanced Filters, Subtotals, Solver and Goal Seek. Uses easy to understand examples to illustrate formula usage. It was able to explain Advanced Filter in a way I was finally able to understand. I'll have to read through the book again just to make sure I didn't miss anything, that's how much information was being conveyed. It does include some statistical functions and business modeling which was a bit advanced and isn't really much use to me, but overall it's an extremely helpful book. A great addition to anyone's Excel library and it will be at fingertip's reach for a long time to come.
Customer Rating:      Summary: A Warning Regarding the ODDL... and ODDF... Bond Functions Comment: I bought this book to get the definitions of the ODDF... and ODDL... bond functions used in Excel, as the mathematical definitions of both these functions and the parameters used in them, as given in the MS Excel 2000 Help topics, are missing a crucial 10% of the needed text. Unfortunately, there are major errors in concept in the discussion of the Excel ODDL... and ODDF... bond functions in this book (July 2004 printing). The author appears to have guessed at how these functions are to be used and at the meaning of certain parameters used by these functions, and guessed horribly wrong. He has communicated to me that any changes to be made will be made on release of the next edition. I have no reason to believe that any other material in the book is incorrect. (A rating was required for this warning to be submitted.)
Customer Rating:      Summary: So much better than online help! Comment: I got a copy of this book through a publisher I work with and think it's amazing. The author does a great job of making formulas and functions accessible and practical for the reader in a way that the online help is unable to do. Each description of a function comes with practical and interesting examples of how to apply what you've learned. This new series from Que is going to be a great addition to their lineup.
|
|
|
|
|
|
|