Excel® for Chemists: A Comprehensive Guide - Softcover

Billo, E. Joseph

Softcover

ISBN 10: 0471188964 ISBN 13: 9780471188964

Publisher: Wiley–Blackwell, 1997

Synopsis

In one volume, this book offers the reader a complete instructional and reference manual on using Microsoft Excel for chemical applications. The first half of the book is a sourcebook of instructions on Excel using chemical example throughout. The writing style and illustrations are far superior (for scientists) to manuals currently available. The second half of the book shows how to use Excel′s built–in worksheet functions to perform advanced calculations, and illustrates these techniques with applications in chemistry. It also offers numerous useful macros and spreadsheets for solving a variety of chemistry problems. The book will be packaged with two diskettes, for Macintosh and Windows environments, respectively, that will include many spreadsheets and macros presented in the text.

About this title

From the Back Cover

Excel(r) for Chemists A Comprehensive Guide E. Joseph Billo Excel(r) for Chemists: A Comprehensive Guide is a complete instructional and reference manual for scientists and engineers on using Microsoft Excel(r) for all types of chemical applications. Written in a lively, engaging style and filled with hundreds of helpful illustrations and examples of chemical applications, the book′s special features include over 50 "Excel Tips" to help readers simplify and improve the way they use Excel, many "How–To Boxes" that outline clearly and systematically how to accomplish certain complex tasks, and a computer disk (usable in either Macintosh or Windows environments) that contains many useful spreadsheet templates, macros, and other tools. Each document is provided as a worksheet, which can be accessed by users of Excel 4.0, 5.0 or 7.0, or Excel 97. Using Excel(r) for Chemists, chemists, chemical engineers, and students can learn how to exploit Excel′s tremendous built–in scientific calculating power to create customized spreadsheets for solving their own particular chemical problems, ranging from the relatively simple to the highly complex. The book is divided into four parts. Part I covers the basics of spreadsheet operations and uses chemical examples throughout to illustrate the techniques. Part II shows how to use Excel′s wide range of worksheet functions to perform sophisticated chemical calculations, how to record simple macros to automate routine spreadsheet tasks, how to write advanced macros to carry out complex, repetitive calculations automatically, and how to create custom menus and toolbars. Part III introduces mathematical techniques that can be handled well in a spreadsheet environment–such as matrix mathematics, numerical differentiation and integration, and statistical, graphical, and numerical methods of analysis–and then shows how to apply them easily using Excel. In Part IV, the techniques introduced earlier are applied to a wide range of specific chemical problems. The extensive Appendices include useful lists of worksheet functions, macro functions, Visual Basic keywords, and shortcut keys.

Synopsis

An instructional and reference manual on the use of Microsoft Excel for chemical applications. The first half is a sourcebook of instructions for Excel using chemical examples throughout to illustrate the techniques. The second half explains how to use Excel's built-in worksheet functions to perform advanced calculations, once again illustrated with chemical applications. The book also offers useful macros and spread-sheets for solving a variety of chemistry problems.

Edition details

• Publisher: Wiley–Blackwell
• Publication date: 1997
• ISBN 10: 0471188964
• ISBN 13: 9780471188964
• Binding: Paperback
• Language: English
• Number of pages: 480