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 in Microsoft¯® Excel¯®. Written to incorporate the latest updates and changes found in Excel¯® 2021, 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 experimental datasets that can be used to work through the tutorials to gain familiarity with data processing and visualization in Excel¯®.

This latest edition incorporates new and revised content to use to learn the basics of Excel¯® for scientific data processing and now includes statistical analysis and regression analysis using Excel¯® add-ins, accounts for differences in navigation and utility between Windows and MacOS versions of the software, and integrates with an online dataset repository for the tutorial exercises.

Spreadsheet Applications in Chemistry Using Microsoft¯® Excel¯® also includes:

A thorough introduction to Microsoft¯® Excel¯® workbook and worksheet basics, including Excel¯® toolbar navigation, entering and manipulating formulas and functions and charting experimental chemical data
Comprehensive explorations of statistical functions and regression analysis
Generating calibration plots from instrumental data
Visualizing concepts in physical chemistry

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.

Auteur

Aoife Morrin, PhD, is Associate Professor in Analytical Chemistry at the School of Chemical Sciences at Dublin City University and Director of the DCU National Centre for Sensor Research. She is also Funded Investigator of the Insight SFI Research Centre for Data Analytics in Ireland.

Dermot Diamond, PhD, is Professor of Sensor Science and Materials Chemistry at Dublin City University and Field Chief Editor of the Journal "Frontiers in Sensors". He is also a Fellow of the Royal Society of Chemistry and Member of the Royal Irish Academy.