Excel for chemists : a comprehensive guide / E. Joseph Billo.

Format:

Book

Author/Creator:

Billo, E. Joseph.

Language:

English

Subjects (All):

Electronic spreadsheets.

Chemistry--Data processing.

Chemistry.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (xxvii, 764 pages) : illustrations (chiefly colour)

Edition:

3rd ed.

Place of Publication:

Hoboken, N.J. : John Wiley & Sons, c2011.

Summary:

"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, biochemical, physical, engineering, biological, and medicinal calculations. Including a CD-ROM for Windows, this new edition provides chemists and students with the a detailed guide to using the current versions of Excel (Excel 2007 and 2010), Excel 2003, as well as many other new applications. A wide range of methods is described, including creating advanced spreadsheet formulas to using Excel's built-in functions and tools, to creating advanced macros using Excel's Visual Basic."--Provided by publisher.

Contents:

PART I THE BASICS

Chapter 1 Working with Excel 2007 or Excel 2010

Chapter 2 Working with Excel 2003

Chapter 3 Excel Formulas and Functions

Chapter 4 Excel 2007/2010 Charts

Chapter 5 Excel 2003 Charts

PART II ADVANCED SPREADSHEET TOPICS

Chapter 6 Advanced Worksheet Formulas

Chapter 7 Array Formulas

Chapter 8 Advanced Charting Techniques

Chapter 9 Using Excel's Database Features

Chapter 10 Importing Data into Excel

Chapter 11 Adding Controls to a Spreadsheet

Chapter 12 Other Language Versions of Excel

PART III SPREADSHEET MATHEMATICS

Chapter 13 Mathematical Methods for Spreadsheet Calculations

Chapter 14 Linear Regression and Curve Fitting

Chapter 15 Nonlinear Regression Using the Solver

PART IV EXCEL'S VISUAL BASIC FOR APPLICATIONS

Chapter 16 Visual Basic for Applications: An Introduction

Chapter 17 Programming with VBA

Chapter 18 Working with Arrays in VBA

PART V SOME APPLICATIONS OF VBA

Chapter 19 Command Macros

Chapter 20 Custom Functions

Chapter 21 Automatic Procedures

Chapter 22 Custom Menus

Chapter 23 Custom Toolbars and Toolbuttons

PART VI APPENDICES

Appendix A What's Where in Excel 2007/2010

Appendix B Selected Worksheet Functions by Category

Appendix C Alphabetical List of Selected Worksheet Functions

Appendix D Renamed Functions in Excel 2010

Appendix E Selected Visual Basic Keywords by Category

Appendix F Alphabetical List of Selected Visual Basic Keywords

Appendix G Selected Excel 4 Macro Functions

Appendix H Shortcut Keys by Keystroke

Appendix I Selected Shortcut Keys by Category

Appendix J ASCII Codes

Appendix K Contents of the CD-ROM.

Notes:

Includes index.

ISBN:

9786613332127

9781283332125

1283332124

9781118093948

1118093941

9781118093955

111809395X

9781118093931

1118093933

OCLC:

768243490