Engineering with Excel, 5th edition

Choose the option that's right for you

$9.99 / mo

4-month term, pay monthly or pay $39.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

$14.99 / mo

4-month term, pay monthly or pay $59.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

Learn more, spend less

  • Listen on the go

    Learn how you like with full eTextbook audio

  • Learn anytime, anywhere

    Get the app to access your eTextbook whenever you need it

  • Make it your own

    Your notes. Your highlights. Your eTextbook

  • Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized

    Access all your eTextbooks in one place


Engineering with Excel® helps you learn how to use Excel functions for various engineering purposes. Chapters on graphing, matrix operations, linear regressions and statistics provide a foundation in computational math. Sections on using Excel for finance help you apply Excel in your life outside the course.

Published by Pearson (July 14th 2021) - Copyright © 2018

ISBN-13: 9780137518708

Subject: First-Year Engineering

Category: First-Year Engineering

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
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.1 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

Your questions answered

Choose from one eTextbook or over 1,500 eTextbooks and study tools, all in one place, for one low monthly subscription. A Single plan includes the use of 1 eTextbook title and study tools. A Multi plan gives you access to more than 1,500 eTextbook titles and study tools. Plus, with the app, put textbooks in your pocket and learn wherever.

Make the most of your study time with offline access, enhanced search, notes and flashcards — to get organized, get the work done quicker and get results.

A Pearson eTextbook is an easy-to-use digital version of the book. You can add notes and highlights, plus learn on the go with the Pearson+ mobile app. Listen on the go with the audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month 'term'. You can opt to make a one-time payment for the initial 4-month term or pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 4-month term has ended. You can turn on auto-renew in My account at any time to continue your subscription before your 4-month term has ended.

When you purchase a Pearson+ subscription, it will last 4 months. Before your initial 4-month term ends, you can extend your subscription by turning auto-renew on in My account.

If you turn auto-renew on, we’ll automatically renew your subscription and charge you every month until you turn off auto-renew. If you made a one-time payment for your initial 4-month term, you’ll now pay monthly.

To avoid the next payment charge, make sure you turn auto renewal off 1 day before the auto renewal date. You can subscribe again after auto-renew has been turned off by purchasing another Pearson+ subscription. We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details before your first monthly payment.

With a Multi Pearson+ subscription plan, you can download up to 10 titles from your library on each of your authorized smartphone and tablet devices every month.

When you’re using your Multi Pearson+ subscription plan in a browser, you can select and read from as many titles as you like.