Excel for Chemists : A Comprehensive Guide /
"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"--
| Main Author: | |
|---|---|
| Format: | text |
| Language: | eng |
| Published: |
Hoboken, NJ : Wiley,
2011
|
| Subjects: |
| _version_ | 1826449585933910016 |
|---|---|
| author | Billo, E. Joseph., author 179743 |
| author_facet | Billo, E. Joseph., author 179743 |
| author_sort | Billo, E. Joseph., author 179743 |
| collection | OCEAN |
| description | "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"-- |
| first_indexed | 2024-03-05T11:42:38Z |
| format | text |
| id | KOHA-OAI-TEST:464256 |
| institution | Universiti Teknologi Malaysia - OCEAN |
| language | eng |
| last_indexed | 2024-03-05T11:42:38Z |
| publishDate | 2011 |
| publisher | Hoboken, NJ : Wiley, |
| record_format | dspace |
| spelling | KOHA-OAI-TEST:4642562021-06-10T03:00:49ZExcel for Chemists : A Comprehensive Guide / Billo, E. Joseph., author 179743 textHoboken, NJ : Wiley,2011©2011eng"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"--"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."--Includes bibliographical references and index.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."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"--"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."--PSZ_JBMicrosoft Excel (Computer file)Electronic spreadsheetsChemistryURN:ISBN:9780470381236 |
| spellingShingle | Microsoft Excel (Computer file) Electronic spreadsheets Chemistry Billo, E. Joseph., author 179743 Excel for Chemists : A Comprehensive Guide / |
| title | Excel for Chemists : A Comprehensive Guide / |
| title_full | Excel for Chemists : A Comprehensive Guide / |
| title_fullStr | Excel for Chemists : A Comprehensive Guide / |
| title_full_unstemmed | Excel for Chemists : A Comprehensive Guide / |
| title_short | Excel for Chemists : A Comprehensive Guide / |
| title_sort | excel for chemists a comprehensive guide |
| topic | Microsoft Excel (Computer file) Electronic spreadsheets Chemistry |
| work_keys_str_mv | AT billoejosephauthor179743 excelforchemistsacomprehensiveguide |