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.