Spreadsheet Applications in Chemistry Using Microsoft Excel

Find step-by-step tutorials on scientific data processing in the latest versions of Microsoft Excel

The Second Edition of Spreadsheet Applications in Chemistry Using Microsoft Excel delivers a comprehensive and up-to-date exploration of the application of scientific data processing to Microsoft Excel. Written to incorporate the latest updates and changes found in Excel 2019, as well as later versions, this practical textbook is tutorial-focused and offers simple, step-by-step instructions for scientific data processing tasks commonly used by undergraduate students.

Readers will also benefit from an online repository of datasets that can be used to work through the tutorials and gain familiarity with the applications discussed within.

This latest edition incorporates new and revised content on statistical analysis and regression analysis using Excel add-ins, explains differences in navigation and utility between Windows and MacOS versions of the software, and integrates an online exercise tool that can be used to practice the included techniques.

Spreadsheet Applications in Chemistry Using Microsoft Excel also includes:



A thorough introduction to Microsoft Excel and spreadsheets, including Excel commands, cell references, ranges, arrays, and entering and editing data
Comprehensive explorations of statistical functions and regression analysis, including discussions of the Data Analysis ToolPak and linear and nonlinear regression
Practical discussions of macros and Visual Basic for Applications, including functions
In-depth case studies in quantum chemistry, physical chemistry, as well as discussions of how to import and process instrumental data

Perfect for undergraduate and graduate students of analytical and physical chemistry, Spreadsheet Applications in Chemistry Using Microsoft Excel is also an ideal resource for students and practitioners of physics, engineering, and biology.