Front Cover -- A Guide to Microsoft® Excel 2007 for Scientists and Engineers -- Copyright Page -- Contents -- Preface -- Chapter 1 Welcome to Microsoft Excel® 2007 -- The Excel Window -- Exercise 1: The Ribbon -- Exercise 2: Quick Access Toolbar -- Exercise 3: Working with Shortcuts -- The Worksheet -- Excel 2007 Specifications -- Problems -- Chapter 2 Basic Operations -- 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 -- Exercise 1: Quick Print and Print Preview -- Exercise 2: Print Area -- The Print Dialog -- Exercise 3: Some Printing Options -- Chapter 4 Using Functions -- 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 -- 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 Two-Valued Lookup.

Exercise 8: Conditional Summing -- Exercise 9: Array Formulas -- Exercise 10: Conditional Formatting -- Exercise 11: SUMPRODUCT -- Problems -- Chapter 6 Data Mining -- Exercise 1: Importing a TXT file -- Exercise 2: Counting and Summing with Criteria -- Exercise 3: Frequency Distribution -- Exercise 4: Pivot Tables -- Exercise 5: Sorting -- Exercise 6: Filtering -- Exercise 7: The Excel Table -- Problems -- Chapter 7 Charts -- 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 Y-axes -- 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 -- Least-Squares 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 User-defined Functions -- 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 -- Input-Output of Arrays -- Exercise 10: An Array Function -- Using Functions from Other Workbooks -- Problems -- Chapter 10 VBA Subroutines -- 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 -- Exercise 6: Adding a Control -- Exercise 7: User Forms -- Problems -- Chapter 11 Modeling I -- Exercise 1: Population Model -- Exercise 2: Vapor Pressure of Ammonia -- Exercise 3: Stress Analysis -- Exercise 4: Circuit Analysis -- Exercise 5: Ladder Down the Mine -- Exercise 6: Adding Waves -- Exercise 7: Centroid of a Polygon -- Exercise 8: Finding Roots by Iteration -- Problems -- Chapter 12 Using Solver -- 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 SolverTM -- Problems -- Chapter 13 Numerical Integration -- Exercise 1: The Trapezoid Rule -- Exercise 2: Simpson's 1/3 Rule -- Exercise 3: Adding Flexibility -- Exercise 4: Going Modular -- Exercise 5: Tabular Data -- Exercise 6: Gaussian Integration -- Exercise 7: Monte Carlo Techniques.

Problems -- Chapter 14 Differential Equations -- Exercise 1: Euler's Method -- Exercise 2: The Runge-Kutta Method -- Exercise 3: Solving with a User-Defined Function -- Simultaneous and Second-Order Differential Equations -- Exercise 4: Solving a Second-Order Equation -- Exercise 5: The Simple Pendulum -- Problems -- Chapter 15 Modeling II -- Exercise 1: The Four-Bar Crank -- Exercise 2: Temperature Profile Using Matrix Algebra -- Exercise 3: Temperature Profile Using Solver -- Exercise 4: Emptying the Tank -- Exercise 5: An Improved Tank Emptying Model -- Problems -- Chapter 16 Statistics for Experimenters -- 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 -- Documentation -- Picture of Worksheet -- Display Formulas -- Exercise 1: Creating an Equation -- Screen Captures -- MathLookTM -- Copy and Paste or OLE? -- Exercise 2: Copy and Paste -- Exercise 3: Object Embedding -- Microsoft Visio® -- Answers -- Index.