Microsoft® Excel 2000 Bible [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0764532596 | ISBN-13: 978-0764532597 | Publication Date: May 21, 1999

You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.

Editorial Reviews

Amazon.com Review

If you need help crunching numbers using Microsoft Excel, Microsoft Excel 2000 Bible can take novices or spreadsheet converts to an intermediate level and set regular users well on the road to mastery. So well-organized it could almost be a tutorial, the Bible starts with the basics of spreadsheet creation and navigation and moves on to cover weightier topics like sharing work, publishing data on the Web, and analysis using pivot tables.

You won't have any trouble finding everything you need, and when you do, the text and illustrations will show you the steps necessary to set your data to work. Unfortunately, it doesn't go into quite enough detail on the more advanced topics like Visual Basic programming, but for all but the mightiest data-jockeys it has plenty.

The accompanying CD-ROM has lots to keep you busy too: the complete text of the book, over 30 Excel utilities, custom worksheet functions, and even (why not?) a bunch of games. The 32-page Quick Start book will have you mucking about in spreadsheets in short order. As an overall package, the Microsoft Excel 2000 Bible is hard to beat. --Rob Lightner

From the Back Cover

If Excel can do it, you can do it too...

You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft(r) Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.

Inside, you'll find complete coverage of Excell 2000
* Simplify repetitive tasks using formulas and functions
* Illustrate your data with charts, drawings, maps, and other graphics
* Consolidate and juggle multiple worksheets in a single workbook
* Share documents with a workgroup across a corporate intranet or the internet
* Save worksheets as HTML documents and publish them on your Web page
* Import data from other databases or Office applications using queries
* Analyze data with pivot tables or "What if" scenarios, Goal Seeking and Solver, or the Analysis ToolPak
* Automate Excel using templates, VBA macros, and custom worksheet functions and dialog boxes

Fully functional trial version of Power Utility Pack 97 on CD-ROM, with
* 31 utilities
* 40 custom worksheet functions
* Enhanced shortcut menus
* Games for Excel

Plus
* Adobe Acrobat Reader
* Electronic version of Internet Directory from Internet Bible
* PDF Version of the full book
* WinZip 7.0 Evaluation Version

MindSpring Internet Access and Netscape Communicator also included!

See all Editorial Reviews

Product Details

• Paperback: 984 pages
• Publisher: Wiley (May 21, 1999)
• Language: English
• ISBN-10: 0764532596
• ISBN-13: 978-0764532597
• Product Dimensions: 9.2 x 7.4 x 2.2 inches
• Shipping Weight: 3.3 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #1,245,920 in Books (See Top 100 in Books)
  • #37 in Books > Computers & Technology > Microsoft > Spreadsheets

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

27 of 28 people found the following review helpful:

3.0 out of 5 stars Too many pages, not too much content..., October 21, 2003

By 

Erkin S. Peksoz "manylander" (Chicago, IL USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Excel 2000 Bible (Paperback)

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...
Won't recommend to intermediate and up users...

Good day!

18 of 21 people found the following review helpful:

4.0 out of 5 stars Read the back cover, July 29, 2001

By A Customer

This review is from: Microsoft® Excel 2000 Bible (Paperback)

I believe this book is a great book. However, people who buys it are not aware that the book is for intermediate level. It is assumed by the author that they should have a basic knowledge of how to use excel. Please read the title, and the back cover page to let you know for who it is written. This book was not written for beginners, do not give a bad review about it if you do not know how to use excel at all. Buy a book that is for you. a beginner level book not a beginner to intermediate level.

14 of 16 people found the following review helpful:

4.0 out of 5 stars Great Coverage!, October 30, 2001

By 

Jeffrey A. Tompkins (Myrtle Beach, SC United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft® Excel 2000 Bible (Paperback)

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.

I've had to read it cover to cover and I find it to be very easy to understand and covers all of the basic and intermediate operations that I would use. It also covers strategies for building your own applications with Excel (both 97 and 2000). It will not gather much dust on my bookshelf.