Publisher's Synopsis
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.
