The Resource A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)

A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)

Label
A guide to Microsoft Excel 2007 for scientists and engineers
Title
A guide to Microsoft Excel 2007 for scientists and engineers
Statement of responsibility
Bernard V. Liengme ; with David J. Ellert
Title variation
Guide to Excel 2007 for scientists and engineers
Creator
Contributor
Subject
Genre
Language
  • eng
  • eng
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
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Liengme, Bernard V
Dewey number
005.360245
Illustrations
illustrations
Index
index present
Language note
English
LC call number
TA345
LC item number
.L54 2009
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Ellert, David J
http://library.link/vocab/subjectName
  • Engineering
  • Science
Label
A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
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
Dimensions
unknown
Extent
1 online resource (337 p.)
Form of item
online
Isbn
9781282168893
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (EBL)453065
  • (OCoLC)609843487
  • (SSID)ssj0000360856
  • (PQKBManifestationID)11294065
  • (PQKBTitleCode)TC0000360856
  • (PQKBWorkID)10347751
  • (PQKB)10999083
  • (MiAaPQ)EBC453065
  • (EXLCZ)991000000000749000
Label
A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
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
Dimensions
unknown
Extent
1 online resource (337 p.)
Form of item
online
Isbn
9781282168893
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (EBL)453065
  • (OCoLC)609843487
  • (SSID)ssj0000360856
  • (PQKBManifestationID)11294065
  • (PQKBTitleCode)TC0000360856
  • (PQKBWorkID)10347751
  • (PQKB)10999083
  • (MiAaPQ)EBC453065
  • (EXLCZ)991000000000749000

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...