Microsoft Excel 2000 Bible - Softcover

Walkenbach, John

Softcover

ISBN 10: 0764532596 ISBN 13: 9780764532597

Publisher: John Wiley & Sons, 1999

Synopsis

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.

About this title

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 this edition

• Publisher: John Wiley & Sons
• Publication date: 1999
• ISBN 10: 0764532596
• ISBN 13: 9780764532597
• Binding: Paperback
• Number of pages: 984