| | |  | Home Business Books | Home » » Microsoft® Office Excel® 2003 Step by Step (Step By Step (Microsoft)) | | | | | | | Product Promotions: | | | | | Description: | | This practical, hands-on tutorial expertly builds your skills with Microsoft Office Excel 2003—one step at a time! With STEP BY STEP, you work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need. Master the tools for organizing, processing and presenting data; make data come alive with Microsoft PivotTable® and PivotChart® dynamic views; use data analysis tools for better decision making; tap external data sources; add hyperlinks; create macros; and help keep data secure as you share—and collaborate on—Excel documents over the Web. The book also helps you prepare for the Microsoft Office Specialist exam and makes a great on-the-job desk reference. The companion CD includes practice files you can use as you learn, as well as the Microsoft Office System Reference pack, which contains templates and clip art, an eBook of Step by Step, and four other eBooks: the Microsoft Office System Quick Reference; the Insider’s Guide to Microsoft Office OneNote 2003; the Microsoft Computer Dictionary, Fifth Edition; and Introducing the Tablet PC. Designed for beginning and intermediate level users, STEP BY STEP puts you in charge of developing the skills you need, exactly when you need them! A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
| | | Features: | |
• Master tool for organizing, analyzing and presenting data
• Build PivotTable and PivotChart dynamics views
• Exchange and reuse information from other Microsoft Office programs.
• Work better together by sharing documents over the Web
• Create your own macros and Smart Tags
| | | Product Details: | | | Author:
| Curtis Frye | | Paperback:
| 400 pages | | Publisher:
| Microsoft Press | | Publication Date:
| September 24, 2003 | | Language:
| English | | ISBN:
| 0735615187 | | Product Length:
| 9.28 inches | | Product Width:
| 7.38 inches | | Product Height:
| 1.24 inches | | Product Weight:
| 1.82 pounds | | Package Length:
| 9.2 inches | | Package Width:
| 7.4 inches | | Package Height:
| 1.3 inches | | Package Weight:
| 1.85 pounds | | Average Customer Rating:
|  based on 32 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 32 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
79 of 81 found the following review helpful:
 Some of the pluses and minuses, mostly minusesOct 23, 2006
By The Dude
I have a training company and we teach a lot of Excel classes. We have been using another book from Thomson Learning, but the book is not cost-effective at $55 each, the publisher is difficult to deal with, and shipping is expensive. I decided to go with Excel 2003 Step by Step.
The other reviewers have a point; there are some sloppy errors that are sprinkled throughout this book that will frustrate those who are learning Excel. For example, on page 48 the reader is told to create a simple Sum function but the author forgets the parentheses. This will result in an error and the novice will have no idea why, after carefully following the instructions, he or she is getting an error and what can be done to correct it. Furthermore, the author doesn't bother explaining the syntax of a function so that learners have a conceptual understanding of functions. Amazingly, the AutoSum button and the summary functions in the drop down menu are not even mentioned! (Or did I miss it?).
Some reviewers suggested that this book was not for beginners. I disagree. This is a beginning/intermediate Excel book, but the explanations are shallow and the errors in the exercises sabotage the beginner. Those who know Excel can easily identify the errors.
I agree with the reviewer who said that the book needs an errata page on a web site. But that will probably not happen. The reviews on the 2002 version are all very good, but a few reviewers mentioned errors in that version and one reviewer went as far as documenting the errors and sending them to Microsoft. The result? Version 2003 is riddled with errors and the reviews for this version is worse. No one is listening, unfortunately.
This book does have some good examples and exercises in it. The explanations are clear but, again, shallow, which will leave some readers confused. For example, the author teaches the Subtotal function to subtotal filtered data. He just tells readers what to type in the cell. He doesn't explain how the first argument of the function specifies which summary function of the 11 will be used for the subtotal. Then he tells the reader to change the 9 (which sums the subtotal) to a 1 (which averages the subtotal). If the author uses the subtotal function, he should fully explain it and maybe include a simple table to list each function number with the corresponding summary function that is used in the first argument of the Subtotal function. This is just one example of the shallowness of the book.
I will still use this book in my classes for now because it is structured for classroom learning. I usually write my own exercises based on the files of the book and I create handouts with important information about functions. I can explain everything that the book doesn't. But if you are learning Excel on your own, you may want to check out the O'Reilly book that another reviewer mentions: Excel 2003 Personal Trainer. I thumbed through it last night at a bookstore and the outline looked very good. Also, I believe O'Reilly (the publisher, not the idiot on Fox news) reviews its books for errors before they are published. They also have an errata page on their web site for the errors that get by the reviewers.
37 of 38 found the following review helpful:
 Too many mistakesMay 09, 2005
By A. Dudley
I bought this to teach a class and there are so many mistakes that the students cannot do it on their own. We first need to do it together. Only after they know the problems, can they begin practicing on their own. BEWARE.
For example they ask you to replace X with Y but in fact it should be Y with X. Graphs are not where they should be. It is confusing for students.
22 of 22 found the following review helpful:
Not for Beginners! Many errors.Jul 26, 2006
By Creative Wiz
The book is definitely not for teaching beginners, it is to prepare for the MOS cetification. However, many exercises have some sort of mistakes, either instructional or numeric type mistakes so that the exercises CANNOT be assigned as home work, but have to be done with the students in class and the "BUGS" worked out before they can do them on their own. It is a real shame to release a study book without proof reading it first and correcting the mistakes. An individual who is studying for the MOS Excel certification can get some good information from the book, but a student will be very confused if not very frustrated using it. Even as an instructor I get frustrated over the numerous errors. I have one suggestion: I'll correct the errors if the author/publisher pays me for doing the work.
25 of 26 found the following review helpful:
 The best of the bestAug 13, 2005
By Merrifield Winters
I gave this book 5 stars because it is a perfect text for the icrosoft Office Specialist certification and for the fact that it covers simple to advanced concepts all in one book. Included in the book are basic data entry and spreadsheet writing as well as the programming of macros and the use of XML in the worksheet. It also covers topics such as using formulas, formatyting data series and others. The practice files are invaluable in the learning of the basic to advanced skills.
There is really no way to lose with this book.
10 of 10 found the following review helpful:
Passed the MOUS examFeb 09, 2005
By Jack Hazan
This book is great! Unlike Microsoft 2003 inside out and other Excel books, this book provides exercises that allow you to understand how you apply the functions on Excel.
This is very useful for understanding how you can apply your Microsoft Excel skills for work or personal use. As far as typos, there were probably 2 or 3...even though I'm a perfectionist, this really isn't such a big deal.
See all 32 customer reviews on Amazon.com
| | |
|
