Billo E.J. Excel for Chemists: A Comprehensive Guide

John Wiley & Sons, Inc., 2011. - 738 p.Рассматриваются версии MS Excel 2007 и Excel 2010, а также более ранние версии.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 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 descriptionsPreface to the Third Edition
Before You Begini
PART I THE BASICS
Working with Exce2007 or Excel2010
Working with Exce2003
Excel Formulas and Functions
Exce2007/2010 Charts
Exce2003 Charts
PART II ADVANCED SPREADSHEET TOPICS
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
PART III SPREADSHEET MATHEMATICS
Mathematical Methods for Spreadsheet Calculations
Linear Regression and Curve Fitting
Nonlinear Regression Using the Solver
PART IV Excel'S Visual Basic for Applications
Visual Basic for Applications: An Introduction
Programming with VBA
Working with Arrays in VBA
PART V SOME APPLICATIONS OF VBA
Command Macros
Custom Functions
Automatic Procedures
Custom Menus
Custom Toolbars and Toolbuttons
PART VI APPENDICES
Appendix A What's Where in Exce2007/2010
Appendix B Selected Worksheet Functions by Category
Appendix C Alphabetical List of Selected Worksheet Functions
Appendix D Renamed Functions in Exce2010
Appendix E Selected Visual Basic Keywords by Category
Appendix F Alphabetical List of Selected Visual Basic Keywords
Appendix G Selected Excel Macro Functions
Appendix H Shortcut Keys by Keystroke
Appendix I Selected Shortcut Keys by Category
Appendix J ASCII Codes
Appendix K Contents of the CD-ROM