9780470381236

Excel for Chemists, with CD-ROM A Comprehensive Guide

by
  • ISBN13:

    9780470381236

  • ISBN10:

    047038123X

  • Edition: 3rd
  • Format: Paperback
  • Copyright: 9/21/2011
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • We Buy This Book Back!
    In-Store Credit: $3.15
    Check/Direct Deposit: $3.00

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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 instruction, 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 both Mac and Windows, this new edition provides chemists and students with the current version of Excel (Excel 2007), Excel 2003, and Excel 2008 for Macintosh, as well as many other new applications.

Author Biography

E. Joseph Billo retired in 2006 as Associate Professor of Chemistry at Boston College and is the author of Excel for Chemists: A Comprehensive Guide, Second Edition. He has presented the two-day short courses "Advanced Excel for Scientists and Engineers" and "Excel Visual Basic Macros for Scientists and Engineers" to over 2,000 scientists at corporate clients in the U.S., Canada, and Europe.

Table of Contents

Preface to the Third Edition xxv

Before You Begin xxvii

PART I THE BASICS

Chapter 1 Working with Excel 2007 or Excel 2010 3

Chapter 2 Working with Excel 2003 79

Chapter 3 Excel Formulas and Functions 137

Chapter 4 Excel 2007/2010 Charts 177

Chapter 5 Excel 2003 Charts 209

PART II ADVANCED SPREADSHEET TOPICS

Chapter 6 Advanced Worksheet Formulas 233

Chapter 7 Array Formulas 267

Chapter 8 Advanced Charting Techniques 289

Chapter 9 Using Excel's Database Features 327

Chapter 10 Importing Data into Excel 349

Chapter 11 Adding Controls to a Spreadsheet 365

Chapter 12 Other Language Versions of Excel 385

PART III SPREADSHEET MATHEMATICS

Chapter 13 Mathematical Methods for Spreadsheet Calculations 403

Chapter 14 Linear Regression and Curve Fitting 435

Chapter 15 Nonlinear Regression Using the Solver 463

PART IV EXCEL'S VISUAL BASIC FOR APPLICATIONS

Chapter 16 Visual Basic for Applications: An Introduction 491

Chapter 17 Programming with VBA 503

Chapter 18 Working with Arrays in VBA 543

PART V SOME APPLICATIONS OF VBA

Chapter 19 Command Macros 557

Chapter 20 Custom Functions 571

Chapter 21 Automatic Procedures 589

Chapter 22 Custom Menus 595

Chapter 23 Custom Toolbars and Toolbuttons 607

PART VI APPENDICES

Appendix A What's Where in Excel 2007/2010 629

Appendix B Selected Worksheet Functions by Category 63 3

Appendix C Alphabetical List of Selected Worksheet Functions 639

Appendix D Renamed Functions in Excel 2010 661

Appendix E Selected Visual Basic Keywords by Category 663

Appendix F Alphabetical List of Selected Visual Basic Keywords 667

Appendix G Selected Excel 4 Macro Functions 689

Appendix H Shortcut Keys by Keystroke 693

Appendix I Selected Shortcut Keys by Category 703

Appendix J ASCII Codes 707

Appendix K Contents of the CD-ROM 709

INDEX 719

Rewards Program

Write a Review