Excel for Chemists, with CD-ROM: A Comprehensive GuideReviews from previous editions: "Excel for Chemists should be part of any academic library offering courses and programs in Chemistry." "I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift." The newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the program. Featuring clear step-by-step instructions, Excel for Chemists illustrates how to use the scientific calculating power of Excel to perform a variety of chemical calculations. Including a CD-ROM for Windows, this new edition provides chemists and students with a detailed guide to using the current versions of Excel (Excel 2007 and 2010) as well as Excel 2003. Additional features in this third edition include:
|
Contents
Working with Excel 2007 or Excel 2010 | 3 |
An Overview | 10 |
Navigating Around the Worksheet | 18 |
Working with Excel 2003 | 79 |
Working with Excel 2003 | 81 |
Navigating Around the Worksheet | 85 |
Entering a Cell Comment | 92 |
Editing a Worksheet | 98 |
SPREADSHEET MATHEMATICS | 401 |
Mathematical Methods for Spreadsheet Calculations | 407 |
Numerical Integration | 415 |
Solving Sets of Simultaneous Linear Equations | 425 |
Significant Figures | 432 |
Multiple Linear Regression | 438 |
Linear Regression and Curve Fitting | 443 |
Nonlinear Regression Using the Solver | 463 |
Formatting Worksheets | 108 |
Excel Formulas and Functions 137 | 119 |
Excel Formulas and Functions | 137 |
Excel 20072010 Charts | 179 |
Excel 2003 Charts | 209 |
Excel 2003 Charts | 211 |
ADVANCED SPREADSHEET TOPICS | 231 |
Defining Names in Excel 20072010 | 240 |
Lookup Functions | 249 |
Array Formulas | 267 |
Array Formulas | 269 |
Evaluating Polynomials or Power Series Using Array Formulas | 273 |
Validating a CAS Registry Number | 286 |
Advanced Charting Techniques | 291 |
Using Excels Database Features | 327 |
Using Excels Database Features | 329 |
Using AutoFilter to Obtain a Subset of a List | 335 |
Importing Data into Excel | 349 |
Importing Data into Excel | 351 |
From Hard Copy Paper to Excel | 358 |
Adding Controls to a Spreadsheet | 365 |
Adding Controls to a Spreadsheet | 373 |
Using Data Validation | 378 |
Other Language Versions of Excel | 385 |
Other Language Versions of Excel | 387 |
Nonlinear Regression Using the Solver | 465 |
EXCELS VISUAL BASIC FOR APPLICATIONS | 489 |
Programming with | 503 |
Programming with VBA | 505 |
Methods | 512 |
Working with Arrays in VBA | 545 |
SOME APPLICATIONS OF | 555 |
A Sub Procedure to Apply Precision as Displayed | 562 |
Create Excel 20072010 Charts with One Click | 568 |
Custom Functions | 573 |
Automatic Procedures | 589 |
Automatic Procedures | 591 |
Modifying Menu Bars Menus or Menu Commands in Excel 2003 | 595 |
Custom Menus | 597 |
Installing Menu Bars Menus or Menu Commands in Excel 20072010 | 603 |
Custom Toolbars and Toolbuttons | 609 |
APPENDICES | 629 |
Alphabetical List of Selected Worksheet Functions | 639 |
Renamed Functions in Excel 2010 | 661 |
Appendix F Alphabetical List of Selected Visual Basic Keywords | 667 |
Appendix G Selected Excel 4 Macro Functions | 689 |
Selected Shortcut Keys by Category | 703 |
Appendix K Contents of the CDROM | 709 |
| 719 | |
Other editions - View all
Common terms and phrases
Add-Ins argument array formula AutoFill Axis calculated cell containing cell or range cell reference Chapter characters chart element chart types Color Conditional Formatting Copy Ctrl data series database decimal default Define Name Delete dialog box Figure display document drop-down enter equation example Excel Tip filename extension Font Format Cells formula bar formula in cell Goal Seek Home tab Hyperlink Insert Integer linear regression LINEST list box logical value lookup macro menu command Microsoft Excel mouse pointer nonlinear regression number format Office Button OK Cancel Figure Options button Paste Special press OK Print Quick Access Toolbar Radar chart radians range of cells regression Related Functions Returns TRUE Ribbon rows or columns selected cell serial number sheet tab shortcut menu shown in Figure Solver specified spreadsheet submenu Syntax text box text string toolbutton Tools menu variable Visual Basic wildcard characters window workbook worksheet functions x-values zero