Reviews (17)

Very worthwhile but frustrating
Anyone who uses Excel on a regular basis will find ways to get more out of the product and to improve their spreadsheets by reading this book.
A Must Have for Power Users and Novices
Excel Best Practices for Business is one of those rare books that teaches you in depth after you think you have mastered its topic. I am so happy that I bought it because both my husband and I have benefited immensely from the book's insight and extremely useful information.
instant service
book was recieved within 2 days when I didn't even special ship it. Prime condition. ... Read more

Subjects:  1. Business    2. Computer Books And Software    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microcomputer Spreadsheet Software    8. Microsoft Excel (Computer file    9. Microsoft Excel (Computer prog    10. Spreadsheets - General    11. Computers / Spreadsheets / General    12. Excel   

Editorial Review

Spreadsheets aren't just for financial planners anymore. If you want to master the secrets of one of the most powerful spreadsheet applications on the market, take a peek inside Read more

Reviews (4)

Excellent!!!!!
This book is one of the best books written on Excel. I recommend this book for anyone wanting to learn or brush up on their excel skills. A must have in your collection if only to go back to every once in a while.

Invaluable Resource for Beginner to Intermediate Users
I ordered Microsoft Excel 2000: Step by Step to aid myslef in becoming more acclimated in the Excel platform.I have made spreadsheets and charts before using Excel 95 & 97, but it had been some time since I last employed Excel.Also, I never claimed to be the Excel Master that others profess to be.That's why I purchased this book - to not only make me proficient with Excel, but to bolster my abilities so that I will pass the Microsoft User Specialist Excel Master exam and become a Certified Excel Master and receive my pretty little certificate in the mail. You will learn Excel with this book
This book will get you up and running with using Excel in no time. From the sizes of other books out there, this book does not cover everything, but it is excellent for beginners of Excel. The book covers macros and explains VBA, which would be the next thing for you to learn if you want to unleash the power of Excel to a higher level. Some other notable topics covered are pivot tables and charts, and the book has many useful tips for getting things done quickly such as generating lists, picking from lists, and covers many other tips for reducing typing in data entry. Enjoy! ... Read more

Subjects:  1. Business    2. Computer Books: Spreadsheets    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microcomputer Spreadsheet Software    8. Microsoft Excel (Computer file    9. Microsoft Excel (Computer file)    10. Spreadsheets - Excel    11. Spreadsheets - General    12. Computers / General    13. Excel   

Editorial Review

If you've mastered Excel and need to develop customized applications, Read more

Reviews (60)

MICROSOFTEXCEL 2000 POWER PROGRAMMING /VBA
VERY EXCELLENT RESPONSE FROM SUPPLIER AND THE PROGRAM IS WHAT THE USER NEEDED.

Might be ok for some users
Charts are not given much coverage. Chart data is not given much coverage. From a programmer's point of view, simple excel vba object graphs and explanations of properties would be more helpful. Some examples come straight from the MSDN Office developer sections. I really wish authors would refrain from the cut and paste of the MSDN. Consumers of this type of material are looking for more than MSDN help files. All that said.... Excellant Resource
I have found this book to be absolutely fantastic.I am not sure it is for the beginner, but for someone who has a little knowledge of VB it is an excellant refresher.The book is well written and seems to flow in a logical sequence.It is very easy to understand and examples are plentiful.I have been tinkering with macros in Excel for about a year and the book is bringing VBA and Excel together for me.I have have already cut some of the coding in my modules in half by using the techniques found in the book.This book is definitely going to be come one of my major references when it comes to using VBA in Excel.I have certainly gotten my money's worth out of this book and will be looking for other books written by John Walkenbach. ... Read more

Subjects:  1. Basic (Programming Language)    2. Computer Books: Spreadsheets    3. Computer software    4. Computers    5. Computers - Languages / Programming    6. Development    7. Electronic spreadsheets    8. Microcomputer Spreadsheet Software    9. Microsoft Excel (Computer file    10. Microsoft Excel (Computer file)    11. Microsoft Visual Basic for app    12. Programming Languages - BASIC    13. Programming Languages - Visual BASIC    14. Spreadsheets - Excel    15. Spreadsheets - General    16. Computer Software Packages    17. Computers / Spreadsheets / General   

Reviews (45)

Excellent reference
This book is very good for learning your way around Excel and its formulas.I am fairly comfortable in Excel and still found the book extremely useful.There are many formulas that are explained which I did not know existed that have made me much more efficient within the program.

An Exctract From the Author's "Excel Bible"
The Excel "Formulas" book is extractions from the same author's
extremely poor excuse for an expository book
I do all my serious mathematical work with Mathematica. However since some of my collegues use Excel for simple data presentation and analysis, I've recently started using Excel to be able to converse with my collegues.
Read more

Subjects:  1. Business    2. Computer Books And Software    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Financial Accounting    8. Microcomputer Spreadsheet Software    9. Microsoft Excel (Computer file    10. Microsoft Excel for Windows    11. Reference - General    12. Spreadsheets - Excel    13. Spreadsheets - General    14. Computer Software Packages    15. Computers / Spreadsheets / General   

Reviews (6)

Not for beginner's but good
Those with no programming experience should not buy this book. It is helpful in the very detailed examples of what Excel VBA can do for you.The last chapter on Pivot Tables seems a little out of step with the rest of the book. Also, the theory behind what you are doing is not explored so it is a bit superficial. But, as far as getting your feet wet, this is a great place to start.

Not for beginners
The book does not do a good job with the fundamentals of VBA. Very brief in its explanation of objects, properties, and methods. Gives plenty of examples but often refers you to Excel help to find out more info about a particular item. If I wanted to do that I would not have bought the book. Very disappointed.

tr�s bon livre de d�part
J'ai commenc� avec le livre de John Walkenbach et ensuite j'ai termin� avec le livre de Reed Jacobson; j'aurais d� faire le contraire! Le livre de Reed donne un bien meilleur d�part pour visual basic, explique mieux ce quesont les objets et m�thodes, les contr�les active-X, etc. Par contre, ilest beaucoup ax� sur les excel (pivot tables, pivotcharts, etc) et il fautbien comprendre Excel avant de comprendre les macro. John est plus ax� surle langage des macro. Les deux livres sont compl�mentaires; il faut lesdeux! ... Read more

Subjects:  1. Computer Books And Software    2. Computers    3. Computers - Languages / Programming    4. Microcomputer Spreadsheet Software    5. Microsoft Excel (Computer file    6. Microsoft Excel (Computer file)    7. Microsoft Visual BASIC    8. Programming Languages - Visual BASIC    9. Spreadsheets - Excel    10. Spreadsheets - General    11. Basic, Visual Basic & QBasic    12. Computers / General    13. Excel   

Reviews (2)

Good book 4 a visual learner
While i know this subject fairly well i took a class on this subject and the class used this book.It was very good for me because i learn visually so this was good for me because there are a LOT of illustrations and pictures.

Good book for Learning in a Distance Learning Environment
This is an excellent book for learning Excel 2000 at your own pace.Features full color examples and Problems at the end of each project. ... Read more

Subjects:  1. Computer Books: General    2. Computers    3. Computers - Spreadsheets    4. Spreadsheets - Excel    5. Spreadsheets - General    6. Computers / Spreadsheets / General    7. Excel   

Reviews (2)

Better than online help
I've been fiddling with Excel for a couple of months now, and this book has made it easier to understand.

Cuts to the chase!
Having to learn new versions of data manipulators can be a nightmare when your deadlines are gone before you're given a project -- this gem cuts to the chase!Without a lot of fanfare, tells you exactly what to do, withjust enough pictures to let you know you're in the right place.It'sfilled in a lot of blanks, and I'm now ordering the Access 2000 version. Try it, you'll like it. ... Read more

Subjects:  1. Business    2. Certification Guides - General    3. Computer Books: Spreadsheets    4. Computer programs    5. Computers    6. Computers - Spreadsheets    7. Electronic spreadsheets    8. Microsoft Excel    9. Microsoft Excel (Computer file    10. Spreadsheets - Excel    11. Computers / Spreadsheets / General    12. Excel   

Editorial Review

If you need help crunching numbers using Microsoft Excel, Read more

Reviews (8)

Outstanding Resourse
This is a comprehensive reference book that gives you all the information you need to master Excel. It is detailed and easy to follow.

Too many pages, not too much content...
If you are an absolute beginner 80% of this book is for you. If you bought it to explore the capabilities and more complex tools of Excel, you are at a loss. I've been using Excel for 10 years. Mostly for corporate needs in an office environment and as a calculation tool for some of my MBA classes. Bought this one to get more insight, but did not find it useful. Most of the pages are spent to describe the simplest of tasks, such as formatting, listing of built-in formulas etc... Great Coverage!
I agree with the previous reviewer that the book is logically organized poorly for referencing certain operations.I think this is a very small drawback for the amount of information that this one source provides.Read more

Subjects:  1. Business    2. Computer Books: General    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microcomputer Spreadsheet Software    8. Microsoft Excel (Computer file    9. Microsoft Excel (Computer file)    10. Spreadsheets - Excel    11. Spreadsheets - General    12. Computer Software Packages    13. Computers / Spreadsheets / General   

Reviews (10)

Microsoft Office @2000 -ShellyCashman Series Book
The book itself is very good. I would recommend it to those who are just starting to learn and for those who need to brush up on their skills or use as a desk reference. I did not like the "ring -binder" form as it seems flimsy and already was looking used when I got it due to shipping. I would suggest the other form for future reference.

Great Book just skip the first chapters about computers!!!
The book is great but it is written for people who never had experience with computers.So I would advise anyone to skip those intial chapters. I highly recommend getting the spiral bound edition because the book is about the size of a major city's Yellow Pages and it is easier to handle.
Microsoft Office 2000
This book is quite useful especially for those who is self-directed. You will find it informative and put you at ease. You can follow step-by-step instructions and learn a lot from this book. ... Read more

Subjects:  1. Business    2. Business Software - MSOffice    3. Computer Books: Integrated Systems    4. Computer programs    5. Computers - Integrated Software    6. Microsoft Office    7. Integrated software packages   

Editorial Review

Wrox's growing reputation for putting out well-organized, detail-rich books for programmers gets a boost from Read more

Reviews (26)

A Perfect Book
I think that John Green outdid himself on this book, the people who gave it a bad review oviously have no experence with Exel, the book is the best refrence that I have ever seen. All the codes are easy to get to function, really John, you couldn't have done a better Job!
A classic that holds up
I've owned this book since it has been published and I still keep it at my desk.This reference is a handy size and is packed full of information that applies even today. Amazing!

Needs Major Editorial Work
This book had potential, but it is so full of errors that it is practically useless. It needs a good editor with lots of patience and time to make the corrections. ... Read more

Subjects:  1. Business    2. Computer Bks - Languages / Programming    3. Computer Books: General    4. Computer programs    5. Computers    6. Computers - Languages / Programming    7. Electronic spreadsheets    8. Microsoft Excel (Computer file    9. Microsoft Excel (Computer file)    10. Microsoft Visual Basic for Win    11. Programming - General    12. Programming Languages - Visual BASIC    13. Spreadsheets - Excel    14. Spreadsheets - General    15. Computer Programming    16. Computers / Programming Languages / Visual BASIC    17. Excel   

Reviews (3)

Surpassed my Expectations!
I consider myself to be an average-skill-level Excel user, and hesitated ordering this book because I was afraid it would be too technical and difficult to understand. But I purchased it anyway, and am so glad I did. I've been getting involved with more and more complicated spreadsheets, and thus needed some help. And Escape from Excel Hell provided just the help I needed.
I Don't have time to investigate Excel problems
I often don't have time to investigate solutions to certain problems I encounter in Excel.I, like most Excel users, end up building elaborate work-arounds that solve my problem ASAP.Well, I picked up this book yesterday and I have already found fixes that would have helped me save hours of work had I known about them.
Just Right
What a great book! I use Excel in my work, but I'm no expert, and I'm in constant 'Excel Hell'. Last week I had to get out a spreadsheet and the data wouldn't sort correctly (I bet this is familiar territory). When I saw the 'Escape from Exel Hell' book I grabbed it in desperation. Well I found out about the 'trigger happy' tendencies of the program when sorting, and how I can select data to avoid confusion and get results. Everything was laid out so simply, clearly, and with such a practical approach I was able to solve my sort problems in time to submit the darn spreadsheet.
Read more

Subjects:  1. Computer Books: Spreadsheets    2. Computers    3. Computers - Spreadsheets    4. Microsoft Excel (Computer file)    5. Microsoft Excel (Computer software)    6. Spreadsheets - Excel    7. Spreadsheets - General    8. Computers / Spreadsheets / General    9. Excel   

Editorial Review

If data rules your life, odds are you're using (or you soon will be) Excel 2000, Microsoft's revised version of its premier spreadsheet application. Excel's complexity can be daunting, especially if you're a power user who intends to use it at advanced levels. With Read more

Reviews (23)

A real disappointment--information hard to find, incomplete
This book has been a real disappointment.It has two main problems.The first problem is that it's very difficult to locate relevant information--the index is very poorly constructed, and even obvious and common tasks can be hard to track down.For example, I needed to know how to make a data point on a dot plot be hollow.This isn't an unusual task, and it's quite easy, *once you know how.*Good luck finding out how from this book, though. Waste of money
This book is a complete waste. Completely unorganized and hard to follow sequences. Examples are poorly structured and hard to understand. Don't buy this.

Disorganized and unhelpful
This is one of the most disorganized and unhelpful books I have ever read. Let's say you want to construct a formula. Ghapter 10 is called "Constructing Excel Formulas." Great! But wait: no where in chapter 10 is there a section on actually constructing the formulas. After telling us how to see a sum, it jumps into editing. We haven't even constructed anything to edit! Or let's say you want to hide a column. Look in the index under "hiding" and it tells you to go to page 583. On 583 it says "[y]ou can hide information by using the drilldown technique on PivotTables." How helpful can you be! Actually, on page 582 it gives some more hints: "You can hide [in italics] (page 470) rows or columns that you don't want to show...." And so the reader goes to page 470 to find out how to do this. On page 470 it says "You can maintain a chart's integrity [?] even if you hide [in italics] (page 521) the data.... Ok, the little bugger is on page 521 now, eh. And, indeed, on page 521, we are led full circle: "Of course, because Excel users learn quickly how to hide [in italics] (page 470 [also in italics!]) and unhide (page 583 [?]) cells, hiding provides very little real protection." Fortunately, if Excel users use this book, hiding cells will afford great protection. No one would ever be able to "unhide" them. ... Read more

Subjects:  1. Business    2. Computer Bks - Spreadsheets    3. Computer Books: Spreadsheets    4. Computer programs    5. Computers    6. Computers - Spreadsheets    7. Electronic spreadsheets    8. Microcomputer Spreadsheet Software    9. Spreadsheets - Excel    10. Spreadsheets - General    11. Computers / Spreadsheets / General    12. Excel   

Editorial Review

You may not be a dummy, but that doesn't mean you were born knowing how to use spreadsheets. Read more

Reviews (9)

Good for Just Basics
This book is fine if all you want to do is basic spreadsheets. If cutting, pasting, basic formatting, or creating VERY simple formulas is all you need to do then this book is fine. However, if you are trying to do anything more complicated forget using this book. For instance, the section on creating Macros wasn't very detailed. In addition, the book is completely missing any explanation of how to use the more complicated formula functions (there is no mention of how to do any of the statistical functions). Probably 80% of what an average user needs is in this book. But for anything beyond the basics, forget it; you'll need another reference.

Useless
I foudn the book compleely useless and a waste of money.It explains nothing.After studying this book for two hours I was unable to do anything whatsoever in Excel. Look elsewhere.

Gentle intro but no depth
This is a good book for a non stressfull introduction, but there are few good hands on examples. I've found that by doing complex detailed step by step examples you can learn more faster. The learnkey.com website has a good excel class ... Read more

Subjects:  1. Business    2. Certification Guides - General    3. Computer Books: Spreadsheets    4. Computer programs    5. Computers    6. Computers - Spreadsheets    7. Electronic spreadsheets    8. Microsoft Excel (Computer file    9. Microsoft Excel for Windows    10. Spreadsheets - Excel    11. Computer Software Packages    12. Computers / Spreadsheets / General   

Reviews (1)

A Perfect Book !
" This is the perfect book for class or self learning of Excel. I use this text in my Excel 2000 classes. It is the best one I have found. With it, students may help themselves in a large class. It has met with student approval 100%. I also use DDC Publishing text for my other computer classes. They are tops." -"Cpuck" ... Read more

Subjects:  1. Business    2. Business Software - General    3. Computer Books And Software    4. Computer programs    5. Computers    6. Computers - Spreadsheets    7. Electronic spreadsheets    8. Microsoft Excel (Computer file    9. Microsoft Excel (Computer file)    10. Spreadsheets - Excel   

Editorial Review

Whether you've upgraded or installed Excel 2000 for the first time, odds are you'll need some inside information to get the spreadsheet application tuned up and ready for data. Microsoft Press has published Read more

Reviews (5)

Needs Improvement
This is NOT a book for beginners; if you're new to Microsoft Excel, avoid this book! Even though the back of the book says it's a reference for beginning to advanced users, this book will confuse you if you're a beginner. It's a book for people who already have some knowledge about Excel; I'm in the intermediate to advanced user category, and even I get confused by some of the explanations provided in the book. BETTER DEAL
I would recommend buying the package (step-by-step interactive cd + this book = $30 cost) Very complete coverage of Excel
Running Excel 2000 provides a very complete look at using Excel in most day to day situations.The general usage information is well structured and each topic is covered in detail.Read more

Subjects:  1. Business    2. Computer Books: Spreadsheets    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microsoft Excel (Computer file    8. Microsoft Excel for Windows    9. Spreadsheets - Excel    10. Spreadsheets - General    11. Computers / General    12. Excel   

Subjects:  1. Computer Books: Spreadsheets    2. Computers    3. Spreadsheets - General   

Reviews (2)

Great Intro To What Excel Can Do for people with basic Office Skills
A friend at work gave me this book. It's a great little intro to excel basics and gives you a taste of the more advanced functions as well. This is a great overview for anyone interested in exploring the basic functions of excel. I used what I learned to build some nifty spreadsheets for my department. Before I started with this book I had very limited experience with Excel and this got me proficient with the basic range of excel functions and more. Even used my knowledge in a job interview test and I got the job!

An excellent introductory tutorial.
I had tried reading through the entire list of Excel tutorials at the local library.All of them were disappointing to me, as they spent so much time extolling the glories of Excel that they never stopped to tell you what Excel was actually good for!And then they jumped right into complicated snippets of examples that were unrelated to anything in the real world, or even each other.These snippets were again designed to show off the glories of Excel, not to do anything practical, like build an actual real-life spreadsheet.Read more

Subjects:  1. Computer Books: Operating Systems    2. Computers    3. Computers - Spreadsheets    4. Spreadsheets - Excel    5. Spreadsheets - General    6. Computers / General    7. Excel   

Reviews (5)

5 stars for the user totally new to Excel / PCs
I am an Excel instructor. This is the book I reccommend if your student (or you) are clueless about what Excel is or how to use a spreadsheet program. Step-by-step and lots of screen shots. If you're not clueless, get a more advanced book.

An excellent book for the teach-yourself person
This book just beats the tar out of the comparable ". . . For Dummies" and ". . . For Complete Idiots" analogs. The exercises step you through all of the basics of Excel and the color images show you what will really be on the screen. Each step is clearly marked and there are no obvious leaps to another level. Various shades of black and white can show a great deal, but there are times when only color will do. This is especially true when color coding is used to differentiate different key aspects of the display, which is done in Excel. This is the book that I recommended be adopted for future classes in Excel and the one I would use if I were to teach the class again.

from novice to advanced in under 3 hours
This is my first experience with this series, and what a positive experience it was! The layout is very easy to follow, the diagrams areaccurate and attractive, and the text clear.I barely knew how to useExcel at all when I started, but after under 3 hours with the book, I'mconfident that I could do any major project just using the information Ilearned while reading it.Kudos to whoever designed the order ofdifficulty and chapter headings, because the progression of ideas naturallyfollows. The chapters on using complex formulas and creating charts wereparticularly strong. In fact, even if you don't know how to use your mouse,if you read the book chronologically, you'd learn that too, followed by ofcourse more complex things.I knew Excel was a powerful program.Afterreading this book, I feel that I can put that knowledge to work inpractical ways.If you are a visual learner and have trouble following the"Idiot Guides," this series is a great alternative. ... Read more

Subjects:  1. Business    2. Computer Books: Spreadsheets    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microsoft Excel (Computer file    8. Microsoft Excel for Windows    9. Spreadsheets - Excel    10. Spreadsheets - General    11. Computer Software Packages    12. Computers / Spreadsheets / General   

Reviews (1)

Excel 2000 is the book for you
I found this book to be very informative in helping me to run and Creat programs for not only my home but business as well. I would defently recomend using this book. ... Read more

Subjects:  1. Business    2. Computer Books: Spreadsheets    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microcomputer Spreadsheet Software    8. Microsoft Excel (Computer file    9. Microsoft Excel for Windows    10. Spreadsheets - Excel    11. Spreadsheets - General    12. Excel    13. Fiction / Suspense   

Reviews (6)

Review- Simplified
This book was too basic to be of any use. The book is not set up so one can look up a specific task and then see how to do it. The only book I have ever returned, and I buy two or three books a month.

Price online
Whatever you do, do not buy this book at one of the store locations because they charge you full price, which seems funny since it is sold for much less online.The book was good, but paying full price for it like I did, is a big mistake.

Impressed
I'm quite impressed and satisfied with this book and with the entire Simplified series. This book presents an excellent introduction to and overview of Microsoft Excel 2000. It is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help.Read more

Subjects:  1. Business    2. Computer Books: Operating Systems    3. Computer programs    4. Computers    5. Computers - Spreadsheets    6. Electronic spreadsheets    7. Microsoft Excel (Computer file    8. Microsoft Excel for Windows    9. Operating Systems - Windows    10. Spreadsheets - Excel    11. Computers / Spreadsheets / General    12. Excel