CENTRAL LIBRARY

Welcome to Online Public Access Catalogue (OPAC)

Amazon cover image
Image from Amazon.com

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

By: Material type: TextTextPublication details: Hoboken, N.J. : John Wiley & Sons, ©2011.Edition: 3rd edDescription: 1 online resource (xxviii, 732 pages) : illustrationsContent type:
  • text
Media type:
  • computer
Carrier type:
  • online resource
ISBN:
  • 9781118093955
  • 111809395X
  • 9781118093931
  • 1118093933
  • 9781118093948
  • 1118093941
Subject(s): Genre/Form: Additional physical formats: Print version:: Excel for chemists.DDC classification:
  • 542/.85 22
LOC classification:
  • QD39.3.S67 B55 2011
Other classification:
  • SCI013000
Online resources:
Contents:
Front Matter -- The Basics. Working with Excel 2007 or Excel 2010 -- Working with Excel 2003 -- Excel Formulas and Functions -- Excel 2007/2010 Charts -- Excel 2003 Charts -- Advanced Spreadsheet Topics. Advanced Worksheet Formulas -- Array Formulas -- Advanced Charting Techniques -- Using Excel's Database Features -- Importing Data into Excel -- Adding Controls to a Spreadsheet -- Other Language Versions of Excel -- Spreadsheet Mathematics. Mathematical Methods for Spreadsheet Calculations -- Linear Regression and Curve Fitting -- Nonlinear Regression Using the Solver -- Excel's Visual Basic for Applications. Visual Basic for Applications: An Introduction -- Programming with VBA -- Working with Arrays in VBA -- Some Applications of VBA. Command Macros -- Custom Functions -- Automatic Procedures -- Custom Menus -- Custom Toolbars and Toolbuttons -- Appendices. Appendix A: 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 VBA Keywords -- Appendix G: Selected Excel 4 Macro Functions -- Appendix H: Selected Shortcut Keys by Keystroke -- Appendix I: Selected Shortcut Keys by Category -- Appendix J: ASCII Codes -- Appendix K: Contents of the CD-ROM -- Index.
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."--Provided by publisher.Summary: "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.
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

Front Matter -- The Basics. Working with Excel 2007 or Excel 2010 -- Working with Excel 2003 -- Excel Formulas and Functions -- Excel 2007/2010 Charts -- Excel 2003 Charts -- Advanced Spreadsheet Topics. Advanced Worksheet Formulas -- Array Formulas -- Advanced Charting Techniques -- Using Excel's Database Features -- Importing Data into Excel -- Adding Controls to a Spreadsheet -- Other Language Versions of Excel -- Spreadsheet Mathematics. Mathematical Methods for Spreadsheet Calculations -- Linear Regression and Curve Fitting -- Nonlinear Regression Using the Solver -- Excel's Visual Basic for Applications. Visual Basic for Applications: An Introduction -- Programming with VBA -- Working with Arrays in VBA -- Some Applications of VBA. Command Macros -- Custom Functions -- Automatic Procedures -- Custom Menus -- Custom Toolbars and Toolbuttons -- Appendices. Appendix A: 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 VBA Keywords -- Appendix G: Selected Excel 4 Macro Functions -- Appendix H: Selected Shortcut Keys by Keystroke -- Appendix I: Selected Shortcut Keys by Category -- Appendix J: ASCII Codes -- Appendix K: Contents of the CD-ROM -- Index.

"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."--Provided by publisher.

"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.

Includes index.

Print version record.

There are no comments on this title.

to post a comment.

Khulna University of Engineering & Technology

Funded by: HEQEP, UGC, Bangladesh