What Every Engineer Should Know about Excel Second Edition By Jack P. Holman and Blake K. Holman

What Every Engineer Should Know about Excel Second Edition By Jack P. Holman and Blake K. Holman

Contents:

Chapter 1. Introduction

Chapter 2. Miscellaneous Operations in Excel and Word

Chapter 3. Charts and Graphs

Chapter 4. Line Drawings, Embedded Objects, Equations, and Symbols in Excel

Chapter 5. Solution of Equations

Chapter 6. Other Operations

Chapter 7. Financial Functions and Calculations

Chapter 8. Optimization Problems

Chapter 9. Pivot Tables

Chapter 10. Data Management Resources in Excel

Chapter 11. Office 365 and Integration with Cloud Resources

Preface:

This collection of materials involving operations in Microsoft Excel is intended primarily for engineers, although many of the displays and topics will be of interest to other readers as well. The procedures have been generated randomly as individual segments, which were distributed to classes as the need arose. They do not take the place of the many excellent books on the subjects of numerical methods, statistics, engineering analysis, or the information that is available through the Help features of the software packages. Some of the suggestions offered will be obvious to an experienced software user but will be less apparent or even eye-opening to others. It is this latter group for whom the collection was assembled. Some of the materials were written for use in classes in engineering laboratory and heat-transfer subjects, so several of the examples are slanted in the direction of these applications. Even so, topics such as solutions to simultaneous linear and nonlinear equations and uses of graphing techniques are pervasive and easily extended to other applications. The reader will notice that a basic familiarity with spreadsheets, the formats for entering equations, and a basic knowledge of graphs are assumed. A basic acquaintance with Microsoft Word is also expected, including simple editing operations.