{"product_id":"excel-for-chemists-with-cd-rom-isbn-9780470381236","title":"Excel for Chemists, with CD-ROM","description":"\u003cb\u003eReviews from previous editions:\u003c\/b\u003e  \u003cp\u003e\"\u003ci\u003eExcel for Chemists\u003c\/i\u003e should be part of any academic library offering courses and programs in Chemistry.\"\u003cbr\u003e —\u003cb\u003e\u003ci\u003eChoice\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift.\"\u003cbr\u003e —\u003cb\u003e\u003ci\u003eThe Nucleus\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eThe newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChemists 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, \u003ci\u003eExcel\u003c\/i\u003e \u003ci\u003efor Chemists\u003c\/i\u003e illustrates how to use the scientific calculating power of Excel to perform a variety of chemical calculations. \u003c\/p\u003e \u003cp\u003eIncluding 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAdditional features in this third edition include:\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eHow to perform a variety of chemical calculations by creating advanced spreadsheet formulas or by using Excel’s built-in tools\u003c\/li\u003e \u003cli\u003eHow to automate repetitive tasks by programming Excel’s Visual Basic for Applications\u003c\/li\u003e \u003cli\u003eNew chapters show how to import data from other language versions of Excel, and how to create automatic procedures\u003c\/li\u003e \u003cli\u003eThe accompanying CD contains a number of Excel macros to facilitate chemical calculations, including molecular weight, nonlinear regression statistics, and data interpolation\u003c\/li\u003e \u003cli\u003eSeveral appendices provide extensive lists of useful shortcut keys and function descriptions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003ePreface to the Third Edition xxv\u003c\/p\u003e \u003cp\u003eBefore You Begin xxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I The Basics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1 Working with Excel 2007 or Excel 2010 3\u003c\/p\u003e \u003cp\u003eChapter 2 Working with Excel 2003 79\u003c\/p\u003e \u003cp\u003eChapter 3 Excel Formulas and Functions 137\u003c\/p\u003e \u003cp\u003eChapter 4 Excel 2007\/2010 Charts 177\u003c\/p\u003e \u003cp\u003eChapter 5 Excel 2003 Charts 209\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Advanced Spreadsheet Topics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6 Advanced Worksheet Formulas 233\u003c\/p\u003e \u003cp\u003eChapter 7 Array Formulas 267\u003c\/p\u003e \u003cp\u003eChapter 8 Advanced Charting Techniques 289\u003c\/p\u003e \u003cp\u003eChapter 9 Using Excel's Database Features 327\u003c\/p\u003e \u003cp\u003eChapter 10 Importing Data into Excel 349\u003c\/p\u003e \u003cp\u003eChapter 11 Adding Controls to a Spreadsheet 365\u003c\/p\u003e \u003cp\u003eChapter 12 Other Language Versions of Excel 385\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Spreadsheet Mathematics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 13 Mathematical Methods for Spreadsheet Calculations 403\u003c\/p\u003e \u003cp\u003eChapter 14 Linear Regression and Curve Fitting 435\u003c\/p\u003e \u003cp\u003eChapter 15 Nonlinear Regression Using the Solver 463\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV Excel's Visual Basic for Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16 Visual Basic for Applications: An Introduction 491\u003c\/p\u003e \u003cp\u003eChapter 17 Programming with VBA 503\u003c\/p\u003e \u003cp\u003eChapter 18 Working with Arrays in VBA 543\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V Some Applications of VBA\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19 Command Macros 557\u003c\/p\u003e \u003cp\u003eChapter 20 Custom Functions 571\u003c\/p\u003e \u003cp\u003eChapter 21 Automatic Procedures 589\u003c\/p\u003e \u003cp\u003eChapter 22 Custom Menus 595\u003c\/p\u003e \u003cp\u003eChapter 23 Custom Toolbars and Toolbuttons 607\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI Appendices\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A What's Where in Excel 2007\/2010 629\u003c\/p\u003e \u003cp\u003eAppendix B Selected Worksheet Functions by Category 633\u003c\/p\u003e \u003cp\u003eAppendix C Alphabetical List of Selected Worksheet Functions 639\u003c\/p\u003e \u003cp\u003eAppendix D Renamed Functions in Excel 2010 661\u003c\/p\u003e \u003cp\u003eAppendix E Selected Visual Basic Keywords by Category 663\u003c\/p\u003e \u003cp\u003eAppendix F Alphabetical List of Selected Visual Basic Keywords 667\u003c\/p\u003e \u003cp\u003eAppendix G Selected Excel 4 Macro Functions 689\u003c\/p\u003e \u003cp\u003eAppendix H Shortcut Keys by Keystroke 693\u003c\/p\u003e \u003cp\u003eAppendix I Selected Shortcut Keys by Category 703\u003c\/p\u003e \u003cp\u003eAppendix J ASCII Codes 707\u003c\/p\u003e \u003cp\u003eAppendix K Contents of the CD-ROM 709\u003c\/p\u003e \u003cp\u003eIndex 719\u003c\/p\u003e  \u003cp\u003e“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.”  (\u003ci\u003eMaterials and Corrosion\u003c\/i\u003e, 1 November 2012)\u003c\/p\u003e  \u003cp\u003e\u003cb\u003e\u003csmall\u003eE. JOSEPH BILLO\u003c\/small\u003e\u003c\/b\u003e retired in 2006 as associate professor of chemistry at Boston College and is the author of \u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e for Chemists: A Comprehensive Guide, Second Edition.\u003c\/i\u003e 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.   \u003c\/p\u003e\u003cp\u003e \u003cb\u003eReviews from previous editions\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\"\u003ci\u003eExcel for Chemists\u003c\/i\u003e should be part of any academic library offering courses and programs in chemistry.\" —\u003cb\u003e\u003ci\u003eChoice\u003c\/i\u003e\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\"I highly recommend this book; treat yourself to it; assign it to a class; give it as a gift.\" —\u003cb\u003e\u003ci\u003eThe Nucleus\u003c\/i\u003e\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003cb\u003eThe newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eChemists 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, \u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e for Chemists\u003c\/i\u003e 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: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eHow to perform a variety of chemical calculations by creating advanced spreadsheet formulas or by using Excel's built-in tools\u003c\/li\u003e \u003cli\u003eHow to automate repetitive tasks by programming Excel's Visual Basic for Applications\u003c\/li\u003e \u003cli\u003eNew chapters in this edition show how to import data from other language versions of Excel, and how to create automatic procedures\u003c\/li\u003e \u003cli\u003eThe accompanying CD contains a number of Excel macros to facilitate chemical calculations, including molecular weight, nonlinear regression statistics, and data interpolation\u003c\/li\u003e \u003cli\u003eSeveral appendices provide extensive lists of useful shortcut keys and function descriptions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWhether as a text for students or as a reference for chemical professionals in industry, academia, or government, \u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e for Chemists, Third Edition\u003c\/i\u003e provides a valuable resource for using Excel to manage various chemical calculations.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989182005477,"sku":"NP9780470381236","price":76.95,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470381236.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-for-chemists-with-cd-rom-isbn-9780470381236","provider":"K12savings","version":"1.0","type":"link"}