Microsoft® Excel 2000 Bible [Hardcover]

John Walkenbach (Author)

Book Description

ISBN-10: 0764534491 | ISBN-13: 978-0764534492 | Publication Date: February 11, 2000

If you're looking for inside information and time-saving tips to maximize the power of Excel on your desktop and on the Web, then look no further than the Gold Edition of the best-selling Microsoft Excel 2000 Bible. Author John Walkenbach, a leading authority on spreadsheet software, has packed this book with valuable information for Excel users at every level:
* Acquaint yourself with essential Excel features, and navigate through basic files and workbooks.
* Dive deep into spreadsheet make-up and maintenance, from controlling worksheet data to working with rows, columns, cells, and ranges.
* Add visual elements to spreadsheets by formatting styles, fonts, and cell alignment, plus build charts, pictures, and drawings.
* Investigate advanced techniques that enable you to create and use worksheet outlines, link and consolidate worksheets, and utilize arrays.
* Explore Excel's Internet tools, and see how you can share data with other applications.
* Analyze data with Excel, and program Excel 2000 with VBA.
The bonus CD-ROM includes a fully functional trial version of Power Utility Pak 2000, with 50 general-purpose utilities and 40 custom worksheet functions, examples, and enhanced shortcut menus.

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 --This text refers to the Paperback edition.

From the Back Cover

The Ultimate Guide to Microsoft Excel 2000! In this indispensable resource, spreadsheet guru John Walkenbach gives you the tips and inside information you need to maximize the power of Excel on your desktop and on the Web. From basic cell formatting to sharing data across an intranet to Programming Excel with VBA, this Gold Edition of the bestselling Microsoft(r) Excel 2000 Bible answers all your questions and helps you create the perfect spreadsheets for your business. Inside, Find Everything You Need to Know to:
* Master skills needed to insert charts, graphics, sound, and video into your documents
* Harness formulas and functions to make your spreadsheets more powerful
* Share data between applications with linking and embedding
* Save worksheets as HTML documents and publish them on your Web page
* Consolidate and juggle multiple worksheets in a single workbook across a corporate intranet
* Import data from other databases or Office applications using queries
* Use existing templates, VBA macros, and custom worksheet functions and dialog boxes to automate Excel
Fully functional trial version of Power Utility Pak 2000 on CD-ROM, with
* 50 general-purpose utilities
* 40 custom worksheet functions examples
* Enhanced shortcut menus
* Games for Excel
* Sound-Proof add-in
* Chapter workbook
* Plus a PDF version of the entire book
Shareware programs are fully functional, free trial versions of copyrighted programs. If you like particular programs, register with their authors for a nominal free and receive licenses, enhanced versions, and technical support. Freeware programs are free, copyrighted games, applications, and utilities. You can copy them to as many PCs as you like-free-but they have no technical support. www.idgbooks.com System Requirements: Pentium PC; Windows 95 or NT; Excel 2000 or Microsoft Office Professional or Developer's Edition

See all Editorial Reviews

Product Details

• Hardcover: 1381 pages
• Publisher: Wiley (February 11, 2000)
• Language: English
• ISBN-10: 0764534491
• ISBN-13: 978-0764534492
• Product Dimensions: 9.6 x 7.7 x 2.6 inches
• Shipping Weight: 5.6 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,531,659 in Books (See Top 100 in Books)

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.