Includes index

How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis by Robert de Levie is a comprehensive textbook that demonstrates how Microsoft Excel can be used as a powerful tool for analytical chemistry and broader scientific data analysis. The book explains how spreadsheets can support scientific computing, statistical analysis, numerical simulations, and graphical interpretation of experimental data. It is designed mainly for undergraduate and graduate students in chemistry, chemical engineering, and related scientific disciplines.

The text begins with an introduction to Excel and spreadsheet fundamentals, including graphing, formulas, and data organization. It then progresses to advanced analytical methods such as Gaussian statistics, least-squares fitting, nonlinear regression, error propagation, and weighted averaging. The book also covers chemical equilibrium calculations, pH analysis, titration curves, spectroscopy, chromatography, electrochemical analysis, Fourier transformation, and numerical simulation of chemical kinetics.

A major strength of the book is its emphasis on practical scientific problem-solving using Excel tools such as Solver and Visual Basic for Applications (VBA). Rather than simply providing templates, the author teaches readers how to design and build their own sophisticated spreadsheets for research and laboratory applications. The book demonstrates how Excel can be used for modeling, simulation, curve fitting, signal processing, and data visualization in analytical chemistry and scientific research

http://172.20.27.22:4000/handle/123456789/165