Liengmes Guide to Excel 2016 for Scientists and Engineers 1st edition by Bernard Liengme, Keith Hekman 0128182490 9780128182499
Original price was: $70.00.$24.99Current price is: $24.99.
Instant download Academic Press Liengmes Guide to Excel 2016 for Scientists and Engineers 0128182490 after payment
Liengmes Guide to Excel 2016 for Scientists and Engineers 1st edition by Bernard Liengme, Keith Hekman – Ebook PDF Instant Download/Delivery: 0128182490, 9780128182499
Full download Liengmes Guide to Excel 2016 for Scientists and Engineers 1st edition after payment
Product details:
ISBN 10: 0128182490
ISBN 13: 9780128182499
Author: Bernard Liengme; Keith Hekman
Liengme’s Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you’re using a PC or a Mac. 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, curve-fitting, 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 Microsoft Office release of Excel 2016.
- Features of Excel 2016 are illustrated through a wide variety of examples based on technical contexts, demonstrating the use of the program for analysis and presentation of experimental results.
- Where appropriate, demonstrates the differences between the PC and Mac versions of Excel.
- Includes many new end-of-chapter problems at varying levels of difficulty.
Liengmes Guide to Excel 2016 for Scientists and Engineers 1st Table of contents:
Chapter 1: Welcome to Microsoft Excel 2016
Abstract
Exercise 1: Customizing the QAT
Exercise 2: Customizing the Ribbon Control
The Worksheet
Excel 2016 Specifications and Limits
Compatibility With Other Versions
Exercise 3: The Status Bar
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 2: Basic Operations
Abstract
Exercise 1: Simple Arithmetic
Exercise 2: The Mathematical 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
Exercise 7: The Evaluate Formula Tool (PC Only)
Special Symbols, Subscripts, and Superscripts
Mathematical Limitations of Excel
Play It Again, Sam
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 3: Printing in Excel
Abstract
Exercise 1: Quick Print and Print Preview
The Print Preview Dialog
Exercise 2: The Page Layout Tab
Exercise 3: Header & Footers, and Page Breaks
Exercise 4: Documentation and Printing Formulas
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 4: Using Functions
Abstract
Exercise 1: The 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: The ROUND, ROUNDUP, and ROUNDDOWN Functions
Other Rounding Functions
Some Other Mathematical Functions
Array Formulas
Exercise 7: Matrix Functions
Volatility: Calculate Mode
Exercise 8: Solving Systems of Equations
Financial Functions
Exercise 9: Borrower Beware
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 5: Conditional Functions
Abstract
Logical Comparison Operators
Exercise 1: Boolean Functions
Exercise 2: Practical Example
The IF Function
Nested IFs
IF Formulas With Boolean Functions
The IFERROR Function
Exercise 3: Resistors Revisited
The IFNA Function
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 Arithmetic
Exercise 9: Array Formulas
Exercise 10: The SUMPRODUCT Function
Exercise 11: Conditional Formatting
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 6: Data Mining
Abstract
Exercise 1: Importing 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
Importing Data From the Web
Problems
Appendix: Supplementary material
Appendix: Supplementary material
Chapter 7: Charts
Abstract
Exercise 1: An XY Chart
Exercise 2: Plotting Functions
Changing the Position of Axes Crossing
Filtering a Chart With Many Data Series
Finding Roots
Exercise 3: Adding and Deleting Data Series
Exercise 4: XY Chart With Two Y-Axes
Exercise 5: Chart With Control Lines
Exercise 6: Large Numbers and Log Scales
Exercise 7: Error Bars
Exercise 8: Plotting Parametric Equations
Other Chart Types
Exercise 9: Polar (Radar) Chart
Radar Charts
Exercise 10: Surface Charts
Exercise 11: Combination Charts
Exercise 12: Bar Charts
Plotting Sine Curves
Excel 2016: New Charts
Histogram
Box-and-Whisker Chart
Waterfall or Bridge Chart
Map Chart
URLs for Chart Websites
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 8: Regression Analysis
Abstract
Exercise 1: Trendline, SLOPE, and INTERCEPT
Exercise 2: Interpolation and FORECAST
Exercise 3: The LINEST Function
Exercise 4: Fixed Intercept
Exercise 5: Multilinear Regression
Exercise 6: A Polynomial Fit
Exercise 7: A Logarithmic Fit (LOGEST)
Exercise 8: The FORECAST, TREND, and GROWTH functions
Residuals
Exercise 9: Slope and Tangent
Exercise 10: The Analysis ToolPak
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 9: VBA User Defined Functions
Abstract
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…CASE Structure
Exercise 6: Select Example
The FOR…NEXT Structure
The Excel Object Model: An Introduction
Exercise 7: FOR EACH … NEXT—Resistors Revisited
Exercise 8: The DO…LOOP Structure
Variables and Data Types
Input-Output of Arrays
Exercise 9: An Array Function
Using Functions from Other Workbooks
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 10: VBA Subroutines
Abstract
Exercise 1: Recording a Macro
Subroutines That Compute
Notes on the VB Editor
Exercise 2: A Computing Macro
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 (Not Available on Mac)
Problems
Appendix: Supplementary Material
Appendix: Supplementary Material
Chapter 11: Modeling I
Abstract
Exercise 1: Population Model
Exercise 2: Vapor Pressure of Ammonia
Exercise 3: Structure Member Force 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
Appendix: Supplementary Material
Appendix: Supplementary material
Chapter 12: Using Solver
Abstract
Exercise 1: Goal Seek
Exercise 2: Solver as a Root Finder
Solving Equations With Constraints
Exercise 3: Finding Multiple Roots
Exercise 4: Systems of Nonlinear Equations
Exercise 5: Curve Fitting With Solver
Exercise 6: Gaussian Curve Fit
Exercise 7: Solver vs Linearization
Exercise 8: A Minimization Problem
Exercise 9: An Optimization Problem
Problems
Chapter 13: Numerical Integration
Abstract
Exercise 1: The Trapezoid Rule
Exercise 2: Simpson’s ⅓ Rule
Exercise 3: Adding Flexibility
Exercise 4: Going Modular
Exercise 5: Tabular Data
Exercise 6: Gaussian Integration
Exercise 7: Monte Carlo Techniques
Problems
Appendix: Supplementary material
Appendix: Supplementary material
Chapter 14: Differential Equations
Abstract
Exercise 1: Euler’s Method
Exercise 2: The Runge-Kutta Methods
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
Abstract
Exercise 1: The Four-Bar Crank
Exercise 2: Temperature Profile Using Matrix Algebra
Exercise 3: Temperature Profile Using Iteration
Exercise 4: Temperature Profile Using Solver
Exercise 5: Emptying the Tank
Exercise 6: An Improved Tank Emptying Model
Problems
People also search for Liengmes Guide to Excel 2016 for Scientists and Engineers 1st:
liengme’s guide to excel 2016 for scientists and engineers
liengme’s guide to excel 2016 for scientists and engineers pdf
how to open excel 2016 file in excel 2007
how to save excel 97-2003 to excel 2016
Reviews
There are no reviews yet.