Excel for chemists : a comprehensive guide /
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | eBook |
| Language: | English |
| Published: |
New York :
Wiley-VCH,
[2001]
|
| Edition: | 2nd ed. |
| Subjects: | |
| Online Access: | Connect to the full text of this electronic book |
Table of Contents:
- 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.