Excel for chemists: a comprehensive guide

Part I: The basics. Working with Excel

Creating charts: an introduction

Part II: Advanced spreadsheet topics. Creating advanced worksheet formulas

Creating array formulas

Advanced charting techniques

Using Excel's database features

Importing data into Excel

Adding controls to a spreadsheet

Part III: Spreadsheet mathematics. Some mathematical tools for spreadsheet calculations

Graphical and numerical methods of analysis

Linear regression

Non-linear regression using te solver

Part IV: Excel visual basic macros. Visual basic for applications: an introduction

Programming with VBA

Creating command macros

Creating custom functions

Creating custom menus and menu bars

Creating custom toolbuttons and toolbars

Part V: Some applications. Analysis of solution equilibria

Analysis of spectrophotometric data

Calculation of binding constants

Analysis of kinetics data

Part VI: Appendics.