Product Description

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.

Product Details

• Amazon Sales Rank: #313968 in Books
• Published on: 1999-05-07
• Original language: English
• Number of items: 1
• Binding: Paperback
• 984 pages

Amazon.co.uk Review
The Microsoft Excel 2000 Bible is a comprehensive reference for probably the most powerful spreadsheet package available. Beginning with the basics, the author explores the huge number of features that Excel has to offer, in a style that is clear and friendly, but businesslike.

He pulls off the trick of providing for everyone. If you've never used a spreadsheet, or even if you are not that familiar with computers, all is explained in the introductory chapters. If you're familiar with Excel 97, there is a quick update on what's new in 2000. If you're an expert user already, you might skip the basic chapters and look for specific features you want to know more about.

This book will be equally at home in the hands of a spreadsheet novice wanting a bar-chart as on the desk of an Excel wizard constructing databases, pivot tables and VB scripts. It is abundantly illustrated, indexed, and easy to find your way around. As in all the IDG Bible series, marginal icons serve to highlight new features, useful tips and common pitfalls.

The introductory chapters explain the various menus and toolbars and look at entering data, navigating around the worksheet and formatting rows and columns. Following this are chapters on using cell ranges, formulas and lookup functions. Along with charts and graphics the principles of designing your spreadsheet for presentations are considered. The later more advanced sections, taking up about half the book, cover topics such as Array Formulas, the new Internet features in Excel 2000, Data Analysis and Visual Basic (VB) programming. An appendix is provided for users wishing to import formulas from Lotus 1-2-3. The CD-ROM which comes with the book contains many of the authors own utilities, and even some games written entirely in Excel to illustrate its programming potential. --Frank Pennycook

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!

About the Author
John Walkenbach is one of the country′s leading authorities on spreadsheet software. He holds a Ph.D. from the Univerity of Montana and has worked as an instructor, programmer, and market research manager. He finally found a job he′s good at: principal of JWalk and Associates Inc., a one–person San Diego–based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the award–winning Power Utility Pak add–in for Excel –– which is used by thousands of people throughout the world. John started writing about spreadsheets in 1984, and he has since written more than 250 srticles and reviews for publications such as PC World, InfoWorld, Windows magazine, and PC/Computing. In addition he′s the author of a dozen other spreadsheet books, including Excel 2000 Power Programming Techniques, Excel Programming For Dummies and Excel 2000 For Windows For Dummies Quick Reference (all from IDG Books Worldwide). In his spare time John enjoys digital photography and composing and playing music in a variety of styles. John also maintains "The Spreadsheet Page" on the Web. Pay him a visit at http://www.j–walk.com.

Customer Reviews

Excel-lent !
This really is an excellent book which is well written and is fantastic value for money. I needed a book which would suit my needs as a reasonably knowledgeable Excel user and also as a learning tool for my wife who is developing her use of Excel. The book has met the needs for both of us. The book is written in plain, user friendly text with the CD providing excellent examples. I've found the chapters on VBA and macros really useful which I have been able to apply instantly to important work projects. The introductory chapters have proved invaluable to my wife and her knowledge has developed at an incredible rate. If you are considering which of the numerous books on Excel out there to invest in, I can recommend that this will not disappoint you and will be hard earned cash very well spent.

Excellent Starting Point
I'd barely even looked at Excel before investing in this book, but as Excel had been made available to me in my workplace, I was determined to do something with it.

Four months on, and four Walkenback books later, I can safely say that this book was worth every penny. It takes the reader through the history of Excel, and outlines the differences between the popular versions in use today. Should you be using a version prior to Excel 2000, the book will note when the items being discussed are new to Excel 2000. You'll gain alot from this book if you're using Excel 97.

The book assumes no prior knowledge of Excel whatsoever - it takes you through the common interfaces that most Microsoft Office programs share, through the basics of saving and loading workbooks, right through up to working with external databases, goal seeking, and and customising toolbars. The final six chapters of the book even touch on the wonderful world of VBA (Visual Basic for Applications), the powerful programming language behind the Office programs.

Having a PDF version of the book on the enclosed CD was invaluable - far easier to browse the book on screen, than sit with a 1000 page book on my lap!

I would have been lost without this book. Definitely should be on the shelf for any beginner/intermediate user of Excel.

Excellent for intermediate and advanced users
Comprhensive yet in plain English. This book would be useful for even a complete beginner. I have found it very useful for more advanced topics, for example pivot tables and visual basic. I also found it useful for assisting me to prepare training material.