Excel for Chemists, with CD-ROM


Book Description

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




Excel for Chemists


Book Description

Reviews from the First Edition: "Excel® for Chemists should be part ofany academic library offering courses and programs in chemistry.There is no other book on the market that deals so thoroughly withthe application of Excel for analyzing chemical data. Highlyrecommended, for upper-division undergraduates throughprofessionals." -Choice "I highly recommend this book; treat yourself to it; assign itto a class; give it as a gift." -The Nucleus Chemists across all subdisciplines use Excel to record data intabular form, but few have learned to take full advantage of thescientific calculating power within this program. Excel is capableof helping chemists process, analyze, and present scientific data,from the relatively simple to the highly complex.Excel® for Chemists, Second Edition has beenrevised and updated, not only to take into account the changes thatwere made in Excel, but also to incorporate an abundance of newexamples. Arranged in a user-friendly format, this book containsillustrations and examples of chemical applications, useful "Howto" boxes outlining how to accomplish complex tasks in Excel, andstep-by-step instructions for programming Excel to automaterepetitive data-processing tasks. In addition, tips are provided tospeed, simplify, and improve your use of Excel. Included is aCD-ROM, usable in either Macintosh or IBM/Windows environments withmany helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Editionfeature: Array formulas covered in depth in a separate chapter, alongwith a comprehensive review of using arrays in VBA How to create a worksheet with controls, such as optionbuttons, check boxes, or a list box An extensive list of shortcut keys-over 250 for Macintosh orPC-is provided in the appendix Whether as a text for students or as a reference for chemicalprofessionals in industry, academia, or government,Excel® for Chemists, Second Edition providesa valuable resource for using Excel to manage various chemicalcalculations.




Excel for Scientists and Engineers


Book Description

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package




Excel Simulations


Book Description

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.




Computational Quantum Chemistry


Book Description

Computational Quantum Chemistry removes much of the mystery of modern computer programs for molecular orbital calculations by showing how to develop Excel spreadsheets to perform model calculations and investigate the properties of basis sets. Using the book together with the CD-ROM provides a unique interactive learning tool. In addition, because of the integration of theory with working examples on the CD-ROM, the reader can apply advanced features available in the spreadsheet to other applications in chemistry, physics, and a variety of disciplines that require the solution of differential equations.This book and CD-ROM makes a valuable companion for instructors, course designers, and students. It is suitable for direct applications in practical courses in theoretical chemistry and atomic physics, as well as for teaching advanced features of Excel in IT courses.




Statistics for Business and Economics


Book Description

Finally a statistics text that not only does a great job covering statistical tools but also focuses on software and the use of the internet for statistical work! Unlike most current texts which merely add screen shots, the Kohler text has been designed around the integration of popular statistical software and the use of the internet so that readers receive thorough preparation with these tools. The book also provides a great deal of flexibility for designing your course sequence through its applications approach where students will learn when to use certain techniques and how to interpret results to help in decision making, its modern approach giving a thorough integration of computer use, and a modular writing style.




Mathematics for Physical Chemistry


Book Description

This is the ideal textbook for those students who want to sharpen their mathematics skills while they are enrolled in a physical chemistry course. It provides students with a review of calculus and differential equations which will enable them to succeed in the physical chemistry course. Features: * Completeness: contains all of the mathematics needed in undergraduate physical chemistry * Clarity: Every sentence, every example, and every equation have been constructed to make it as clear as possible * Applications-oriented: Designed for applications of mathematics, not for mathematical theory; written for a chemist who needs to use mathematics, not for a mathematician who needs to study the underlying theory




Escape From Excel Hell


Book Description

Written especially for advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by faulty formulas, failed formatting, printer purgatory, and other perplexing Excel problems Offers three types of fixes: Escape in Under 30 Seconds, Escape in Under Two Minutes, and More Elaborate Escapes-over 400 solutions in all Topics covered include formula fixes, formatting fixes, data and layout fixes for Excel charts, PivotTable fixes, managing complexity in very large spreadsheets, fixing broken procedure functions, and more Includes preventive measures and best practices that teach users how to avoid problems in the future Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




Quality Assurance in Analytical Chemistry


Book Description

This best-selling title both in German and English is now enhanced by a new chapter on the important topical subject of measurement uncertainty, plus a CD-ROM with interactive examples in the form of Excel-spreadsheets. These allow readers to gain an even better comprehension of the statistical procedures for quality assurance while also incorporating their own data. Following an introduction, the text goes on to elucidate the 4-phase model of analytical quality assurance: establishing a new analytical process, preparative quality assurance, routine quality assurance and external analytical quality assurance. Besides updating the relevant references, the authors took great care to incorporate the latest international standards in the field.




Optimal Portfolio Modeling


Book Description

Optimal Portfolio Modeling is an easily accessible introduction to portfolio modeling for those who prefer an intuitive approach to this discipline. While early chapters provide engaging insights on the statistical properties of markets, this book quickly moves on to illustrate invaluable trading and risk control models based on popular programs such as Excel and the statistical modeling language R. This reliable resource presents modeling formulas that will allow you to effectively maximize the performance, minimize the drawdown, and manage the risk of your portfolio.