Liengme's Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you're using a PC or a Mac. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis, and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with Microsoft Office release of Excel 2016. - Features of Excel 2016 are illustrated through a wide variety of examples based on technical contexts, demonstrating the use of the program for analysis and presentation of experimental results. - Where appropriate, demonstrates the differences between the PC and Mac versions of Excel. - Includes many new end-of-chapter problems at varying levels of difficulty.

Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 to its full potential. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.

Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 to its full potential. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2013 - Features of Excel 2013 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results New to this edition: - The Backstage is introduced (a new Office 2013 feature); all the 'external' operations like Save, Print etc. are now in one place - The chapter on charting is totally revised and updated – Excel 2013 differs greatly from earlier versions - Includes many new end-of-chapter problems - Most chapters have been edited to improve readability

A practical approach to environmental chemistry, Elements of Environmental Chemistry, 3rd Edition provides readers with the fundamentals of environmental chemistry and a toolbox for putting them into practice. This is a concise, accessible, and hands-on volume designed for students and professionals working in the chemical and environmental sciences. The 3rd Edition has been completely revised and rearranged. The first chapter on tool skills has been expanded to include thermodynamic considerations and measurement issues. The former chapter on the partitioning of organic compounds has been expanded to cover the fates of organic compounds, with an emphasis on developing the readers chemical intuition for predicting a chemicals fate based on structure. The material on lead, mercury, pesticides, PCBs, dioxins, and flame retardants has been expanded and combined into the last chapter and supplemented with more references to the literature. The problem sets have been extended and now include over 130 problems, some of which can be solved using Excel.

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

This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.

The Breakthrough Introduction to Chemical Engineering for Today’s Students Fundamental Concepts and Computations in Chemical Engineering is well designed for today’s chemical engineering students, offering lucid and logically arranged text that brings together the fundamental knowledge students need to gain confidence and to jumpstart future success. Dr. Vivek Utgikar illuminates the day-to-day roles of chemical engineers in their companies and in the global economy. He clearly explains what students need to learn and why they need to learn it, and presents practical computational exercises that prepare beginning students for more advanced study. Utgikar combines straightforward discussions of essential topics with challenging topics to intrigue more well-prepared students. Drawing on extensive experience teaching beginners, he introduces each new topic in simple, relatable language, and supports them with meaningful example calculations in Microsoft Excel and Mathcad. Throughout, Utgikar presents practical methods for effective problem solving, and explains how to set up and use computation tools to get accurate answers. Designed specifically for students entering chemical engineering programs, this text also serves as a handy, quick reference to the basics for more advanced students, and an up-to-date source of valuable information for educators and professionals. Coverage includes Where chemical engineering fits in the engineering field and overall economy Modern chemical engineering and allied industries and their largest firms How typical chemical engineering job functions build on what undergraduates learn The importance of computations, and the use of modern computational tools How to classify problems based on their mathematical nature Fundamental fluid flow phenomena and computational problems in practical systems Basic principles and computations of material and energy balance Fundamental principles and calculations of thermodynamics and kinetics in chemical engineering How chemical engineering systems and problems integrate and interrelate in the real world Review of commercial process simulation software for complex, large-scale computation