Engineering with Excel, 5th edition

  • Ronald W Larsen


For courses in Introduction to Engineering and Computer Methods for Engineers.


Gives Students A Foundation In Excel Functions For Various Engineering Purposes

Engineering With Excel, 5th Edition introduces students to all of the functions and ways to use Microsoft’s Excel 2016 on Windows 10, the most up-to-date version of the program. The text gives students an understanding of the many ways Excel can be used for engineering purposes. Chapters on graphing, matrix operations, linear regressions and statistics give students a foundation in computational math, while sections on using excel for finance and extending it to other computer programs helps students apply Excel to their broader lives. Finally, students will learn to write their own excel functions.

Table of contents

1. Introduction to Excel


1.1 Introduction


1.2 What’s New in Excel 2016?


1.3 A Little Windows®


1.4 Excel Basics


1.5 Organizing Your Worksheets


1.6 Printing the Worksheet


1.7 Saving and Opening Workbooks, Exiting Excel


2. Using Excel’s Ribbon


2.1 Navigating the Ribbon


2.2 Using the Clipboard Group


2.3 Using the Font Group


2.4 Using the Alignment Group


2.5 Formatting Numbers


2.6 Using the Styles Group


2.7 Inserting, Deleting, and Formatting Rows and Columns


3. Graphing with Excel


3.1 Introduction


3.2 Getting Ready to Graph


3.3 Creating an Xy Scatter Graph


3.4 Editing an Existing Graph


3.5 Printing the Graph


3.6 Other Types of Graphs


3.7 Graphing Web Data


3.8 Importing Text Files 161


iv Contents


4. Excel Functions


4.1 Introduction to Excel Functions


4.2 Excel’s Built-in Functions


4.3 Using the Convert Function to Convert Units


4.4 Simple Math Functions


4.5 Computing Sums


4.6 Trigonometric Functions


4.7 Advanced Math Functions


4.8 Error Function


4.9 Bessel Functions


4.10 Working with Complex Numbers


4.11 Working with Binary, Octal, and Hexadecimal Values


4.12 Miscellaneous Functions


5. Matrix Operations in Excel


5.1 Introduction


5.2 Matrices, Vectors, and Arrays


5.3 How Excel Handles Matrix Math


5.4 Basic Matrix Operations


5.5 Solving Systems of Linear Equations


6. Linear Regression in Excel


6.1 Introduction


6.2 Linear Regression Using Excel Functions


6.3 Linear Regression Using Excel’s Trendlines


6.4 Other Two-Coefficient Linear Regression Models


6.5 Polynomial Regression


6.6 Linear Regression Using Excel’s Regression Analysis Package


7 • Excel’s Statistics Functions


7. Overview


7.2 Populations and Samples


7.3 Standard Deviations and Variances


7.4 Errors, Deviations, and Distributions


7.5 Confidence Intervals


8. Excel’s Financial Functions


8.1 Time, Money, and Cash Flows


8.2 Interest Rates and Compounding


8.3 Moving Amounts Through Time


8.4 Net Present Value


8.5 Internal Rate of Return


8.6 Economic Alternatives: Making Decisions


8.7 Depreciation of Assets


9. Iterative Solutions Using Excel


9.1 Introduction


9.2 Iterative Solutions


9.3 Using a Plot to Search for Roots


9.4 Simple “Guess and Check” Iteration


9.5 Direct Substitution Technique


9.6 Using Goal Seek in Excel


9.7 Introduction to Excel’s Solver


9.8 Optimization Using the Solver


9.9 Nonlinear Regression


9.10 Linear Programming


10. Sharing Excel Information with Other Programs


10.1 Introduction to Sharing Excel Information with other Programs


10.2 Using Copy and Paste to Move Information


10.3 Embedded and Linked Objects


10.4 External Data Sources


11. Excel Pivot Tables


11.1 Introduction


11.2 Preparing to Create a Pivot Table


11.3 A Basic Pivot Table


11.4 Sorting and Filtering a Pivot Table


11.5 Pivoting the Pivot Table


11.6 What Can Be Done with a Pivot Table?


11.7 Pivot Charts


12. Macros and User-Written Functions for Excel


12.1 Introduction


12.2 Macros and Viruses


12.3 Recorded Macros


12.4 Programmed Macros (Vba)


13. User-Written Functions for Excel


13.1 Introduction


13.2 Macro-Enabled Worksheets


13.3 Introduction to Visual Basic for Applications (Vba)


13.4 Writing Your Own Function


13.5 Using Your Functions in Other Workbooks


13.6 Examples of User-Written Functions


14. Programming in Excel with VBA


14.1 Introduction


14.2 Virus Protection and Macro-Enabled Workbooks


14.3 Visual Basic for Applications (VBA)


14.4 Projects, Forms, and Modules


14.5 Flowcharts


14.6 Fundamental Elements of Programming


14.7 Working with Forms


15. Numerical Differentiation Using Excel


15.1 Introduction


15.2 Finite Differences


15.3 Filtering Data


15.4 Curve Fitting and Differentiation


16. Numerical Integration Using Excel


16.1 Introduction


16.2 Integrating for Area Under a Curve


16.3 Integrating for Area Between Two Curves


16.4 Numerical Integration Methods


16.5 Using Regression Equations for Integration


17. Numerical Integration Techniques


for Differential Equations Using Excel


17.1 Introduction


17.2 Euler’s Method


17.3 Fourth-Order Runge—Kutta Method


17.4 Integrating Two Simultaneous Odes by Using the Runge—Kutta Method


17.5 Implicit Integration Methods


For teachers

All the material you need to teach your courses.

Discover teaching material

Published by Pearson (January 5th 2017) - Copyright © 2018