Engineering with Excel, 5th edition

  • Ronald W. Larsen

Your access includes:

  • Search, highlight, notes, and more
  • Easily create flashcards
  • Use the app for access anywhere
  • 14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Learn more, spend less

  • Listen on the go

    Learn how you like with full eTextbook audio

  • Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized

    Access all your eTextbooks in one place

  • Easily continue access

    Keep learning with auto-renew

Overview

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.

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

ISBN-13: 9780137518708

Subject: First-Year Engineering

Category: First-Year Engineering

Overview

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

Pearson+ is your 1-stop shop with eTextbooks, study tools and exam prep features designed to help students get better grades in college. eTextbooks come with built-in tools that simplify studying, like flashcards, audiobook and search. Pearson+ also features Channels, which includes practice problems, study guides, Q&A with experts, video lessons that help you understand tricky topics and more—all in one place. Channels can be purchased separately or added on to your eTextbook at the time of purchase as part of the Study & Exam Prep Pack.

A Pearson eTextbook is an easy-to-use digital version of your book for class that includes upgraded study tools to help you learn how you learn best. Use enhanced search to find what you need within your eTextbook, highlight and make notes to mark important info, generate flashcards to test your knowledge, and use audio to listen to the text. Every feature is designed to help you learn more efficiently and get results. Plus, you can learn on the go with the Pearson+ app. Find this and more in your eTextbook, available in Pearson+.

The Study & Exam Prep Pack includes practice problems, study guides, Q&A with experts, Channels video lessons that help you understand tricky topics and more. It can be added on to your eTextbook or your MyLab and Mastering learning platform at the time of purchase.

Your eTextbook subscription gives you access for 4 months. You can 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 ends. You can turn on auto‑renew in My account at any time to continue your subscription before your 4‑month term ends.

When you purchase an eTextbook subscription, it will last 4 months. You can renew your subscription by selecting Extend subscription on the Manage subscription page in My account before your initial term ends.

If you extend your subscription, we'll automatically charge you every month. If you made a one‑time payment for your initial 4‑month term, you'll now pay monthly. To make sure your learning is uninterrupted, please check your card details.

To avoid the next payment charge, select Cancel subscription on the Manage subscription page in My account before the renewal date. You can subscribe again in the future by purchasing another eTextbook subscription.

Channels is a video platform with thousands of explanations, solutions and practice problems to help you do homework and prep for exams. Videos are personalized to your course, and tutors walk you through solutions. Plus, interactive AI‑powered summaries and a social community help you better understand lessons from class.

Channels is an additional tool to help you with your studies. This means you can use Channels even if your course uses a non‑Pearson textbook.

When you choose a Channels subscription, you're signing up for a 1‑month, 3‑month or 12‑month term and you make an upfront payment for your subscription. By default, these subscriptions auto‑renew at the frequency you select during checkout.

When you purchase a Channels subscription it will last 1 month, 3 months or 12 months, depending on the plan you chose. Your subscription will automatically renew at the end of your term unless you cancel it.

We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details.