An instructional and reference manual on the use of Microsoft Excel for chemical applications. The first half is a sourcebook of instructions for Excel using chemical examples throughout to illustrate the techniques. The second half explains how to use Excel's built-in worksheet functions to perform advanced calculations, once again illustrated with chemical applications. The book also offers useful macros and spread-sheets for solving a variety of chemistry problems.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 25.5 cm
Breite: 18 cm
Gewicht
ISBN-13
978-0-471-18896-4 (9780471188964)
Schweitzer Klassifikation
Part 1: the basics; working with Excel. Part 2: advanced spreadsheet topics; advanced equation building; worksheet functions; macros - an introduction; macro functions for Excel 4.0 macro language; creating command macros in Excel 4.0; creating function macros in Excel 4.0; Excel 5.0 macro language - Visual Basic for application; creating custom menus, menu Bars and toolbars; advanced spreadsheet techniques; advanced charting techniques; database techniques. Part 3: mathematical methods for chemists; getting experimental data into Excel; some mathematical tools for spreadsheet calculation; graphical and numerical methods of analysis; single variable statistics; linear regression; non-linear regression; analysis of solution equilibria; analysis of spectrophotometric data; measurements and calculation of binding constants; analysis of kinetic data.
