Excel for Chemists, with CD-ROM: A Comprehensive Guide

— —

E. Joseph Billo (Department of Chemistry, Boston College, Chestnut Hill, Massachusetts)

Excel for Chemists, with CD-ROM

A Comprehensive Guide

E. Joseph Billo (Department of Chemistry, Boston College, Chestnut Hill, Massachusetts)

$127.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Blackwell Publishing
07 September 2011

Mathematics & Sciences; Chemistry; Excel

"Reviews from previous editions:

""Excel for Chemists should be part of any academic library offering courses and programs in Chemistry.""

—Choice

""I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift.""

—The Nucleus

The newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations

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

Including a CD-ROM for Windows, this new edition provides chemists and students with a detailed guide to using the current versions of Excel (Excel 2007 and 2010) as well as Excel 2003.

Additional features in this third edition include:

How to perform a variety of chemical calculations by creating advanced spreadsheet formulas or by using Excel’s built-in tools How to automate repetitive tasks by programming Excel’s Visual Basic for Applications New chapters show how to import data from other language versions of Excel, and how to create automatic procedures The accompanying CD contains a number of Excel macros to facilitate chemical calculations, including molecular weight, nonlinear regression statistics, and data interpolation Several appendices provide extensive lists of useful shortcut keys and function descriptions"

By: E. Joseph Billo (Department of Chemistry Boston College Chestnut Hill Massachusetts)
Imprint: Blackwell Publishing
Country of Publication: United States
Edition: 3rd Revised edition
Dimensions: Height: 249mm, Width: 178mm, Spine: 33mm
Weight: 1.157kg
ISBN: 9780470381236
ISBN 10: 047038123X
Pages: 760
Publication Date: 07 September 2011
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

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 633 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

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.

Reviews for Excel for Chemists, with CD-ROM: A Comprehensive Guide

“Finally this new edition, provides chemists and students a detailed guide and examples how to apply the current versions of Excel to their needs. It should be added to the shelves of those using this program within their scientific work.” (Materials and Corrosion, 1 November 2012)