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
Book 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.
Book Info
Presents everything you need to know to present worksheets complete with charts and graphics in less than one hour, customize and automate Excel to suit your needs, and post your spreadsheets on your Web page or a corporate intranet using Excel 2000. Softcover. CD-ROM included.
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® 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 functionsIllustrate your data with charts, drawings, maps, and other graphicsConsolidate and juggle multiple worksheets in a single workbookShare documents with a workgroup across a corporate intranet or the internetSave worksheets as HTML documents and publish them on your Web pageImport data from other databases or Office applications using queriesAnalyze data with pivot tables or "What if" scenarios, Goal Seeking and Solver, or the Analysis ToolPakAutomate Excel using templates, VBA macros, and custom worksheet functions and dialog boxes
Fully functional trial version of Power Utility Pack 97 on CD-ROM, with31 utilities40 custom worksheet functionsEnhanced shortcut menusGames for Excel
PlusAdobe Acrobat ReaderElectronic version of Internet Directory from Internet BiblePDF Version of the full bookWinZip 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.
Microsoft Excel 2000 Bible FROM THE PUBLISHER
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® 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 ExcelFully 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 bookShareware 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 copythem to as many PCs as you like—free—but they have no technical support. System Requirements: Pentium PC; Windows 95 or NT; Excel 2000 or Microsoft Office Professional or Developer's Edition
SYNOPSIS
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.
Art & Photography
Book Info
