Excel for Chemists: A Comprehensive Guide, Third Edition

  • 9h 20m
  • E. Joseph Billo
  • John Wiley & Sons (US)
  • 2011

The newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations

Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the program. Featuring clear step-by-step instructions, Excel for Chemists illustrates how to use the scientific calculating power of Excel to perform a variety of chemical calculations.

Additional features in this third edition include:

  • How to perform a variety of chemical calculations by creating advanced spreadsheet formulas or by using Excel’s built-in tools
  • How to automate repetitive tasks by programming Excel’s Visual Basic for Applications
  • New chapters in this edition show how to import data from other language versions of Excel, and how to create automatic procedures
  • Several appendices provide extensive lists of useful shortcut keys and function descriptions

Whether as a text for students or as a reference for chemical professionals in industry, academia, or government, Excel for Chemists, Third Edition provides a valuable resource for using Excel to manage various chemical calculations.

About the Author

E. Joseph Billo retired in 2006 as Associate Professor of Chemistry at Boston College and is the author of Excel for Chemists: A Comprehensive Guide, Second Edition. He has presented the two-day short courses "Advanced Excel for Scientists and Engineers" and "Excel Visual Basic Macros for Scientists and Engineers" to over 2,000 scientists at corporate clients in the U.S., Canada, and Europe.

In this Book

  • Before You Begin
  • Working with Excel 2007 or Excel 2010
  • Working with Excel 2003
  • Excel Formulas and Functions
  • Excel 2007/2010 Charts
  • Excel 2003 Charts
  • Advanced Worksheet Formulas
  • Array Formulas
  • Advanced Charting Techniques
  • Using Excel's Database Features
  • Importing Data into Excel
  • Adding Controls to a Spreadsheet
  • Other Language Versions of Excel
  • Mathematical Methods for Spreadsheet Calculations
  • Linear Regression and Curve Fitting
  • Nonlinear Regression Using the Solver
  • Visual Basic for Applications—An Introduction
  • Programming with VBA
  • Working with Arrays in VBA
  • Command Macros
  • Custom Functions
  • Automatic Procedures
  • Custom Menus
  • Custom Toolbars and Toolbuttons