Task-oriented and presented in a logical sequence, "Microsoft Excel 97 Quick Reference" delivers beyond beginners' books to get the problem-solving job done for casual to advanced users. The smaller trim size is ideal for desktop reference or travel, yet the contents are comprehensive.
Learn how to create spreadsheets for performing important tasks, such as analyzing income, budgeting, and tracking projects. Here is a concise and friendly training solution for beginners. The core of the book is a logical sequence of straightforward, easy-to-follow instructions for building useful business documents.
Organizations everywhere are discovering that Microsoft Excel is a powerful development tool--and now features important Intranet and Internet capabilities. That's why the third edition of this classic is the one-volume reference for application programmers who want fast, easy ways to produce custom business information solutions.
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
This" Step by Step" title allows readers to start anywhere they like and learn at their own pace and convenience. Example-based training helps users to retain knowledge better. The CD-ROM completes the picture with practice files to be used with the lesson.
Visual Basic is the built-in graphical programming language in Microsoft Excel. This guide is a procedural, personal training system for those who want to get up and running on visual basic for applications in Excel easily and quickly. Modular lessons let users start wherever they want and learn at their own convenience and their own pace.
The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how to best use Excel's features for computations, circuit modeling, graphing, and data analysis as applied to electronics design. Separate chapters cover lookup tables and file I/O, using macros, graphing, controls, using Analysis Toolpak for statistical analysis, databases, and linking into Excel from other sources, such as data from a serial port. The book is basically an engineering cookbook, with each chapter providing tutorial information along with several Excel "recipes" of interest to electronics engineers. The accompanying CD-ROM features ready-to-run, customizable Excel worksheets derived from the book examples, which will be useful tools to add to any electronics engineer's spreadsheet toolbox. Engineers are looking for any and all means to increase their efficiency and add to their "bag of design tricks." Just about every electronics engineer uses Excel but most feel that the program has many more features to offer, if they only knew what they were! The Excel documentation is voluminous and electronics engineers don't have the time to read it all and sift through looking for those features that are directly applicable to their jobs and figure out how to use them. This book does that task for them-pulls out those features that they need to know about and shows them how to make use of them in specific design examples that they can then tailor to their own design needs. *This is the ONLY book to deal with Excel specifically in the electronics field *Distills voluminous and time-consuming Excel documentation down to nitty-gritty explanations of those features that are directly applicable to the electronics engineer's daily job duties *The accompanying CD-ROM provides ready-to-use, fully-customizable worksheets from the book's examples