A Guide to Microsoft Excel 2007 for Scientists and Engineers
A Guide to Microsoft Excel 2007 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2008-11-27

Total Pages: 337

ISBN-13: 0080923518

DOWNLOAD EBOOK

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. - 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 2007. - Features of Excel 2007 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. - Updated with new examples, problem sets, and applications.

A Guide to Microsoft Excel 2013 for Scientists and Engineers
A Guide to Microsoft Excel 2013 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2015-03-17

Total Pages: 378

ISBN-13: 0128028165

DOWNLOAD EBOOK

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

The Unofficial Guide to Microsoft Office Excel 2007
The Unofficial Guide to Microsoft Office Excel 2007

Author: Julia Kelly

Publisher: John Wiley & Sons

Published: 2008-03-11

Total Pages: 507

ISBN-13: 0470377534

DOWNLOAD EBOOK

The inside scoop...for when you want more than the official line! Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts. Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data Savvy, real-world advice to help you set up, enter, format, and organize your data Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Excel for Scientists and Engineers
Excel for Scientists and Engineers

Author: E. Joseph Billo

Publisher: John Wiley & Sons

Published: 2007-03-16

Total Pages: 480

ISBN-13: 0470126701

DOWNLOAD EBOOK

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

A Guide to Microsoft Excel 2007 for Scientists and Engineers
A Guide to Microsoft Excel 2007 for Scientists and Engineers

Author: Bernard V. Liengme

Publisher:

Published: 2009

Total Pages: 326

ISBN-13:

DOWNLOAD EBOOK

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.

Elements of Environmental Chemistry
Elements of Environmental Chemistry

Author: Ronald A. Hites

Publisher: John Wiley & Sons

Published: 2013-08-26

Total Pages: 171

ISBN-13: 1118309987

DOWNLOAD EBOOK

From Reviews of the First Edition: "This splendid, at times humorous, and reasonably priced little book has much to commend it to undergraduate chemists and to other science students." J. G. Farmer, University of Edinburgh "Complex environmental issues are presented in simple terms to help readers grasp the basics and solve relevant problems." J. Albaiges, University of Barcelona "The main strength of the book lies in its explanations of the calculation of quantitative relationships. Each chapter includes 15-20 problems that are carefully chosen from a didactic standpoint, for which the reader can find solutions at the end." D. Lenoir, Institute for Ecological Chemistry "What drew me to the first edition was the style the no nonsense, down-to-earth explanations and the practical examples that litter the text. The dry humor expressed in the footnotes is great and reminds me of other classic texts." T. Clough, Lincoln University A practical approach to environmental chemistry Providing readers with the fundamentals of environmental chemistry and a toolbox for putting them into practice, Elements of Environmental Chemistry, Second Edition is a concise, accessible, and hands-on volume designed for students and professionals working in the chemical and environmental sciences. Tutorial in style, this book fully incorporates real-world problems and extensive end-of-chapter problem sets to immerse the reader in the field. Chapters cover mass balance, chemical kinetics, carbon dioxide equilibria, pesticide structures and much more. Extensively revised, updated, and expanded, this Second Edition includes new chapters on atmospheric chemistry, climate change, and polychlorinated biphenyls and dioxins, and brominated flame retardants. In addition, new practice problems and a helpful tutorial on organic chemistry names and structures have been added to improve both the scope and accessibility of the book.

Liengme's Guide to Excel 2016 for Scientists and Engineers
Liengme's Guide to Excel 2016 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2019-08-14

Total Pages: 416

ISBN-13: 0128182504

DOWNLOAD EBOOK

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.

Data Analysis for Physical Scientists
Data Analysis for Physical Scientists

Author: Les Kirkup

Publisher: Cambridge University Press

Published: 2012-02-16

Total Pages: 527

ISBN-13: 1107377455

DOWNLOAD EBOOK

The ability to summarise data, compare models and apply computer-based analysis tools are vital skills necessary for studying and working in the physical sciences. This textbook supports undergraduate students as they develop and enhance these skills. Introducing data analysis techniques, this textbook pays particular attention to the internationally recognised guidelines for calculating and expressing measurement uncertainty. This new edition has been revised to incorporate Excel® 2010. It also provides a practical approach to fitting models to data using non-linear least squares, a powerful technique which can be applied to many types of model. Worked examples using actual experimental data help students understand how the calculations apply to real situations. Over 200 in-text exercises and end-of-chapter problems give students the opportunity to use the techniques themselves and gain confidence in applying them. Answers to the exercises and problems are given at the end of the book.