Excel for Chemists, 3ed. ♦ E. Joseph Billo

**Manfenix** Sáb Mayo 19, 2012 7:34 pm

Table of Contents
PART I THE BASICS
Chapter 1 Working with Excel 2007 or Excel 2010
Chapter 2 Working with Excel 2003
Chapter 3 Excel Formulas and Functions
Chapter 4 Excel 2007/2010 Charts
Chapter 5 Excel 2003 Charts

PART II ADVANCED SPREADSHEET TOPICS
Chapter 6 Advanced Worksheet Formulas
Chapter 7 Array Formulas
Chapter 8 Advanced Charting Techniques
Chapter 9 Using Excel's Database Features
Chapter 10 Importing Data into Excel
Chapter 11 Adding Controls to a Spreadsheet
Chapter 12 Other Language Versions of Excel

PART III SPREADSHEET MATHEMATICS
Chapter 13 Mathematical Methods for Spreadsheet Calculations
Chapter 14 Linear Regression and Curve Fitting
Chapter 15 Nonlinear Regression Using the Solver

PART IV EXCEL'S VISUAL BASIC FOR APPLICATIONS
Chapter 16 Visual Basic for Applications: An Introduction
Chapter 17 Programming with VBA
Chapter 18 Working with Arrays in VBA

PART V SOME APPLICATIONS OF VBA
Chapter 19 Command Macros
Chapter 20 Custom Functions
Chapter 21 Automatic Procedures
Chapter 22 Custom Menus
Chapter 23 Custom Toolbars and Toolbuttons

PART VI APPENDICES
Appendix A What's Where in Excel 2007/2010
Appendix B Selected Worksheet Functions by Category
Appendix C Alphabetical List of Selected Worksheet Functions
Appendix D Renamed Functions in Excel 2010
Appendix E Selected Visual Basic Keywords by Category
Appendix F Alphabetical List of Selected Visual Basic Keywords
Appendix G Selected Excel 4 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
INDEX