Sale!

Excel for Chemists A Comprehensive Guide 3rd Edition by E Joseph Billo ISBN 111809395X 9781118093955

Original price was: $50.00.Current price is: $35.00.

Excel for Chemists A Comprehensive Guide Third Edition E. Joseph Billo(Auth.) Digital Instant Download

Author(s): E. Joseph Billo(auth.)
ISBN(s): 9781118093955, 111809395X
File Details: PDF, 19.87 MB
Year: 2011
Language: english
SKU: EB-4304202 Category: Tag:

Excel for Chemists A Comprehensive Guide 3rd Edition by E Joseph Billo – Ebook PDF Instant Download/Delivery: 111809395X, 9781118093955
Full download Excel for Chemists A Comprehensive Guide 3rd Edition after payment

Product details:

ISBN 10: 111809395X 
ISBN 13: 9781118093955
Author: E Joseph Billo

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 A Comprehensive Guide 3rd Table of contents:

Chapter 1: Introduction to Excel for Chemists
Why Use Excel in Chemistry?

Spreadsheet Basics and Terminology

Navigating the Excel Interface

Entering and Formatting Data

Chapter 2: Customizing Excel for Scientific Use
Setting Up the Excel Environment

Creating Chemistry-Friendly Toolbars and Ribbon Tabs

Units, Constants, and Custom Number Formats

Using Templates for Repetitive Tasks

Chapter 3: Working with Data Tables
Creating and Editing Data Tables

Sorting and Filtering Experimental Data

Using Named Ranges and Structured References

Importing Data from Instruments and External Files

Chapter 4: Mathematical and Statistical Functions
Essential Excel Functions for Chemists

Error Propagation and Significant Figures

Statistical Tools: AVERAGE, STDEV, LINEST, and More

Using Excel’s Analysis ToolPak for Descriptive Statistics

Chapter 5: Graphing and Data Visualization
Creating 2D and 3D Charts

Customizing Axes, Legends, and Data Labels

Graphing Multiple Data Series

Plotting Experimental Data with Best-Fit Lines

Scientific Graphing Tips and Standards

Chapter 6: Linear and Nonlinear Regression
Linear Regression with LINEST and TREND

Polynomial and Exponential Fits

Nonlinear Curve Fitting Using Solver

Applications in Kinetics and Calibration Curves

Chapter 7: Using Solver for Chemical Calculations
Introduction to Solver and Optimization

Equilibrium Calculations (e.g., Acid-Base, Complexation)

Reaction Yields and Stoichiometry

Fitting Experimental Data to Theoretical Models

Chapter 8: Advanced Chemical Applications
Spectroscopy Data Analysis (UV-Vis, IR, NMR)

Titration Curves and pKa Determination

Kinetics and Reaction Rate Modeling

Thermodynamics: ΔG, ΔH, ΔS Calculations

Creating Chemical Spreadsheets for Teaching

Chapter 9: Error Analysis and Quality Control
Confidence Intervals and t-Tests

Control Charts for Analytical Chemistry

Precision, Accuracy, and Calibration

Statistical Comparison of Data Sets

Chapter 10: Automating Tasks with Macros and VBA
Introduction to VBA (Visual Basic for Applications)

Recording and Editing Macros

Creating User-Defined Functions for Chemistry

Automating Repetitive Calculations and Reports

Chapter 11: Working with Large Data Sets
PivotTables and Data Summarization

Handling High-Throughput or Time-Series Data

Using Power Query to Clean and Combine Datasets

Exporting and Sharing Data

Chapter 12: Integrating Excel with Other Software
Copying Data and Charts to Word and PowerPoint

Exporting for Use in Statistical or Chemical Software

Using Excel with MATLAB, R, and Python

Data Interchange with Instrumentation Software

People also search for Excel for Chemists A Comprehensive Guide 3rd:

    
excel for chemists a comprehensive guide
    
excel for chemists a comprehensive guide pdf
    
excel for chemists
    
excel spreadsheet for chemistry
    
excel for chemists pdf

Tags: E Joseph Billo, Excel, Chemists