Engineering with Excel

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.

Ronald W. Larsen, Ph.D., P.E., is the Department Head of the Chemical and Biological Engineering Department at Montana State University.

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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.