A guide to Microsoft Excel 2007 for scientists and engineers / Bernard V. Liengme ; with David J. Ellert.

Format:

Book

Author/Creator:

Liengme, Bernard V.

Language:

English

Subjects (All):

Engineering--Data processing.

Engineering.

Science--Data processing.

Science.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (337 p.)

Edition:

1st edition

Other Title:

Guide to Excel 2007 for scientists and engineers

Place of Publication:

Amsterdam ; Boston : Academic Press/Elsevier, c2009.

Language Note:

English

System Details:

text file

Summary:

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 suc

Contents:

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 RoundingSignificant 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 SummingExercise 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 AxisExercise 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

Notes:

Includes index.

ISBN:

9786612168895

9781282168893

1282168894

9780080923512

0080923518

OCLC:

609843487