Engineering with Excel

Engineering with Excel, 5th edition

Choose the option that's right for you

Single

$9.99 / mo

4-month minimum term for $39.96

  • Access this eText title
  • Up to 2 devices

Multi

$14.99 / mo

4-month minimum term for $59.96

  • Access over 1,500 titles
  • Up to 2 devices
  • Discounted tutor access

Learn more, spend less

  • Icon

    Listen on the go

    Learn how you like with full eText audio

  • Icon

    Learn anytime, anywhere

    Get the app to access your eText whenever you need it

  • Icon

    Make it your own

    Your notes. Your highlights. Your eText

  • Icon

    Find it fast

    Quickly navigate your eText with search

  • Icon

    Stay organized

    Access all your eTexts in one place

Overview

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: Introductory 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

Introducing Pearson+. Reimagined learning, designed for you. Choose from one eText or over 1,500 eTexts and study tools, all in one place, for one low monthly subscription. A new way to buy books that fits your budget. 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. Plus, with the app, put textbooks in your pocket and learn wherever. It's time to upgrade the textbook and simplify learning, so you can have time to live too.

Pearson eText is an easy-to-use digital textbook available from Pearson+. Make it your own by adding notes and highlights. Download the Pearson+ mobile app to learn on the go, even offline. Listen on the go with our new audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month term. We will charge your payment method each month until your 4-month term has ended. After that, we'll automatically renew your subscription and charge you on a month-to-month basis unless you turn off auto-renewal in My account.

When you purchase a Pearson+ subscription, it will last a minimum of 4 months, and then automatically renew each month thereafter unless you turn off auto-renew in My account.

If you want to stop your subscription at the end of your 4-month term, simply turn off auto-renew from My account. 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 5 titles on the Pearson+ app from My list on each of your authorized 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.