Borrow it
 African Studies Library
 Alumni Medical Library
 Astronomy Library
 Fineman and Pappas Law Libraries
 Frederick S. Pardee Management Library
 Howard Gotlieb Archival Research Center
 Mugar Memorial Library
 Music Library
 Pikering Educational Resources Library
 School of Theology Library
 Science & Engineering Library
 Stone Science Library
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)
Resource Information
The item A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Boston University Libraries.This item is available to borrow from all library branches.
Resource Information
The item A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Boston University Libraries.
This item is available to borrow from all library branches.
 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
 Language

 eng
 eng
 Extent
 1 online resource (337 p.)
 Note
 Includes index
 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 TwoValued 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 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
 LeastSquares Fitting
 Isbn
 9781282168893
 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
 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)
 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 TwoValued 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 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
 LeastSquares 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)
 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 TwoValued 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 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
 LeastSquares 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 it771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US42.350723 71.108227


Astronomy LibraryBorrow it725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US42.350259 71.105717

Fineman and Pappas Law LibrariesBorrow it765 Commonwealth Avenue, Boston, MA, 02215, US42.350979 71.107023

Frederick S. Pardee Management LibraryBorrow it595 Commonwealth Avenue, Boston, MA, 02215, US42.349626 71.099547

Howard Gotlieb Archival Research CenterBorrow it771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US42.350723 71.108227


Music LibraryBorrow it771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US42.350723 71.108227

Pikering Educational Resources LibraryBorrow it2 Silber Way, Boston, MA, 02215, US42.349804 71.101425

School of Theology LibraryBorrow it745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US42.350494 71.107235

Science & Engineering LibraryBorrow it38 Cummington Mall, Boston, MA, 02215, US42.348472 71.102257

Embed (Experimental)
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.bu.edu/portal/AguidetoMicrosoftExcel2007forscientists/vy9ktefO4VM/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.bu.edu/portal/AguidetoMicrosoftExcel2007forscientists/vy9ktefO4VM/">A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.bu.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.bu.edu/">Boston University Libraries</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data  Experimental
Data Citation of the Item A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.bu.edu/portal/AguidetoMicrosoftExcel2007forscientists/vy9ktefO4VM/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.bu.edu/portal/AguidetoMicrosoftExcel2007forscientists/vy9ktefO4VM/">A guide to Microsoft Excel 2007 for scientists and engineers, Bernard V. Liengme ; with David J. Ellert, (electronic resource)</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.bu.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.bu.edu/">Boston University Libraries</a></span></span></span></span></div>