Spreadsheet Applications In Chemistry Using Microsoft Excel

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

"Spreadsheets in Science and Engineering" shows scientists and engineers at all levels how to analyze, validate and calculate data and how the analytical and graphic capabilities of spreadsheet programs (ExcelR) can solve these tasks in their daily work. The examples on the CD-ROM accompanying the book include material of undergraduate to current research level in disciplines ranging from chemistry and chemical engineering to molecular biology and geology.

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

A practical guide 'Spreadsheets for Chemists' shows chemists of all levels how to use spreadsheet programs in their daily work. It highlights the possibilities provided by Lotus 1-2-3, the most widely used spreadsheet program in the sciences. Apart from hundreds of example fragments, it features: * Detailed discussion of the most relevant functions and all the () macro commands. * An accompanying diskette containing 57 worksheets involving many different fields of chemical research and teaching. * An extensive glossary of spreadsheet terms. * Three appendices covering 1-2-3's competitors and add-in packages, the use of Windows-based spreadsheets and how what-if analysis and back-solving is applied. Although the disk examples were developed for Lotus 1-2-3 DOS Versions 2.x (x=2-4), the worksheets are compatible with the newer Windows versions and those of their main competitors, Borland's Quattro Pro and Microsoft's Excel. Several compatible spreadsheets (AsEasyAs, Proqube) might also be as used as inexpensive alternatives. The author is a senior scientist at the Nuclear Research Centre in Karlsruhe, Germany. He has been using spreadsheet software for nearly ten years successfully in a variety of chemical problems.

Because of their intuitive layout, extensive mathematical capabilities, and convenient graphics, spreadsheets provide an easy, straightforward route to scientific computing. This textbook for undergraduate and entry-level graduate chemistry and chemical engineering students uses Excel, the most powerful available spreadsheet, to explore and solve problems in general and chemical data analysis. This is the only up-to-date text on the use of spreadsheets in chemistry. The book discusses topics including statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. It contains many examples of data analysis, and uses spreadsheets for numerical simulations, and testing analytical procedures. It also treats modern data analysis methods such as linear and non-linear least squares in great detail, as well as methods based on Fourier transformation. The book shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet and describes in detail how to simulate chemical kinetics on a spreadsheet. It also introduces the reader to the use of VBA, the macro language of Microsoft Office, which lets the user import higher-level computer programs into the spreadsheet.

This supplement can be used in any analytical chemistry course. The exercises teaches you how to use Microsoft Excel using applications from statistics, data analysis equilibrium calculations, curve fitting, and more. Operations include everything from basic arithmetic and cell formatting to Solver, Goal Seek, and the Data Analysis Toolpak. The authors show you how to use a spreadsheet to construct log diagrams and to plot the results. Statistical data treatment includes descriptive statistics, linear regression, hypothesis testing, and analysis of variance. Tutorial exercises include nonlinear regression such as fitting the Van Deemter equation, fitting kinetics data, determining error coefficients in spectrophotometry, and calculating titration curves. Additional features include solving complex systems of equilibrium equations and advanced graphical methods: error bars, charts with insets, matrices and determinants, and much more. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

In one volume, this book offers the reader a complete instructional and reference manual on using Microsoft Excel for chemical applications. The first half of the book is a sourcebook of instructions on Excel using chemical example throughout. The writing style and illustrations are far superior (for scientists) to manuals currently available. The second half of the book shows how to use Excel's built-in worksheet functions to perform advanced calculations, and illustrates these techniques with applications in chemistry. It also offers numerous useful macros and spreadsheets for solving a variety of chemistry problems. The book will be packaged with two diskettes, for Macintosh and Windows environments, respectively, that will include many spreadsheets and macros presented in the text.