How to Use Excel® in Analytical Chemistry

This textbook provides a comprehensive guide to using Excel for chemical analysis, making it a valuable resource for students in analytical chemistry.

In How to Use Excel® in Analytical Chemistry, readers are introduced to the powerful capabilities of Excel as a tool for scientific computing. The textbook is designed specifically for undergraduate and entry-level graduate students in chemistry and chemical engineering. With its intuitive layout and extensive mathematical functions, Excel serves as an accessible platform for exploring and solving various problems in chemical analysis. This resource stands out as the only contemporary text dedicated to the application of spreadsheets in the field of chemistry.

The book covers a wide range of topics essential for students, including statistical methods, chemical equilibria, pH calculations, and titration procedures. It delves into instrumental techniques such as chromatography, spectrometry, and electroanalysis, providing numerous examples of data analysis. The text emphasizes the use of spreadsheets for numerical simulations and testing analytical procedures, making complex concepts more approachable for learners.

Additionally, How to Use Excel® in Analytical Chemistry explores modern data analysis methods, including linear and non-linear least squares and Fourier transformation techniques. Readers will discover how matrix methods can be effectively applied within spreadsheets and learn to simulate chemical kinetics. The introduction of VBA, the macro language of Microsoft Office, further enhances the book's value, allowing users to integrate advanced computer programs into their spreadsheets, thus expanding their analytical capabilities.