Spreadsheet Applications in Chemistry Using Microsoft Excel

This book illustrates how EXCEL can be used to help scientists process, analyze, and present scientific data. EXCEL provides a flexible environment that can be used to prepare spreadsheet solutions for scientific data processing problems. It demonstrates step-by-step how to program EXCEL to perform appropriate tasks, automate repetitive data processing tasks, and prepare integrated documents by transferring data and graphics. It covers problems such as how to perform linear regression and use the built-in statistical tools of EXCEL, as well as addressing advanced topics such as graphing complex equations, model building and the use of VBA and macros for user interface. Though the examples emphasize chemical applications, the information provided will prove useful to all scientists.

Dermot Diamond, PhD, Senior Lecturer at the Dublin City University School of Chemical Sciences, is currently the Director of the DCU Biomedical and Environmental Sensor Technology (BEST) Centre.

Venita C. A. Hanratty, PhD, has lectured at Trinity College Dublin and Dublin City University in physical chemistry and computer applications in chemistry. Currently, she is a software support specialist with Digital Equipment Ireland, Ltd.