Microsoft® Excel Version 2002 Step by Step (Step by Step (Microsoft)) [Paperback]

Curtis Frye (Author)

Book Description

Publication Date: June 6, 2001 | Series: Step by Step (Microsoft)

Experience learning made easy—and quickly teach yourself how to use the data-presentation and number-crunching power in Microsoft® Excel Version 2002. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction—building and practicing the skills you need, just when you need them!

• Master the tools for organizing, processing, and presenting data in Excel
• Make data come alive with PivotTable® and PivotChart® reports
• Use data-analysis tools and techniques for better decision-making
• Tap external data sources—including other Microsoft Office applications—and add hyperlinks
• Create your own macros
• Help keep data secure as you share—and collaborate on—Excel documents over the Web
• Prepare for the Microsoft Office User Specialist (MOS) exam

This book is approved courseware for the Microsoft Office Specialist Program.

Go to: http://www.microsoft.com/learning/mcp/officespecialist/default.mspx

Editorial Reviews

About the Author

Curtis D. Frye is the author of several books on Microsoft® Access® and Excel®, including Microsoft® Office Excel® 2007 Step by Step and Microsoft® Office Excel® 2003 Step by Step, along with numerous online training courses.

Product Details

• Paperback: 336 pages
• Publisher: Microsoft Press (June 6, 2001)
• Language: English
• ISBN-10: 073561296X
• ISBN-13: 978-0735612969
• Product Dimensions: 9.2 x 7.4 x 1 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 4.1 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #1,025,791 in Books (See Top 100 in Books)
  • #83 in Software > Business & Office > Training & Tutorials

More About the Author

Curtis Frye is the author of numerous books on Excel, Access, and privacy-enhancing technologies. Microsoft Excel 2010 Step By Step is consistently among the best-selling Excel books. Before beginning his writing career in 1995, Curt spent four years with The MITRE Corporation as a defense trade analyst and one year as Director of Sales and Marketing for Digital Gateway Systems, an Internet Service Provider. When not writing, Curt is a popular conference speaker, corporate entertainer, and professional improvisational comedian with ComedySportz Portland.

Customer Reviews

Most Helpful Customer Reviews

27 of 27 people found the following review helpful:

4.0 out of 5 stars 5 stars if it had fewer mistakes!!!!!!, August 2, 2002

By 

SBJ400 "SBJ400" (Mt. Laurel, NJ USA) - See all my reviews

This review is from: Microsoft® Excel Version 2002 Step by Step (Step by Step (Microsoft)) (Paperback)

This book is excellent in many ways but it is also filled with too many errors.
I actually documented the errors and sent a letter to MSPress to notify them. These mistakes are no big deal but if you are truly new to computers or if you just follow along and do not really pay attention as you perform these exercises...you will get the wrong results at times. Most errors do not affect the outcome but in some cases they do. Such as.....page 99, step #14...just skip it. Go from step #13 to #15. If you perform step #14 you will not get the intended results.

I also did not like the authors approach to explain what to click on. He does it in a backwards way like this - To cascade multiple workbooks select Arrange then choose Cascade then click OK under the Window menu option. He should say it like this - To Cascade multiple workbooks click on Window, then Arrange, then choose Cascade and click OK. Typed liked that it is easier to follow but most of the time he doesn't. This gets to be a royal pain!
Overall the book is great if you need to learn Excel 2002 fast and do not want tons of extra info and in depth details about the functions you are learning. He spends a whopping 13 pages on Macros and a measely 10 pages on working with database data. I did not expect heavy coverage and neither should you. Those subjects are worthy of their own books.
I train and teach Office products to clients and I would recommend this book. The practice files are excellent and makemit possible to work with real examples so you actually get to do Real Time exercises and not just read instructions.

Let me add one more thing - The author of Outlook 2002 Step By Step was a better writer and made it easier to follow along and understand. If you need to learn Outlook fast I highly recommend it!!!!!

11 of 11 people found the following review helpful:

4.0 out of 5 stars Less quantity, but more quality, May 28, 2003

By 

Chris Salzer (Gainesville, GA United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Excel Version 2002 Step by Step (Step by Step (Microsoft)) (Paperback)

The 2002 version is much more user-friendly with its color pages and helpful organization than the bigger and less-organized 2000 offering. An added bonus for those looking to take the Microsoft Office Specialist Exam is the fact that this edition lists which core and expert objectives are covered when covering a lesson. Also, the interactive practice files make it extremely easy to follow and learn - for anyone.

This book, in conjunction with the one by Barbara Clemens, helped me to not only garner Excel 2002 proficiency, but to become an Excel 2002 Expert. Now that I'm an Expert, I can tell you this book might be too easy for me - but maybe not for you. And that's the real deal.

11 of 11 people found the following review helpful:

5.0 out of 5 stars Great book!, January 19, 2002

By A Customer

This review is from: Microsoft® Excel Version 2002 Step by Step (Step by Step (Microsoft)) (Paperback)

I read a lot of computer books, and normally they are about as exciting as watching paint dry. I can't claim this book is exciting, but it does everything it possibly can to ease the pain.

The author is obviously a professional writer, not a computer guy who knows stuff and is writing a book about it. The structure of the book is impeccable and extremely consistent. Each section has a description and then extremely well written walk throughs. This allows people with different learning styles to access the book differently. I'm a very experiential learner, so I might do the walk through first and then read about what I did, others may like to do it differently.

I have really enjoyed learning and growing in excel. At the time of reading this book I was progressively working on a real world spreadsheet. At the end of many chapters I would think "hey, what a cool feature, I could use it to improve my spreadsheet". As I spend a lot of time in this spreadsheet, this book has saved me lots of time by allowing me to streamline my work.

Curtis, write more books please - the computer world needs authors like you!