Spreadsheet Applications in Chemistry Using Microsoft Excel Data Processing and Visualization

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 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.

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.

1. Introduction to Excel  
2. Statistical Analysis of Experimental Data 
3. Regression Analysis  
4. Calibration Plots in Analytical Chemistry  
5. Visualizing concepts in Physical Chemistry  
6. Regression Analysis using Solver 

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.