What Every Engineer Should Know About Excel, Second Edition

J. P. Holman, Blake K. Holman

October 12, 2017 by CRC Press
Textbook - 229 Pages - 203 B/W Illustrations
ISBN 9781138035300 - CAT# K31700
Series: What Every Engineer Should Know

USD$59.95

Add to Wish List
FREE Standard Shipping!

Features

With this book you will learn to

  • Set up the keyboard for direct entry of most math and Greek symbols
  • Build a default scatter graph that is applicable to most simple presentations with little cosmetic modification
  • Apply many types of formats to adjust the cosmetics of graphs
  • Use 3D surface and area charts for data and functional representations, with associated cosmetic adjustments
  • Correlate data with various types of functional relations
  • Use line drawing tools to construct simple schematics or other diagrams
  • Solve linear and nonlinear sets of equations using multiple methods
  • Curve student grades using Excel probability functions
  • Model device performance using different types of regression analysis involving multiple variables
  • Manipulate Excel financial functions
  • Calculate retirement accumulation with variable contribution rate and retirement payouts to match increases in inflation
  • Apply Excel methods for optimization problems with both linear and nonlinear relations
  • Use pivot tables to manipulate both experimental data and analytical relationships
  • Calculate experimental uncertainties using Excel
  • And much more!

Summary

Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program, using examples and screenshots to walk readers through the steps to build a strong understanding of the material. This second edition is updated to reflect the latest version of Excel (2016) and expands its scope to include data management, connectivity to external data sources, and integration with "the cloud" for optimal use of the Excel product. It also introduces the ribbon bar navigation prevalent in Microsoft products beginning with the 2007 version of MS Office. Covering a variety of topics in self-contained chapters, this handy guide will also prove useful for professionals in IT, finance, and real estate.

Instructors

We provide complimentary e-inspection copies of primary textbooks to instructors considering our books for course adoption.

Request an
e-inspection copy

Share this Title