Excel for Chemists (eBook)

E. JOSEPH BILLO is an Associate Professor in the Department of Chemistry at Boston College in Chestnut Hill, Massachusetts.

Preface.

Preface to the First Edition.

Before You Begin.

THE BASICS

Working with Excel.

Creating Charts: An Introduction.

ADVANCED SPREADSHEET TOPICS.

Creating Advances Worksheet Formulas.

Creating Array Formulas.

Advanced Charting Techniques.

Using Excel's Database Features.

Getting Data into Excel.

Adding Controls to a Spreadsheet.

SPREADSHEET MATHEMATICS.

Some Mathematical Tools for Spreadsheet Calculations.

Graphical and Numerical Methods of Analysis.

Linear Regression.

Non-Linear Regression Using the Solver.

EXCEL VISUAL BASIC MACROS.

Visual Basic for Applications: An Introduction.

Programming with VBA.

Working with Arrays in VBA.

Creating Command Macros.

Creating Custom Functions.

Creating Custom Menus and Menu Bars.

Creating Custom Tools and Toolbars.

SOME APPLICATIONS.

Analysis of Solution Equilibria.

Analysis of Spectrophotometric Data.

Calculation of Binding Constants.

Analysis of Kinetics Data.

APPENDICES.

Appendix A: Selected Worksheet Functions by Category.

Appendix B: Alphabetical List of Selected Worksheet Functions.

Appendix C: Selected Visual Basic Keywords by Category.

Appendix D: Alphabetical List of Selected Visual Basic Keyword.

Appendix E: Shortcut Keys for PC and Macintosh.

Appendix F: Selected Shortcut Keys by Category.

Appendix G: About the CD-ROM That Accompanies This Book.

INDEX.

"...designed to help chemists in industry, academia, or government make use of the full capacity of Excel." (SciTech Book News, Vol. 25, No. 3, September 2001)
"As a venture capitalist, I negotiate every day. Michael Watkins' book is the first I have found that truly grapples with complications of real-world negotiations. The book provides the reader with a practical framework for plotting strategy and is chock full of relevant case studies and solid advice on getting the most from every negotiation. As I read this book, I was struck at how often I was able to apply the tools and techniques to my past and current experiences in negotiation. Watkins' book is a powerful tool for anybody who wants to take control and come out on top. I wish I had read it 20 years ago," (John F. Eckert Founder and Managing Partner, McLean Watson Capital Inc.: and President, Canadian Venture Capital Association)