Product Description

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.

Product Details

• Amazon Sales Rank: #363870 in Books
• Published on: 2000-01-28
• Original language: English
• Number of items: 1
• Binding: Hardcover
• 1381 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
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

About the Author
About the Author John Walkenbach is a leading authority on spreadsheet software, and principal of JWalk and Associates Inc., a Southern California–based consulting firm that specializes in spreadsheet application development. John is the author of about 30 spreadsheet books, and has written more than 300 articles and reviews for a variety of publications, including PC World, Info World, PC Magazine, Windows, and PC/Computing magazines. He′s currently contributing editor for PC World and writes the magazine′s monthly "Here′s How" spreadsheet tips column. He also maintains a popular Internet Web site called "The Spreadsheet Page" at www.j–walk.com/ss, and is the developer of the Power Utility Pak, an award–winning add–in for Microsoft Excel. John graduated from the University of Missouri, and earned a Ph.D. from the University of Montana. John′s other interests include guitar, MIDI music, novels, digital photography, and gardening.

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.