What Every Engineer Should Know About Excel

J.P. Holman

248 pages, parution le 09/06/2006

Ajouter à une liste

Indisponible

Résumé

With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft Excel. The software is nearly ubiquitous and understanding its capabilities is an enormous benefit to engineers in almost any field and at all levels of experience. What Every Engineer Should Know About Excel offers in nine self-contained chapters a practical guide to the features and functions that can be used, for example, to solve equations and systems of equations, build charts and graphs, create line drawings, and perform optimizations. The author uses examples and screenshots to walk you through the steps and build a strong understanding of the material.

With this book, you will learn how 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!

L'auteur - J.P. Holman

J. P. Holman : Southern Methodist University, Dallas, Texas, USA.

Sommaire

Introduction
Miscellaneous operations in Excel and Word
Charts and graphs
Line drawings and embedded objects in Excel
Solution of equations
Other operations
Financial functions and calculations
Optimization problems
Pivot tables

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Taylor and Francis Books
Auteur(s)	J.P. Holman
Parution	09/06/2006
Nb. de pages	248
Format	17,5 x25,5
Couverture	Relié
Poids	440g
Intérieur	Noir et Blanc
EAN13	9780849373268
ISBN13	978-0-8493-7326-8