Book description
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, curvefitting, 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.
Table of contents
 Cover image
 Title page
 Table of Contents
 Copyright
 Preface
 Chapter 1. Welcome to Microsoft Excel® 2007

Chapter 2. Basic Operations
 Publisher Summary
 Exercise 1: Simple Arithmetic
 Exercise 2: The Arithmetic Operators
 Exercise 3: Formatting (Displayed and Stored Values)
 Exercise 4: Working with Fractions
 Exercise 5: A Practical Worksheet
 Copying Formulas: What Happens to References?
 What’s in a Name?
 Exercise 6: Another Practical Example
 Special Symbols, Subscripts and Superscripts
 Mathematical Limitations of Excel
 Play It Again, Sam
 Problems
 Chapter 3. Printing in Excel

Chapter 4. Using Functions
 Publisher Summary
 Exercise 1: AutoSum Tool
 The Insert Function Command
 Exercise 2: Computing a Weighted Average
 Exercise 3: Entering Formulas by Typing
 Exercise 4: Trigonometry Functions
 Exercise 5: Exponential Functions
 Exercise 6: Rounding Functions
 Note on Rounding
 Significant Numbers
 Some Other Mathematical Functions
 Array Formulas
 Exercise 7: The Matrix Functions
 Volatility: Calculate Mode
 Exercise 8: Solving Systems of Equations
 Exercise 9: Sum of Diagonal
 Financial Functions
 Problems

Chapter 5. Decision Functions
 Publisher Summary
 Logical Comparison Operators
 Exercise 1: Boolean Functions
 Exercise 2: Practical Example
 The IF Function
 Exercise 3: Resistors Revisited
 Exercise 4: Quadratic Equation Solver
 Exercise 5: Protecting a Worksheet
 Table Lookup Functions
 Exercise 6: A Simple Lookup
 Exercise 7: A TwoValued Lookup
 Exercise 8: Conditional Summing
 Exercise 9: Array Formulas
 Exercise 10: Conditional Formatting
 Exercise 11: SUMPRODUCT
 Problems
 Chapter 6. Data Mining

Chapter 7. Charts
 Publisher Summary
 Types of Charts
 Line and XY Chart
 Comments about Charts
 Chart Terminology
 Exercise 1: An XY Chart
 Exercise 2: Smooth Lines
 Formatting a Chart
 Exercise 3: Formatting the Data Series
 Exercise 4: Formatting an Axis
 Exercise 5: Plotting a Function
 Exercise 6: More Formatting
 Finding Roots
 Exercise 7: A Flexible Domain
 Exercise 8: Changing Axis Position
 Exercise 9: XY Chart with Two Yaxes
 Exercise 10: Control Chart
 Exercise 11: Too Much Data
 Exercise 12: Large Numbers and Log Scale
 Exercise 13: Error Bars
 Other Chart Types
 Exercise 14: Surface Chart
 Exercise 15: Combination Chart
 Exercise 16: A Bar Chart
 Exercise 17: A Parametric Chart
 Exercise 18: Polar Chart
 Dynamic Charts
 Printing a Chart
 URLs for Chart Websites
 Problems

Chapter 8. Regression Analysis
 Publisher Summary
 LeastSquares Fitting
 Exercise 1: Trendline, SLOPE, and INTERCEPT
 Exercise 2: Interpolation and FORECAST
 Exercise 3: The LINEST Function
 Exercise 4: Fixed Intercept
 Exercise 5: A Polynomial Fit
 Exercise 6: A Logarithmic Fit (LOGEST)
 The TREND and GROWTH Functions
 Residuals
 Exercise 7: Slope and Tangent
 Exercise 8: The Analysis Toolpak
 Problems

Chapter 9. VBA UserDefined Functions
 Publisher Summary
 Security Note
 Exercise 1: The Visual Basic Editor
 Syntax of a Function
 Exercise 2: A Simple Function
 Naming Functions and Variables
 Worksheet and VBA Functions
 Exercise 3: When Things Go Wrong
 Programming Structures
 Exercise 4: The IF Structure
 Exercise 5: Boolean Operators
 The SELECT Structure
 Exercise 6: Select Example
 The FOR..NEXT Structure
 Exercise 7: Example Using FOR…NEXT
 The Excel Object Model: An Introduction
 Exercise 8: FOR EACH—Resistors Revisited
 Exercise 9: The DO …LOOP Structure
 Variables and Data Types
 InputOutput of Arrays
 Exercise 10: An Array Function
 Using Functions from Other Workbooks
 Problems

Chapter 10. VBA Subroutines
 Publisher Summary
 Exercise 1: Recording a Macro
 Computing Subroutines
 Notes on the VB Editor
 Exercise 2: A Computing Macro
 Public or Private?
 Name That Variable
 Exercise 3: Bolt Hole Positions
 Exercise 4: Finding Roots by Bisection
 Exercise 5: Using Arrays
 Adding a Control
 Exercise 7: User Forms
 Problems
 Chapter 11. Modeling I

Chapter 12. Using Solver
 Publisher Summary
 Exercise 1: Goal Seek
 Exercise 2: Solver as Root Finder
 Solving Equations with Constraints
 Exercise 3: Finding Multiple Roots
 Exercise 4: Saving Solver Models
 Exercise 5: Systems of Nonlinear Equations
 Curve Fitting with Solver
 Exercise 6: Gaussian Curve Fit
 Exercise 7: A Minimization Problem
 Exercise 8: An Optimization Problem
 Tk Solver™
 Problems
 Chapter 13. Numerical Integration
 Chapter 14. Differential Equations
 Chapter 15. Modeling II

Chapter 16. Statistics for Experimenters
 Publisher Summary
 Exercise 1: Descriptive Statistics
 Exercise 2: Frequency Distribution
 Exercise 3: Confidence Limits
 Exercise 4: The Experimental and Expected Mean
 Exercise 5: Pooled Standard Deviation
 Exercise 6: Comparing Paired Arrays
 Exercise 7: Comparing Repeated Measurements
 Exercise 8: The Calibration Curve Revisited
 Exercise 9: More on the Calibration Curve
 Problems
 Chapter 17. Report Writing
 Answers
 Index
Product information
 Title: A Guide to Microsoft Excel 2007 for Scientists and Engineers
 Author(s):
 Release date: November 2008
 Publisher(s): Academic Press
 ISBN: 9780080923512
You might also like
book
Excel Scientific and Engineering Cookbook
Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using itinstead of FORTRANto …
book
Business Solutions Formulas and Functions with Microsoft® Office Excel 2007
“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and …
book
Excel 2007: The Missing Manual
Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed …
book
Beginning Microsoft Excel 2010
Beginning Microsoft Excel 2010 is a practical, stepbystep guide to getting started with the world's most …