Excel for Chemists

A Comprehensive Guide

(Autor)

Buch | Softcover
512 Seiten
2001 | 2nd Revised edition
John Wiley & Sons Inc (Verlag)
978-0-471-39462-4 (ISBN)

Lese- und Medienproben

Excel for Chemists - E. Joseph Billo
72,55 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
Offering courses and programs in chemistry, this book deals with the application of Excel for analysing chemical data. It contains examples of chemical applications, 'how to' boxes outlining how to accomplish complex tasks in Excel, and instructions for programming Excel to automate repetitive data-processing tasks.
""Excel [registered] for Chemists" should be part of any academic library offering courses and programs in chemistry. There is no other book on the market that deals so thoroughly with the application of Excel for analysing chemical data. Highly recommended, for upper-division undergraduates through professionals." - "Choice". "I highly recommend this book; treat yourself to it; assign it to a class; give it as a gift." - "The Nucleus". Chemists across all sub-disciplines use Excel to record data in tabular form, but few have learned to take full advantage of the scientific calculating power within this program. Excel is capable of helping chemists process, analyse, and present scientific data, from the relatively simple to the highly complex. "Excel [registered] for Chemists, Second Edition" has been revised and updated, not only to take into account the changes that were made in Excel, but also to incorporate an abundance of new examples.
Arranged in a user-friendly format, this book contains illustrations and examples of chemical applications, useful "How to" boxes outlining how to accomplish complex tasks in Excel, and step-by-step instructions for programming Excel to automate repetitive data-processing tasks. In addition, tips are provided to speed, simplify, and improve your use of Excel. Included is a CD-ROM, usable in either Macintosh or IBM/Windows environments with many helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Edition feature: array formulas covered in depth in a separate chapter, along with a comprehensive review of using arrays in VBA; how to create a worksheet with controls, such as option buttons, check boxes, or a list box; and an extensive list of shortcut keys - over 250 for Macintosh or PC - is provided in the appendix. Whether as a text for students or as a reference for chemical professionals in industry, academia, or government, "Excel [registered] for Chemists, Second Edition" provides a valuable resource for using Excel to manage various chemical calculations.

E. JOSEPH BILLO is an Associate Professor in the Department of Chemistry at Boston College in Chestnut Hill, Massachusetts.

Preface. Preface to the First Edition. Before You Begin. THE BASICS Working with Excel. Creating Charts: An Introduction. ADVANCED SPREADSHEET TOPICS. Creating Advances Worksheet Formulas. Creating Array Formulas. Advanced Charting Techniques. Using Excel's Database Features. Getting Data into Excel. Adding Controls to a Spreadsheet. SPREADSHEET MATHEMATICS. Some Mathematical Tools for Spreadsheet Calculations. Graphical and Numerical Methods of Analysis. Linear Regression. Non--Linear Regression Using the Solver. EXCEL VISUAL BASIC MACROS. Visual Basic for Applications: An Introduction. Programming with VBA. Working with Arrays in VBA. Creating Command Macros. Creating Custom Functions. Creating Custom Menus and Menu Bars. Creating Custom Tools and Toolbars. SOME APPLICATIONS. Analysis of Solution Equilibria. Analysis of Spectrophotometric Data. Calculation of Binding Constants. Analysis of Kinetics Data. APPENDICES. Appendix A: Selected Worksheet Functions by Category. Appendix B: Alphabetical List of Selected Worksheet Functions. Appendix C: Selected Visual Basic Keywords by Category. Appendix D: Alphabetical List of Selected Visual Basic Keyword. Appendix E: Shortcut Keys for PC and Macintosh. Appendix F: Selected Shortcut Keys by Category. Appendix G: About the CD--ROM That Accompanies This Book. INDEX.

Erscheint lt. Verlag 23.4.2001
Zusatzinfo Ill.
Verlagsort New York
Sprache englisch
Maße 181 x 252 mm
Gewicht 906 g
Einbandart Paperback
Themenwelt Informatik Office Programme Excel
Naturwissenschaften Chemie Allgemeines / Lexika
ISBN-10 0-471-39462-9 / 0471394629
ISBN-13 978-0-471-39462-4 / 9780471394624
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich