Excel for Chemists®: A Comprehensive Guide, Third Edition

✍ Scribed by E. Joseph Billo(auth.)

• Year: 2011
• Tongue: English
• Leaves: 738
• Category: Library

✦ Synopsis

Reviews from previous editions:

"Excel for Chemists should be part of any academic library offering courses and programs in Chemistry."
—Choice

"I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift."
—The Nucleus

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, Excelfor Chemists illustrates how to use the scientific calculating power of Excel to perform a variety of chemical calculations. 

Including a CD-ROM for Windows, this new edition provides chemists and students with a detailed guide to using the current versions of Excel (Excel 2007 and 2010) as well as Excel 2003.

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 show how to import data from other language versions of Excel, and how to create automatic procedures
• The accompanying CD contains a number of Excel macros to facilitate chemical calculations, including molecular weight, nonlinear regression statistics, and data interpolation
• Several appendices provide extensive lists of useful shortcut keys and function descriptions

Content:
Chapter 1 Working with Excel 2007 or Excel 2010 (pages 1–77):
Chapter 2 Working with Excel 2003 (pages 79–135):
Chapter 3 Excel Formulas and Functions (pages 137–175):
Chapter 4 Excel 2007/2010 Charts (pages 177–207):
Chapter 5 Excel 2003 Charts (pages 209–230):
Chapter 6 Advanced Worksheet Formulas (pages 231–266):
Chapter 7 Array Formulas (pages 267–288):
Chapter 8 Advanced Charting Techniques (pages 289–326):
Chapter 9 Using Excel's Database Features (pages 327–347):
Chapter 10 Importing Data into Excel (pages 349–364):
Chapter 11 Adding Controls to a Spreadsheet (pages 365–383):
Chapter 12 Other Language Versions of Excel (pages 385–399):
Chapter 13 Mathematical Methods for Spreadsheet Calculations (pages 401–433):
Chapter 14 Linear Regression and Curve Fitting (pages 435–462):
Chapter 15 Nonlinear Regression Using the Solver (pages 463–488):
Chapter 16 Visual Basic for Applications: An Introduction (pages 489–502):
Chapter 17 Programming with VBA (pages 503–542):
Chapter 18 Working with Arrays in VBA (pages 543–553):
Chapter 19 Command Macros (pages 555–570):
Chapter 20 Custom Functions (pages 571–588):
Chapter 21 Automatic Procedures (pages 589–594):
Chapter 22 Custom Menus (pages 595–605):
Chapter 23 Custom Toolbars and Toolbuttons (pages 607–625):