What Every Engineer Should Know About Excel

What Every Engineer Should Know About Excel

4.11 - 1251 ratings - Source

With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by MicrosoftAr ExcelTM. 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!Solver analysis, 179 Optimization problems, 175 feasible region, 176 Ordering data, in Pivot Tables, 208 Ordering formulas, ... deviation, 155 Rotation of 3-D charts, 63 Rows, switching, 17 R-squared, equation for, 31 RSQ worksheet function, 31. S. Simultaneous nonlinear equations, solution with Solver, 103 Sizing, charts, 9 objects in Word, 11 pictures, in Word, ... equations using Solver, 103 Solutions, of simultaneous linear equations, comparison of methods, 111 Solver answeranbsp;...

Title:What Every Engineer Should Know About Excel
Author: J. P. Holman
Publisher:CRC Press - 2006-06-09

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA